A Role Playing Simulation On Database Design

Topics: Foreign key, Relational model, Data modeling Pages: 5 (1302 words) Published: February 16, 2015
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

VolunteerID

VolunteerID

OrganizationID

FirstName

LastName

OrganizationName

OrganizationName

LastName

FirstName

OrganizationPhone

OrganizationPhone

Gender

Gender

OrganizationContactPerson

CollegeMajor

CollegeMajor

OrganizationAddress

BirthDate

BirthDate

OrganizationCity

CellPhone

CellPhone

OrganizationStateCode

ForeignLanguageSpoken

ForeignLanguageSpoken

OrganizationZipCode

OrganizationID

OrganizationContactPerson
OrganizationAddress
OrganizationCity
OrganizationStateCode
OrganizationZipCode

VolunteerActivities-Your

VolunteerActivities-Correct

choices
VolunteerActivityID

VolunteerActivityID

ActivityType

ActivityType

VolunteerActivityDateTime

VolunteerActivityDateTime

ActivityComment

ActivityComment

VolunteerID

VolunteerID

OrganizationID

OrganizationID

You also added the following new attributes. This simulation looked for text that contained "email" or "e-mail" because of its importance to the Volunteers, table and the Organizations table. If it appeared, you earned bonus points. You also earned bonus points if you properly added the foreign keys VolunteerID and OrganizationID to the VolunteerActivities table.

Volunteers-Your Choices

Organizations-Your Choices

VolunteerActivities-Your
Choices

Email

6. If we didn't include birthdate, then what difference would it make? Which of these do you think would happen?
Points: 2 out of 2

Correct Choice

Your Choice

Points

A. We would have no way of knowing how old a volunteer must be before he or she is legally permitted to supervise children. B. We wouldn't know if a volunteer is old enough to meet a minimum age requirement of an organization.

2

C. We wouldn't know if the number of volunteers at an organization is increasing from one year to the next.
Total Points...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Database Design Essay
  • Database Modeling And Design Essay
  • Database Design: Notes Essay
  • Essay about Working with Database Design
  • Database Design and Development Essay
  • Database Design & Development Essay
  • Database Design P1, M1 & D1 Essay
  • Database Design Essay

Become a StudyMode Member

Sign Up - It's Free