Converting ER diagrams to Relational Model Part 2

Converting ER diagrams to Relational Model

(One-many relationship)

Add the primary key of the relation with the “1” as foreign key to the relation with the “n”.

The above 1-n relationship in the ER diagram can be converted to a relational model as follows:

Employee:

famName | givenName | salary | dName

          primary key (pk)               foreign key (fk)

Department:

dName | address

 pk