Engineering
Consider the relation R, which has attributes that hold schedules of course and sections at a university: R = {Course_no, Sec_no, Offering_dept, Credit_hours, Course_level, Instructor_ssn, Semester, Year, Days_hours, Room_no, No_of_students}. Suppose that the following functional dependencies hold on R. {Course_no} rightarrow {Offering_dept, Credit_hours, Course_level} {Course_no, Sec_no, Semester, Year} rightarrow {Days_house, Room_no, No_of_students, Instructor_ssn} {Room_no, Days_hours, Semester, Year} rightarrow {Instructor_ssn, Course_no, Sec_no} Try to determine which sets of attributes from keys of R, How would you normalized this relation?