Entity Relationships.

1. Create an ER Diagram using MySQL Workbench for the database you developed in Week 3.( Attached)
2. Take a screenshot of the ER Diagram and export the diagram to a .mwb file.(completed)

3. In a Word document, address the following items about the database:
-Explain the relationship types such as 1:M, 1:1, M:M, or M:1. Be sure to indicate the determined factors from the previous assignment requirement.

-Determine the normal form of your database design. Justify your choice with evidence from your design and the definitions of the normal forms.

-If your design is not in at least third normal form, revise it so it is in at least third normal form. Provide the revised design in addition to the original. Justify why the new design is now in at least third normal form with evidence from the design and the definitions of the normal forms.

-Provide five specific examples of data anomalies (including at least one insert, update, and delete anomaly each) that might happen if your database were not in at least third normal form. Provide sample non-normalized data and tables, the action taken, and the resulting anomalous data. Explain why your design avoids each possible problem.

Label each of the screenshots in the document to show which part of the assignment each screenshot is supposed to fulfill.

Length: 3-4 pages, not including diagrams, title, and reference pages

The completed assignment should address all of the assignment requirements, exhibit evidence of concept knowledge, and demonstrate thoughtful consideration of the content presented in the course. The writing should integrate scholarly resources, reflect academic expectations and current APA standards (as required)

"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"