1.4.07. ER to Relational mapping

  • Step-by-step approach
  1. Strong entities
    • Create relation including (simplified) attributes
  2. Weak entities
    • Create relation inc. attr, foreign/pri key of owner
  3. Binary relationship S:T, 1:1
    • Choose relation, say S (with total participation) and inc. foreign/pri
      key of T
    • inc. relationship attributes