Normalizing a Student Activity File: Normalize the file. Show how the logical data model would change...

Transcribed Image Text:

Normalizing a Student Activity File: Normalize the file. Show how the logical data model would change at each step. 0-Normal Form Student PK ssn (a) (b) (c) nameLast nameFirst advisorName advisorPhone activity 1 code activity1description activity1startDate activity2code activity2description activity2startDate activity3code activity3description activity3startDate 1-Normal Form 2-Normal Form 3-Normal Form Normalizing a Student Activity File: Normalize the file. Show how the logical data model would change at each step. 0-Normal Form Student PK ssn (a) (b) (c) nameLast nameFirst advisorName advisorPhone activity 1 code activity1description activity1startDate activity2code activity2description activity2startDate activity3code activity3description activity3startDate 1-Normal Form 2-Normal Form 3-Normal Form

Answer rating: 100% (QA)

Solution To normalize the Student Activity File we need to go through the process of normalization step by step starting from 0Normal Form and moving ... View the full answer