Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe

تمرين 13

Consider the relation R, which has attributes that hold schedules of courses and sections at a university; R = {CourseNo, SecNo, OfferingDept, CreditHours,
CourseLevel, InstructorSSN, Semester, Year, Days_Hours, RoomNo,
NoOfStudents}. Suppose that the following functional dependencies hold on R:
{CourseNo} - > {OfferingDept, CreditHours, CourseLevel}
{CourseNo, SecNo, Semester, Year} - >
{Days_Hours, RoomNo, NoOfStudents, InstructorSSN}
{RoomNo, Days_Hours, Semester, Year} - > {InstructorSSN, CourseNo, SecNo}
Try to determine which sets of attributes form keys of R. How would you normalize this relation?