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
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 infor-mation 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 birthdate 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started