DBM/502 DBM502 DBM 502 WEEK 2 ASSIGNMENT 2
- University of Phoenix / DBM 502
- 04 Oct 2017
- Price: $10
- Other / Other
DBM 502 WEEK 2 ASSIGNMENT 2
Assignment 2
Individual: Entity Relationship Diagram (ERD)
Review the materials you have, describing the information to be captured and the overall project.
Create an Entity-Relationship diagram (ERD) for the information you will need, as defined in your week 1 assignment, similar to examples covered in class, Crow's Foot style. Be sure to clearly show and name all the entities, attributes 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, with the ERD copied and pasted in the paper.
Submit your assignment using the Assignment Files tab.
USA 
India