undefined

Given the ER diagram and relation schemas, create SQL statements to implement the design. ER diagram: Start date DEPARTMENT MANAGES EMPLOYEE Name Number {Locations) SSN WORKS FOR Address Salary Gender Bdate Supervisee Supervisor WORKS_ON CONTROLS HAS SUPERVISES #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)