Relational Database Design

BLUF (Bottom Line Up Front)

We will look closer at Database Design (Entities, Attributes, and Relationships, as well as cardinality.) Additionally, we will discuss Relationship participation and degrees.

Data modeling is the first step in the database design journey, serving as a bridge between real-world objects and the database model that is implemented in the computer. Therefore, the importance of data-modeling details, expressed graphically through entity relationship diagrams (ERDs), cannot be overstated.

For example, the basic components of entities and relationships and their representation should now be familiar to you. This chapter goes much deeper, analyzing the graphic depiction of relationships among the entities and showing how those depictions help you summarize the wealth of data required to implement a successful design.