Consider the following relation CLASS LIST STUDENT CLASS STUDENT NAME
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?

Membership TRY NOW
  • Access to 800,000+ Textbook Solutions
  • Ask any question from 24/7 available
    Tutors
  • Live Video Consultation with Tutors
  • 50,000+ Answers by Tutors
OR
Relevant Tutors available to help