Chapter 5
The Relational Data Model
Abstract
This chapter presents the theory of the relational data model. It discusses characteristics of the columns and rows in a table, the importance of choosing good primary keys, using concatenated primary keys, using foreign keys to represent data relationships, referential integrity, views, and the use of data dictionary tables to store a database design.
Keywords
relational data model
database tables
relations
primary keys
foreign keys
database views
data dictionaries
referential integrity
Once you have a completed ER diagram, you can translate that conceptual logical schema into the formal data model required by your DBMS. Today, most new database installations are based on the relational data model. We ...
Get Relational Database Design and Implementation, 4th Edition 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.
