Consider the following relation: CLASS- LIST (STUDENT#, CLASS#, STUDENT- NAME, STUDENT- MAJOR, CLASS- TIME, and CLASSROOM) Required
Question:
Consider the following relation: CLASS- LIST (STUDENT#, CLASS#, STUDENT- NAME, STUDENT- MAJOR, CLASS- TIME, and CLASSROOM)
Required
a. Suppose that we wish to add a new class time and room (i. e., a new section) for a particular class number (#). Is this possible? If not, what is necessary before we can add a new class time and room to the file?
b. Suppose that all students drop a particular class number (#) from their schedules. What effect would this have on the data stored in the CLASS- LIST relation?
c. Is CLASS- LIST in first, second, or third normal form?
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: