This is a SQL database project. Please use MySQL Workbench 8.0 to answer the following questions.

A department would like to move its local servers to a computational cloud platform. The administration asked each unit DBA to secure the migration process of their respective databases to the new platforms. A data analyst is assigned to enrich a set of entities with valuable features and produce the resulting output as a script where the DBA can verify and check it into the central database. A data analyst is asked to extract and analyze some data from an existing database with an outdated logical model stored on a particular server. A data analyst needs to see the most recent logical model of the existing database to start extracting required data.

1.) Use the MySQL Workbench tool to create a relational database according to the following schema, which describes all of the required entities and referential integrity constraints.

2.) For each relationship, specify the cardinality ratios and their directions and whether they are one-to-many, one-to-one, or many-to-many.

3.) The description of the attributes of each entity is shown in the following tables

4.) Insert at least three non-empty records into each entity and ensure the consistency of your inputs with the constraints imposed in Step 1.

5.) Use the MySQL Workbench tool to forward engineer the current state of the database, and store the resulting script (SQL format) on your machine. The output script in SQL format. The script should include the structure of the entities in addition to the data stored in these entities. 6.) Use the MySQL Workbench tool to reverse engineer the current state of the database, and store the resulting entity-relationship diagram (MWB format) on your machine. The generated logical data model in MWB format along with a screenshot either in JPG or PNG format. The logical model should represent all the database entities, attributes, keys, entity constraints, and referential integrity constraints.

EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Super_ssn Dno DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date DEPT LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber Plocation Dnum WORKS_ON Essn Pno Hours DEPENDENT Essn Dependent_name Sex Bdate Relationship Entity Name EMPLOYEE Entity Name DEPENDENT Field Data Type Fname VARCHAR(15) Minit CHAR Lname VARCHAR(15) Ssn CHAR(9) Bdate DATE Address VARCHAR(30) Sex CHAR Salary DECIMAL(10,2) Super_ssn CHAR(9) Dno INT Field Data Type Essn CHAR(9) Dependent_name VARCHAR(15) Sex CHAR Bdate DATE Relationship VARCHAR(8) Entity Name PROJECT Field Pname Pnumber Plocation Dnum Data Type VARCHAR(15) INT VARCHAR(15) INT Entity Name DEPT LOCATIONS Field Data Type Dnumber INT Dlocation VARCHAR(15) Entity Name WORKS_ON Field Essn Pno Hours Data Type CH R(9 INT DECIMAL(3,1) Entity Name Field DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date Data Type VARCHAR(15) INT CHAR(9) DATE EMPLOYEE Fname Minit Dno John 5 B T Franklin 5 Alicia J 4 Jennifer S Lname Ssn Bdate Address Sex Salary Super_ssn Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 987654321 Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX F 43000 888665555 Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 333445555 English 453453453 1972-07-31 5631 Rice, Houston, TX F 25000 333445555 Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 25000 987654321 Borg 888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL 4 Ramesh K 5 A 5 Joyce Ahmad V 4 James E 1 DEPARTMENT DEPT_LOCATIONS Dnumber Dlocation Dnumber Mgr_ssn Dname Research Administration Mgr_start_date 1988-05-22 5 333445555 1 Houston 4 987654321 1995-01-01 4 Stafford Bellaire Headquarters 1 888665555 1981-06-19 5 5 Sugarland Houston 5 WORKS ON PROJECT Essn Pno Pname Pnumber Plocation Dnum Hours 32.5 1 1 Bellaire 5 ProductX ProductY 2 7.5 2 5 123456789 123456789 666884444 453453453 Sugarland Houston 3 40.0 Productz 3 5 1 20.0 10 4 Stafford Houston 453453453 2 Computerization Reorganization Newbenefits 20.0 20 1 333445555 2 10.0 30 Stafford 4 333445555 3 10.0 333445555 10 10.0 DEPENDENT 333445555 20 10.0 Essn Sex Dependent_name Alice Bdate 1986-04-05 999887777 30 30.0 333445555 999887777 10 3 T 10.0 333445555 Theodore Relationship Daughter Son Spouse Spouse 987987987 10 35. F. 333445555 987654321 1983-10-25 1958-05-03 1942-02-28 Joy Abner 987987987 30 5.0 M 987654321 30 20.0 123456789 Michael M 1988-01-04 Son 987654321 20 15.0 123456789 Alice F 1988-12-30 IT Daughter Spouse 888665555 20 NULL 123456789 Elizabeth 1967-05-05