chapter five

5 Relationships

 

In this chapter

  • You establish relationships between entities.
  • You identify the cardinality of each relationship.
  • You make decisions on whether to represent some entities as weak entities.
What you need to know

You can find the database design covered in this chapter (so far it’s entities plus relationships) implemented in tools commonly used by practitioners, such as dbdiagram.io, and MySQL Workbench in the GitHub repository (s://github.com/Neo-Hao/grokking-relational-database-design). You can navigate to the chapter_05 folder, and follow the instructions in README.md to load the database design into corresponding tools.

The data types that show up in this chapter are applicable to most RDBMS, such as MySQL, MariaDB, and PostgreSQL. If you are using another RDBMS such as SQL Server or SQLite, you may need to make small modifications to the design by replacing certain data types with their equivalences specific to an RDBMS. Such information can be found in README.md in the chapter_05 folder.

Overview

In this chapter, you will develop your entity-relationship (E-R) diagram for The Sci-Fi Collective online store by establishing relationships among entities you identified in Chapter 4. By doing so, you will learn about important concepts in database design, such as cardinality and dependency.

Entity-relationship models

Connecting related entities

Cardinality

Direction and representation

One-to-one: A perfect match

One-to-many: A love triangle

Many to many: The more the merrier

Strong and weak entities

Identify strong and weak entities in your database

Summary