4. Database Design
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.
From Logical Model to Physical Database
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 ...