1.4.06. Mapping ER to Relation DB tables

  • Intuitive mapping
    • Entities as tables
    • Attributes as columns
  • Relationships are more difficult
  • Key sharing mechanism
    • Foreign key references primary key
  • Where to put the foreign key forms the intuitive guide to the rest of
    the mapping