Skip to Main Content
Database Design for Mere Mortals: 25th Anniversary Edition, 4th Edition
book

Database Design for Mere Mortals: 25th Anniversary Edition, 4th Edition

by Michael J. Hernandez
December 2020
Beginner content levelBeginner
640 pages
14h 45m
English
Addison-Wesley Professional
Content preview from Database Design for Mere Mortals: 25th Anniversary Edition, 4th Edition
Images

10

Table Relationships

There is no substitute for the comfort supplied by the utterly taken-for-granted relationship.

—IRIS MURDOCH

Topics Covered in This Chapter

Why Relationships Are Important

Types of Relationships

Identifying Existing Relationships

Establishing Each Relationship

Refining All Foreign Keys

Establishing Relationship Characteristics

Relationship-Level Integrity

Example: Identifying and Establishing Relationships

Summary

Review Questions

You learned in Chapter 3, “Terminology,” that a relationship exists between two tables when you can, in some way, associate the records of the first table with those of the second. You also ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Relational Database Design and Implementation, 4th Edition

Relational Database Design and Implementation, 4th Edition

Jan L. Harrington
The Manager's Path

The Manager's Path

Camille Fournier
The Manager's Path

The Manager's Path

Camille Fournier

Publisher Resources

ISBN: 9780136788133