ABSTRACT
Relational database design is a process for transforming a data model into a relational database. A data model is a disciplined map of data requirements. This chapter describes a relational database design methodology that addresses the implementation of each construct of the data model. The relational design methodology addresses the implementation of both structural constructs and integrity constructs. The success of relational databases is measured by how easily they accommodate a multiplicity of needs: different types of users, various access patterns and requirements, and changing business and technological issues. The databases are more likely to support these various needs if the database design is founded on a data-driven philosophy. Major constructs of the relational data model are relational tables, primary keys, foreign keys, columns, and integrity rules. It is no coincidence that data modeling terminology resembles relational model terminology because the concepts themselves are similar.
