Question: Create SQL statements to implement the design Given the ER diagram and relation schemas, create SQL statements to implement the design. ER diagram: Start date
Create SQL statements to implement the design

Given the ER diagram and relation schemas, create SQL statements to implement the design. ER diagram: Start date DEPARTMENT MANAGES Name EMPLOYEE Number {Locations) SSN Address WORKS Salary FOR Gender Bdate Supervisee WORKS_ON Supervisor CONTROLS SUPERVISES HAS #OfHours DEPENDENT PROJECT Name Gender Bdate Relationship Name Number Description Relation Schemas: Employee (SSN, address, salary, gender, birth_date, department_number) Department department number, department_name, mgr_ssn, start_date) Dependent (SSN, name, gender, birth_date, relationship) Project (project_number, project_name, description, department_number) Department Location (department_number, location) Works_on (SSN, project_number, num_of_hours) Supervises (supervisee_ssn, supervisor_ssn)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
