SQL Database Design » 13. Design Heuristics

13. Design Heuristics

Table of Contents

In database design, you will usually follow one of two basic paths: you either have an existing conceptual ER or UML model which you want to translate to a logical model or you create the logical model right away. Both have the same consequences: you must translate higher-level concepts to relational facts and keep making design decisions according to the current project.

The goal of this section is to ease your decision-making processes by discussing available options as presented in the previous sections. This includes primary key types, translation of referential relationships (association, aggregation, and composition) and inheritance, dependent keys, use of predefined values, global constants, and other topics.

Last updated: 2010-08-04