Relational Database Management

Write an Entity Relationship (ER) Diagram document of 4–5 pages based on the conceptual model that you completed in Week 2. Include the following:

Use Visio software application to create an ER diagram that outlines the primary keys for all entities, the relationships between different entities, the attributes (and data types) for each entity, and junction tables to support any many-to-many relationships
A design that meets the minimum of third normal form (3NF)
A description of the steps that you took to ensure that your design was normalized to the desired level and any exceptions you had to make to prevent anomalies and a loss in data integrity
Add section to the Entity Relationship (ER) Diagram section of your database system plan
Name the document as follows:
- yourname_IT610_
  
  _IP3.doc
All sources should be cited both in the text and in the References section by using APA format.
Submit the document for grading.

Please submit your assignment.

For assistance with your assignment, please use your text, Web resources, and all course materials.