[Solved]-Q4 20 Points Consider Relation R Hold Schedules Courses Sections University R Courseno Sec Q37281165

Q.4 (20 points) Consider the relation R, that hold schedules of courses 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 dependencies hold on R: Course_no- Offering_ dept, Credit_hours, Course_level) Course_no, Sec_no. Semester, Year) – {Days_hours. Room no. No of_students Instructor ssn (Room _no. Days_hours, Semester. Year) – Instructor ssn, C Try to determine which sets of attributes form keys of R. How would you normalize this relation? Show transcribed image text Q.4 (20 points) Consider the relation R, that hold schedules of courses 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 dependencies hold on R: Course_no- Offering_ dept, Credit_hours, Course_level) Course_no, Sec_no. Semester, Year) – {Days_hours. Room no. No of_students Instructor ssn (Room _no. Days_hours, Semester. Year) – Instructor ssn, C Try to determine which sets of attributes form keys of R. How would you normalize this relation?

Expert Answer

---

Answer to Q.4 (20 points) Consider the relation R, that hold schedules of courses and sections at a university R(Course_no, Sec_no… . . .