2. (20 pts) The relational schema of the COMPANY database is as follows. You should have the data imported as a result of Week 1 Assessment Part II. EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Super ssn Dno DEPARTMENT Dname Dnumber Mgr ssnMgr start date DEPT LOCATIONS PROJECT Pname PnumberPlocation Dnum WORKS ON Hours DEPENDENT name | Se date | Relationship equirements 1. Use ALTER TABLE statements to i. specify PK and FK in each table, and ii. specify update operation options so that, if you delete/update an employee's unique identifier, all his or her records of working on any projects are also deleted/updated, AND all his or her dependent's record should reflect the change as well 2. Come up with a few queries to test that the constraints have been implemented. You should have at least four tests: i. test that entity integrity constraint is in place after you specify PK ii. test that referential integrity constraint is in place after you specify FK iii. test that a delete operation is working as desired iv. test that an modify option is working as desired Deliverables (Submit the following in one zip file) * Submit ONE sgl file with all the statements and tests. Use comment syntax comment', or # to label where one part ends and the other part starts. EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Super_ssn Dno DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date DEPT LOCATIONS DnumberDlocation PROJECT Pname Pnumber Plocation Dnum WORKS ON Essn Pno Hours DEPENDENT Essn Dependent name Sex Bdate Relationship