A Role Playing Simulation On Database Design
Feedback on Your Choices in Volunteer Now: 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:
Your Choices
Correct Choices
Points Earned
Organizations
Volunteers
0
Volunteers
Organizations
0
VolunteerActivities
VolunteerActivities
3
Total Points
9
Well done!
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
Correct Choices
Your Choices
Points
A. Different people might have the same name.
5
B. Sometimes people change their names.
5
C. There are too many possible names.
5
D. The same name is spelled differently in different languages.
5
Total Points
20
4. What would be the problems if we use volunteer names for their IDs?
Points: 15 out of 15
Correct Choices
Your Choices
Points
A. Social Security numbers are confidential.
5
B. Social Security numbers are too hard to remember.
5
C. Non US citizens may not have Social Security numbers.
5
Total Points
15
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.
Volunteers-Your Choices
Volunteers-Correct
Organizations-Your Choices
Organizations-Correct
Name: Madisyn Olguin
1. Entity Choices
Points: 9 out of 9
Your choices for the entities are listed below, along with correct answers:
Your Choices
Correct Choices
Points Earned
Organizations
Volunteers
0
Volunteers
Organizations
0
VolunteerActivities
VolunteerActivities
3
Total Points
9
Well done!
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
Correct Choices
Your Choices
Points
A. Different people might have the same name.
5
B. Sometimes people change their names.
5
C. There are too many possible names.
5
D. The same name is spelled differently in different languages.
5
Total Points
20
4. What would be the problems if we use volunteer names for their IDs?
Points: 15 out of 15
Correct Choices
Your Choices
Points
A. Social Security numbers are confidential.
5
B. Social Security numbers are too hard to remember.
5
C. Non US citizens may not have Social Security numbers.
5
Total Points
15
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.
Volunteers-Your Choices
Volunteers-Correct
Organizations-Your Choices
Organizations-Correct