The E/R model

• Entities vs. relationships

• Attributes for entities and relationships

• Keys and weak entities

• Cardinality constraints

• Participation (key) constraints

• Translation to relations:

  • Entity becomes relation
  • Relationship becomes relation iff it is many-many
  • Other relationships: key of “parent” goes with “child”

Previous slide

Next slide

Back to first slide

View graphic version