In: Computer Science
StudentNumber |
StudentName |
SiblingName |
Major |
100 |
Jose |
Eric |
Marketing |
100 |
Jose |
Teddy |
Marketing |
100 |
Jose |
Jorge |
Marketing |
200 |
Rex |
Chris |
Business |
200 |
Rex |
Rick |
Business |
B. Let's change the original assumption and allow a student to have multiple majors. Based on your answers to Part A, show an example of adding a second major to your second student, who has two siblings.
C. Did allowing multiple majors per student introduce redundancies? If so, let's normalize again and show your final relations in 3NF. Every relation name must be in all CAPS and your primary key(s) & foreign key(s) should be underlined. Be sure to identify relationships by stating "RELATION1.FK references RELATION2.PK".