1) Consider the following relation (i.e., table) created for a class list:

(Student#, class#, student-lastname, student-firstname, student-major, section#,

meeting-time, meeting-room)

a) Suppose we wish to add a new class time and room (i.e., a new section). Is this

possible? Why or why not? If not, what is necessary to make it possible?

b) Suppose all students drop a particular class from their schedules (perhaps they have

heard that I will be teaching the class). What effect will this have on the data stored

in the class list relation?

c) Is the class list relation in 1st, 2nd, and 3rd normal form?

2) Consider the following two relations:

(Department#, dept-name, location, professor#)

(Professor#, prof-name, address, phone)

Professor# is a foreign key in the department relation and links the two tables together.

a)What is wrong with these relations (i.e., what problems will be caused) and how can the

tables be fixed?