June 2004
Intermediate to advanced
848 pages
21h 28m
English
Let's say more about the relationship between a foreign key and the table where it is a primary key. That relationship can be one-to-one, one-to-many, or many-to-many.
A one-to-one relationship says that the two things are matched exactly.The relationship between ship and captain is one-to-one. Each ship has one captain, and each captain has one ship (ignoring real world details like mutinous ships, captains waiting for a command, etc.).
As you might guess, a one-to-many relationship means that one thing in this table corresponds to potentially many things in that table. Each individual ship has multiple sailors, so the ship/crew member relationship is one-to-many. ...
Read now
Unlock full access