Module 03 Course Project – ER Diagram and Implementing the Database
During the Requirements Phase in Module 02, you created a Requirements Document and stated a recommendation. This modules project assignment will be focused on the Design and Implementation Phases. In this module, you will create a normalized ER diagram in MySQL Workbench for the database described in your Requirements Document. Once the ER diagram is complete, you will create a Forward Engineered SQL script from the ER diagram. You will then 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 MySQLs 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 MySQLs CLI screen shot of the list of tables in the database.
The MySQLs CLI screen shots of the structures of all of the tables in the database.
