PHYSICAL DATABASE DESIGN

Once the conceptual data model is complete it provides the start point for the design of the physical database.

Aside: When new to data modelling some 15 years ago (before the widespread use of drawing packages and tools to support data modelling), I naively asked a consultant when I would know that a data model was complete. The answer I got was ‘When the correction fluid on the model is so thick that it is able to stand on its edge’. The implication is that even an experienced data modeller has to rework the model many times.

The conceptual data model, with its entities, attributes and relationships, does not presuppose the form of the implemented database. Because the model is in Boyce–Codd normal form, it is very ...

Get Principles of Data Management 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.