Results 1 to 3 of 3

Thread: normalisation

  1. #1
    Join Date
    Jan 2007
    Posts
    1

    normalisation

    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.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    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
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Jan 2012
    Posts
    1
    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!

Posting Permissions

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