Create a normalized ER diagram in MySQL Workbench for the database described in your Requirements Document. Once the ER diagram is complete, create a Forward Engineered SQL script from the ER diagram. Run the script to implement the database, tables, and relationships given in the ER diagram.
Requirements
Create a normalized ER diagram in MySQL Workbench for the database described in your Requirements Document.
Take a screen shot of the ER diagram.
Using Workbench, create a Forward Engineered SQL script from the ER diagram.
Run the Forward Engineered SQL script to implement the database in MySQL. This must include the creation of all tables and relationships given in the ER diagram.
Use MySQL’s CLI to:
Output a list of the tables that exist in the database.
Output the structure of each table.
Take a screen shot of all of these outputs.
Deliverables
Copy the following items in to a Word document:
The screen shot of the completed ER diagram in Workbench.
The script that was created by Forward Engineering the ER diagram in Workbench.
The MySQL’s CLI screen shot of the list of tables in the database.
The MySQL’s CLI screen shots of the structures of all of the tables in the database.
