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  book-img-for-question

Accounting Information Systems

ISBN: 9780132871938

11th Edition

Authors: George H. Bodnar, William S. Hopwood

Question Posted: