Question: Consider the relation R, which has attributes that hold schedules of courses and sections at a university; R = {CourseNo, SecNo, OfferingDept, CreditHours, CourseLevel, InstructorSSN,
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?
Step by Step Solution
3.41 Rating (164 Votes )
There are 3 Steps involved in it
Let us use the following shorthand notation C CourseNo SN SecNo OD OfferingDept CH CreditHours CL Co... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
888-CS-DB (2360).docx
120 KBs Word File
