Database Phase 1

Spring 2015

Database Project
Phase 1 - Entity/Relationship Model

Due: February 16

You now need to construct a complete detailed description of the information that is to be stored in the database (but NOT how it is to be stored). To do this you must provide the following information:

a) An E/R diagram.

b) Give a complete list of the attributes of each entity and relationship in the diagram. Explain any attributes you include that are not obviously needed. You may also wish to explain why some possible attributes were NOT included.

c) For each attribute, give its domain. Be very precise.

d) Give all candidate keys for each entity.

e) Give the functionality of all the relationships in the diagram. Justify these, giving any assumptions you have made.

f) List integrity rules for your database. These are rules that need to be enforced, but are not enforced by the structure of the E/R diagram.

g) Each individual in the team must submit a separate report (NO MORE than 1 page) stating what they believe are the major strengths and weaknesses of the E/R design.