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

Question:

Alter question 2.40 to allow students to have multiple majors. In this case, the relational structure is: STUDENT (Student Number, 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.

AppendixLO1

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Database Concepts

ISBN: 9780133544886

6th Edition

Authors: David M Kroenke, David J Auer

Question Posted: