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 (https://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 the target 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

 
 
sitemap

Unable to load book!

The book could not be loaded.

(try again in a couple of minutes)

manning.com homepage
test yourself with a liveTest