Problem

Consider the following relation:CLASS-LIST (COURSE#, CLASS-ROOM, STUDENT#, STUDENT-MAJOR)a...

Consider the following relation:

CLASS-LIST (COURSE#, CLASS-ROOM, STUDENT#, STUDENT-MAJOR)

a. Assuming that each student can have only one major, is this relation normalized? If so, is it in first, second, or third normal form? If it is not already in third normal form, what is necessary to attain this?


b. Would your answer to part (a) be different if a student can have more than one major? Discuss.

Step-by-Step Solution

Request Professional Solution

Request Solution!

We need at least 10 more requests to produce the solution.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the solution will be notified once they are available.
Add your Solution
Textbook Solutions and Answers Search