Answer
See explanation
Work Step by Step
To give Noor Kaya a second major (Chemistry), we must add duplicate rows for all her siblings, each with the new major:
\[
\begin{array}{|c|c|c|c|}
\hline
\textbf{Student} & \textbf{Student} & \textbf{Sibling} & \textbf{Major} \\
\textbf{Number} & \textbf{Name} & \textbf{Name} \\ \hline
1 & Noor & Kaya & History \\ \hline
1 & Noor & Maya & History \\ \hline
1 & Noor & Dani & History \\ \hline
2 & Jhon & Marry & Maths \\ \hline
1 & Noor & Kaya & Chemistry \\ \hline
1 & Noor & Maya & Chemistry \\ \hline
1 & Noor & Dani & Chemistry \\ \hline
\end{array}
\]
This redundancy shows the design is not normalized — repeating student and sibling data for each major causes anomalies. A better design would separate STUDENT, SIBLING, and MAJOR into different tables.
