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.