Question

My table below has these errors:You have violations in the `student_majorcode` and `student_majortitle` tables as well.

You have also lost the relationship between the major codes and titles. Consider a major table.

i tried to fix them. Please help if my correction are wrong

UNF:
student(Name,MobilePhoneNumbers,homePhone,studentID,Majorcode1,MejorTitle1,Majorcode2,MejorTitle2,Majorcode3,MejorTitle3)


3NF:
student_info(Name,studentID*@)
student_contact(homePhone,MobilePhoneNumbers,studentID*@)
student_contact(studentID*@, PhoneNumbers*, Type)
student_major(studentID*@, Majorcode1, MejorTitle1)
student_majorcode(studentID*@,Majorcode1,Majorcode2,Majorcode3)
student_majortitle(studentID*@,MejorTitle1,MejorTitle2,MejorTitle3)

Answer 1

student_info(Name,studentID*@)
student_contact(homePhone,MobilePhoneNumbers,studentID*@)
student_contact(studentID*@, PhoneNumbers*, Type)
student_major(studentID*@, Majorcode1, Majorcode2,Majorcode2)

majordetails(Majorcode1,MejorTitle1,Majorcode2,MejorTitle2,Majorcode3,MejorTitle3)

It seems you have created 3NF wrongly. I have made changes to your 3nf form. 2 different tables for code and title is not required. I have isolated them to table so they won't create any redundecy. Student major table will have link to major details table to get title details. Please check and let me know if you have any doubts or any error.