Attribute relationships
One to One
- Each customer has only one SSN.
One to Many
- Each customer can have several addresses.
Many to Many
- Each customer can buy many items, an item can be purchased by many customers (item means SKU, not the same physical object).
Many to One
- Several phone numbers can belong to one store, and one store only.