Entity Relationship Diagram

Entity Relationship Diagram

Create an Entity-Relationship diagram for the information you will need. Be sure to clearly name the entities and the relationships. Include and indicate the primary key attributes, as well as any foreign keys, or other attributes implied by the materials. Determine and indicate the cardinality of each relationship.

Provide a normalized version of the diagram in at least Third Normal Form.

Explain the reason for any model changes you made as part of the normalization. Specify how entities, relationships, and their attributes will be represented. Consider the common and urgent activities that will access this information.

Explain where you might use denormalization, indexing, or other techniques to improve performance for these operations, and why.

Combine all items and submit in a 1- to 2-page APA formatted paper.

Solution Preview

Entity Relationship Diagram

The entity relationship diagram is a diagram that visually represents various entities in a given system, and the relationship between these entities. It is also referred to as ER models or ERD’s. Data modeling began to be a necessity in the 1970s, although no standard approach of data modeling had been established yet.

(287 words)