Results 1 to 3 of 3

Thread: normalisation

  1. #1
    Join Date
    Jan 2007


    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.


    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.

  2. #2
    Join Date
    Jun 2003
    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.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

  3. #3
    Join Date
    Jan 2012

    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts