Alter question to allow students to have multiple majors. In this case, the Relational str...

Alter question 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.

Question

Consider the following relation:

STUDENT(StudentNumber, StudentName, SiblingName, Major)

Assume that the values of SiblingName are the names of all of a given student’s brothers and sisters; also assume that students have at most one major.

A. Show an example of this relation for two students, one of whom has three siblings and the other of whom has only two siblings.

---

B. List the candidate keys in this relation.

---

C. State the functional dependencies in this relation.

---

D. Explain why this relation does not meet the relational design criteria set out in this chapter (that is, why this is not a well-formed relation).

---

E. Divide this relation into a set of relations that meet the relational design criteria (that is, that are well formed).