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