This is for MySQL

First, review the database schema, for each one of the "arrows" in the diagram, you will create a foreign key on the relevant table. EMPLOYEE Fname Minit Lname Bdate Address Sex Salary Super_ssn Dno Ssn AAAA DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date A DEPT_LOCATIONS Dnumber Dlocation PROJECT When creating the foreign keys, you must make sure of the following additional requirements: An employee cannot be deleted if there's a dependent or if the employee is working on a project. Pname Pnumber Plocation Dnum WORKS ON Essn Pno Hours DEPENDENT Essn Dependent_name If an employee is deleted and the employee is the manager of a department or supervisor of another employee, the DBMS should change the relevant attributes to NULL on the child relations. Sex Bdate Relationship If a department is deleted, all department locations must be deleted as well, however, a department MUST NOT be deleted if there's any project or employee assigned to that department