Categories
Computer science

Module 03 Course Project – ER Diagram and Implementing the Database During the R

Need Help With your assignment? Get expert academic writing assistance! We can write any paper on any subject within the tightest time.

Hire A Writer

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 module’s 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 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.
Submit your completed assignment by following the directions linked below. Please check the Course Calendar for specific due dates.
Save your assignment as a Microsoft Word document. (Mac users, please remember to append the “.docx” extension to the filename.) The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below:
Jstudent_exampleproblem_101504

Need Help With your assignment? Get expert academic writing assistance! We can write any paper on any subject within the tightest time.

Hire A Writer