Discuss the effect of the following changes on the design for the Marvel College requirements:
a. More than one instructor might teach a given section of a course, and each instructor must be listed on the time schedule.
b. Each department offers only a single major.
c. Each department offers only a single major, and each faculty member can advise students only in the major that is offered by the department to which the faculty member is assigned.
d. Each department offers only a single major, and each faculty member can advise students only in the major that is offered by the department to which the faculty member is assigned. In addition, a student can have only one major.
e. There is an additional transaction requirement: given a student’s name, find the student’s number.
f. More than one faculty member can be assigned to one office.
g. The number of credits earned in a particular course cannot vary from student to student or from semester to semester.
h. Instead of a course number, course codes are used to uniquely identify courses. (In other words, department numbers are no longer required for this purpose.) However, it is still important to know which courses are offered by which departments.
i. On the registration request form, a student may designate a number of alternates along with his or her primary choice. These alternates are listed in priority order, with the first one being the most desired and the last one being the least desired.