Conversion to Relational Model Part 5

Conversion to Relational Model 

(Many-many-many ternary relationship)

                                 Fig: Many-many-many Ternary ERD

 

The above ER diagram is transformed to the following relational model:

Patient:

pNr | pName  

Doctor:

dNr | dName | salary

MonthlyReport:                             

rNr | date | author

admin:

dNr | pNr | rNr