Question

Pretend that you have been asked to build a system that tracks student involvement in activities around campus. You have been given a file with information that needs to be imported into the system, and the file contains the following fields:
■ Student Social Security number (identifier)
■ Activity 1 code (identifier)
■ Activity 1 description
■ Activity 1 start date
■ Activity 1 years with activity
■ Activity 2 code
■ Activity 2 description
■ Activity 2 start date
■ Activity 3 code
■ Activity 3 description
■ Activity 3 start date
■ Activity 3 years with activity
■ Student last name
■ Student first name
■ Student birth date
■ Student age
■ Student advisor name
■ Student advisor phone
Normalize the file. Show how the logical data model would change as you move from 1NF to 2NF to 3NF.



$1.99
Sales2
Views197
Comments0
  • CreatedMarch 13, 2013
  • Files Included
Post your question
5000