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.