Problem:
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 FDs 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?
Additional Information:
The question is from Computer Science and it is about writing query for database normalization. The relation between courses, sections and university have to be given in normalization query.
Total Word Limit: 302 Words