Create a Normalized database that shouldn\'t have any 1NF, 2NF or 3NF violations
ID: 3590598 • Letter: C
Question
Create a Normalized database that shouldn't have any 1NF, 2NF or 3NF violations
Notes:
Each Student can have only one Advisor
Each Advisor can have only one Office Room
Each Office Room is occupied by only one Advisor
Create a Normalized database that shouldn't have any 1NF, 2NF or 3NF violations
Student# Student_Name Advisor Adv-Room Course1 Course1_Name Course2 Course2_Name Course3 Course3_Name 1022 John Doe Jones 412 101-07 Analytics 143-01 Biology 159-02 Physics 4123 Jill Maher Smith 216 201-01 Statistics 211-02 Java 214-01 History 3456 Matt Samuels Jones 412 101-07 Analytics 143-01 Biology 159-02 Physics 3751 Megan Cramer Taylor 322 107-08 Economics 135-03 Sociology 147-11 ChemistryExplanation / Answer
For the given relation Student# is the key,the given relation is in 1NF,2NF but not in 3NF, so divide the relation as R1(Student#, Student_Name,Advisor)
R2(Advisor,Adv-Room, Course1,Courrse1_Name,Course2,Courrse2_Name,Course3, Courrse3_Name)
R1:
R2:
Student# Student_Name Advisor 1022 John Doe Jones 4123 Jill Maher Smith 3456 Matt Samuels Jones 3751 Megan Cramer Taylor