Chapter 5. Logical Database Design
5.1. Introduction
If we produced a conceptual data model and had it effectively reviewed and verified, the next step would be to translate it into a logical data model suitable for implementation using the target database management system (DBMS).
In this chapter we look at the most common situation (in which the DBMS is relational) and describe the transformations and design decisions that we need to apply to the conceptual model to produce a logical model suitable for direct implementation as a relational database. Later it may be necessary to make some changes to this initial relational model to achieve performance goals; for this purpose we will produce a physical data model.
The advantages of producing ...
Get Database Design: Know It All now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
