1.4.09. ER to Relational mapping

  1. Binary relationship 1:N
    • Choose relation T (N-side) inc. foreign/pri key of S
  2. Binary relationship M:N
    • Create relation, inc. foreign/pri keys of S&T
  3. Multivalued
    • For each mv_attr, create new relation, inc. foreign/pri key of parent
  4. n-ary relationship
    • Create new relation, inc. all foreign/pri keys of participating
      entities