CS-06 Data Base Management System June-2004
Q.3(a). Consider the relation R which has attributes that hold schedules of courses and sections at a university; R = { Course No., Section No., Offering_dept Credit hrs, Course level, Semester, Instructor SSN, year, Days_hrs, Room No No. of students)
Suppose that the following functional dependencies hold on R
{Course No.} > {Offering dept, Credit hrs, Course level}
{Course No., Section No., Semester, year} >
{Days_hrs, Room No., No. of students, Instructor SSN}
{Room No., Days hrs, semester, year} >
{Instructor SSN, Course No., Section No.}
(i)Which sets of attributes form keys of R?
(ii)Show how you would normalize the relation above. Also give the final tables.
(b) Define the two principle integrity rule for the relational model. In which situations would you need to apply these rules?