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?



$1.99
Sales0
Views123
Comments0
  • CreatedFebruary 26, 2015
  • Files Included
Post your question
5000