Somebody please help!

I have an assignment on normalisation to do using functional dependency and I'm not quite sure how to do it!

R (ModuleNo, OfferingDept, Credit, Level, LecturerNo, Semester, Year, WeekDay, Period, RoomNo, NoOfStudents)

Suppose that the following functional dependencies hold on R:

ModuleNo -> OfferingDept, Credit, Level

ModuleNo, Semester, Year -> WeekDay, Period, RoomNo, NoOfStudents, LecturerNo

WeekDay, Period, RoomNo, Semester, Year -> LecturerNo, ModuleNo

where period is a unique number identifying the time a class starts.

YOUR TASK

Try to determine which sets of attributes form keys of R.
Use the above given dependencies to normalise relation R.

Can someone give me some directions on how to sort this out.

Thank you.

Our general policy on this forum for homework assistance is that your question must be specific, and you must have made some attempt at resolving it yourself.

Hi,

sorry for the bump but I have the similar task to figure out.

I have worked the following out in BCNF and would appreciate if someone could help me if I did it correctly or wrong:

Period -> weekday, RoomNo, NoOfStudents, ModuleNo

LecturerNo -> Semester, Year, ModuleNo

ModuleNo -> OfferingDept, Credit, Level


Thanks in advance!