Consider the following ER diagram, which shows aspects of a construction project management system. 10 (PK)...

 

Transcribed Image Text:

Consider the following ER diagram, which shows aspects of a construction project management system. 10 (PK) name C BankAccom 858 (PK) AccountNo (PK) siges signDace Project Manager employeelD (PK) name N Contract o contracto (PK) startDate endDate totalFee ContiPre address (PK) roomCount noOfFloors task (PK) fee balance ON Subcontract supervises Contractor ABN (PK) phoneNo workon You are requested to map the above ER diagram into a relational database schema. Show every step of the mapping. No marks are awarded to the final schema if you do not show the partially built schema at the end of each step. Clearly indicate the primary key (underlined) and foreign keys (with an asterisk) in each relation. Consider the following ER diagram, which shows aspects of a construction project management system. 10 (PK) name C BankAccom 858 (PK) AccountNo (PK) siges signDace Project Manager employeelD (PK) name N Contract o contracto (PK) startDate endDate totalFee ContiPre address (PK) roomCount noOfFloors task (PK) fee balance ON Subcontract supervises Contractor ABN (PK) phoneNo workon You are requested to map the above ER diagram into a relational database schema. Show every step of the mapping. No marks are awarded to the final schema if you do not show the partially built schema at the end of each step. Clearly indicate the primary key (underlined) and foreign keys (with an asterisk) in each relation.