Create the database and the necessary tables using MySQL based upon the provided ERD below. Establish referential
Question:
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.
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi