Database Solutions: A Step By Step Guide To Building Databases, 2nd edition

Published by Addison-Wesley (November 2, 2007) © 2008

  • Thomas Connolly University of Paisley
  • Carolyn Begg Paisley University
Products list
£43.99
Instant access

Access details

  • Instant access once purchased
  • Fulfilled by VitalSource
  • For titles accompanied by MyLab/Mastering, this eBook does NOT include access to the platform

Features

  • Add notes and highlights
  • Search by keyword or page
Products list
£64.99
Free delivery

Details

  • A print text
  • Free shipping

Are you responsible for designing and creating the databases that keep your business running? Or are you studying for a module in database design? If so, Database Solutions is for you! This fully revised and updated edition will make the database design and build process smoother, quicker and more reliable.

Recipe for database success

  • Take one RDMS – any of the major commercial products will do: Oracle, Informix, SQL Server, Access, Paradox
  • Add one thorough reading of Database Solutions if you are an inexperienced database designer, or one recap of the methodology if you are an old hand
  • Use the design and implementation frameworks to plan your timetable, use a common data model that fits your requirements and adapt as necessary

Part 1 Background
1 Introduction
2 The relational model
3 SQL and QBE
4 The database system development lifecycle
5 Database administration and security Part 2 Database analysis and design techniques
6 Fact-finding
7 Entity-Relationship modeling
8 Normalization Part 3 Logical database design
9 Logical database design - Step 1
10 Logical database design - Step 2
11 Enhanced ER modeling techniquesPart 4 Physical database design
12 Physical database design - Step 3
13 Physical database design - Step 4
14 Physical database design - Steps 5 and 6
15 Physical database design - Step 7
16 Physical database design - Step 8 Part 5 Second worked example
17 PerfectPets - Logical database design
18 PerfectPets - Physical database design Part 6 Current and emerging trends
19 Current and emerging trends Appendices
A Alternative data modeling notations
B Summary of the database design methodology
C Advanced logical database design
D File organizations and indexes
E Common data models Glossary References Index

Need help? Get in touch