Hi,

please help me to solve these 2 problems

1. How would you normalize this relation???

Consider a Relation R(A,B,C,D,E,F) with the following dependencies (A,B)->C, (A,D)->E, D->B, E->C

Do lossless join decomposition of R so it is in BCNF normal form

2.Consider the relation R, which has attributes that hold schedules of courses and sections at a university; R = {CourseNo, SecNo, OfferingDept, Credit-Hours, CourseLevel, InstructorSSN, Semester, Year, Days_Hours, RoomNo, NoOfStudents}. 

Suppose that the following functional dependencies hold on 

{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?

Thanks