Transform the ER Diagram shown into tables.

Create a MYSQL script in a text file SQL that will execute and create these tables with the necessary keys and constraints.

NOTES:

You may NOT disable foreign key constraints in your script

Your script must first drop tables if they exist then create the necessary tables.

You must include engine=InnoDB at the end of each Create table statement.

DEPARTMENT SSNAMESTATUSCITY SUPPLIER DEPT EMP PROJ WORK SUPP PART P ENAME 1M EMPLOYEE PROJECT SUPP PART PROJ MANAGER FIRSTMI LAST QTY SALARY EMP DEP PART MI EXP IMPI M ART DEPENDENT STRUCTUR QTY