Database Concepts

Published by Pearson
ISBN 10: 0133544621
ISBN 13: 978-0-13354-462-6

Chapter 2 - The Relational Model - Exercises - Page 108: 2.41C

Answer

See explanation

Work Step by Step

Continuing from the previous table, the second student (Jhon) currently has one sibling (Marry) and one major (Maths). To add a second major — say, Computer Science — we must duplicate Jhon’s row (because each row can store only one 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 2 & Jhon & Marry & ComputerScience \\ \hline \end{array} \]
Update this answer!

You can help us out by revising, improving and updating this answer.

Update this answer

After you claim an answer you’ll have 24 hours to send in a draft. An editor will review the submission and either publish your submission or provide feedback.