Represents ER model using tables

• Basic rules:

  • one table for one entity set
    • one column for one attribute
  • one table for one relationship set
    • columns are:
      • key attributes of all participating entity sets
      • all descriptive attributes

• Exceptions

  • 1:N relationships can be omitted

Previous slide

Back to first slide

View graphic version