1. Alter question 2.40 to allow students to have multiple majors. In this case, the relational structure is:

STUDENT (StudentNumber, StudentName, SiblingName, Major)

A. Show an example of this relation for two students, one of whom has three siblings and the other of whom has one sibling. Assume that each student has a single major.

B. Show the data changes necessary to add a second major for only the first student.

C. Based on your answer to part B, show the data changes necessary to add a second major for the second student.

D. Explain the differences in your answers to parts B and C. Comment on the desirability of this situation.

E. Divide this relation into a set of well-formed relations.