7. Consider the relation: COURSE (course#,date,level,cost) STUDENT (sID, university, address, course#, date, level)

The following assumptions hold:

a course always has the same cost, regardless of date or level.

each course is available on one or more dates and one or more levels, and each course is available in all combinations of dates and levels for that course.

each student attends one university.

each university has one address; each address maps to one university.

each tuple of Course and Student is unique (no duplicate rows).

(a) List all the FDs.

(b) Specify all keys for the relations COURSE and STUDENT.

(c) Specify all MVDs.

(d) Are the relations in 4NF? If not, give 4NF decompositions.