Create the database and the necessary tables using MySQL based upon the provided ERD below. Establish referential integrity (PK, FK) between the necessary attributes. Do not useyour ERD from Part 1.
Instructions
Part II
 Look at the data supplied by the ABC Company; your database needs to be able to accommodate all the given data.
 Create tables for each of the entities. This can be done by creating a new schema based upon the ABC Company ERD provided. Table and Column names MUST match the provided ERD diagram. Establish referential integrity between the necessary attributes.Import the Data in the appropriate tables. Verify that the data loaded into the MySQL database is the same as the csv file.The SQL Statements used to create the database and its respective tables 

o If you established referential integrity after table creation include the SQL Statements used 

o Screenshots verifying that your statements ran correctly
o A screenshot showing the data in each of the tables (Hint use a query). Make
sure the screenshot shows the number of rows in the table.
o Screenshots showing the Type of each column in each table after importing the
data. This is the wrench icon after the table name and the Columns tab.

 

maintenance id INT date performed DATE condition VARCHAR(10) description TEXT emp_id INT facility_id INT Indexes department id INT name VARCHAR (50) Indexes region id INT Ohq_state VARCHAR(2) H Ohq city VARCHAR(50) Indexes employee id INT first_name VARCHAR(50) last_name VARCHAR (100) LH date hired DATE salary DECIMAL (9,2) Ophone VARCHAR(10) street VARCHAR(150) Ostate VARCHAR(2) dity VARCHAR(50) 1 Ozip INT department_id INT Indexes ABC Company Part 2 facility id INT name VARCHAR(100) description VARCHAR(250) capacity INT Ostreet VARCHAR(150) city VARCHAR (50) Ostate VARCHAR(2) O zip INT category_id INT region_id INT Indexes *+-+ strike strike date DATE reason TEXT employee_id INT rental jd INT Indexes P+1 T category id INT name VARCHAR(25) Indexes rental id INT begdate DATE enddate DATE purpose VARCHAR(50) Opay method VARCHAR (20) + amount DECIMAL (15,2) #date paid DATE facility_id INT customer_id INT Indexes customer id INT first_nam e VARCHAR(50) last name VARCHAR(100) city VARCHAR(50) street VARCHAR (150) Ozip code INT Ostate VARCHAR (2) dob DATE identification VARCHAR(50) Indexes