Consider the following relation: CLASS- LIST (COURSE#, CLASS- ROOM, STUDENT#, STUDENT- MAJOR) a. Assuming that each student
Question:
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.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Accounting Information Systems
ISBN: 9780132871938
11th Edition
Authors: George H. Bodnar, William S. Hopwood
Question Posted: