October 2012
Intermediate to advanced
936 pages
23h 23m
English
Database design is the process of transforming a logical data model into a physical database design and then implementing the physical model as an actual database. More precisely, database design requires up-front data modeling and normalization as discussed in Chapter 3. A logical data model is required before you can even begin to design a physical database. This chapter assumes that the logical data model is complete. The focus of discussion, therefore, will be on producing a physical database from the logical data model.
The physical data model is created by transforming the logical data model into a physical implementation based on the DBMS to be used for deployment. To successfully ...