Menu Search Sign up

Mapping between E-R Model and Relational Model

E-R -> Relational
1) One-One:     repeat the primary key of either side on
        the other side
2) One-Many:    repeat the primary key of the 'one' side
        on the 'many' side
3) Many-Many:   create an intersection entity to turn
        many-many to one-many-one , by repeating
        the primary key of both sides in the
        intersection entity 2.18, 2.19    
4) Intra-Table: create an association entity by
        repeating the primary key twice