Chapter 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 ...

Get Database Administration: The Complete Guide to Practices and Procedures now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.