Translate the following ER diagram into relational schema and write the SQL DDL commands to create the resulting relations. Identify any constraints which were in the ER diagram, but that you were not able to capture when creating the relations. If you had more than one option in how to convert an object, briefly explain why you choose the implementation which you did.

 

Transcribed Image Text:

SIN pay_rate Hourly Emp Name Overlap: allowed Covering: false hours Phone Employee SA Contract Emp totalvage Mentoring Email Salary Mages SIN pay_rate Hourly Emp Name Overlap: allowed Covering: false hours Phone Employee SA Contract Emp totalvage Mentoring Email Salary Mages