A Role Playing Simulation On Database Design
Name: Madisyn Olguin
1. Entity Choices
Points: 9 out of 9
Your choices for the entities are listed below, along with correct answers:
2. Should activities be attributes in the Volunteers table?
Points: 5 out of 5
You selected No. Good choice! Volunteers and VolunteerActivities represent a one to many relationship, so each volunteer can have 0 to more activities. VolunteerActivities should thus be a separate table, that can be linked with a foreign key (VolunteerID) to Volunteers.
3. What would be the problems if we use volunteer names for their IDs?
Points: 20 out of 20
A. Different people might have the same name.
B. Sometimes people change their names.
C. There are too many possible names.
D. The same name is spelled differently in different languages.
4. What would be the problems if we use volunteer names for their IDs?
Points: 15 out of 15
A. Social Security numbers are confidential.
B. Social Security numbers are too hard to remember.
C. Non US citizens may not have Social Security numbers.
5. Attribute Choices
Points: 23 out of 23 + 3 Bonus
Your choices for the attributes for each table are shown below. The listing of "correct" choices is based on using all the available attributes at this stage of the simulation. Note that some attributes are added or deleted based on further discussion in the simulation. Except for the table's primary key, which should be the first attribute in each table, the order of the attributes within a table is not graded.