Database Project

1. Create an Entity Relationship Diagram (ERD) to represent the data requirements of the business. Use Microsoft Word or Visio to create this ERD. Note: if using Visio to create your ERD to save your assignment as a VSD file rather than as a Word document.

2. Each entity must be named and the identifier(s) (primary key) listed. Include associate entities and supply identifiers for these also. If a primary key identifier is not specifically mentioned, create one! Make sure that you include identifiers for the associative entities also.

3. Resolve Many-to-Many relationships into two relationships.

4. All cardinalities and modalities should be clearly marked on the ERD. Attributes other than the identifiers may be included.

5. Submit your ERD in a Word document.