Results 1 to 5 of 5

Thread: 3rd NF question

  1. #1
    Join Date
    Mar 2010
    Posts
    4

    3rd NF question

    I have a table; its a university enrolements database-

    tblModules

    GroupNo (PK)
    Title
    TutorCode(FK)
    DayNo
    Time
    Room
    Semester

    Time; I dont think it is dependent on the Primary Key.

    I think it should go in a seperate table like this-

    tblTimes

    TimeSlot(PK)
    Day
    Time

    So it will look like this-

    TimesSlot|Day|Time|

    m1 |MON|9:00 - 11:00|
    m2 |MON|11:15 - 1:15|
    t1 |TUE|9:00 - 11:00|
    t2 |TUE|11:15 - 1:15|

    Do you guys think this is overkill?

    I think it is required so they can query for any free timeslots and other tasks like what day is GroupNO "BAF3"; Thats if I add a composite PrimaryKey table called tblTimeTables with GroupNo and TimeSlot.

    Would this even be 3rd Normal Form or 4th maybe even 5th???

    Thanks Guys
    Last edited by si.gates; 03-07-10 at 13:54.

  2. #2
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Quote Originally Posted by si.gates View Post
    I have a table; its a univercity enrolements database-
    I believe it's spelt university

  3. #3
    Join Date
    Mar 2010
    Posts
    4
    Quote Originally Posted by mike_bike_kite View Post
    I believe it's spelt university
    I believe your right, I also believe this is a typo!

  4. #4
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Quote Originally Posted by si.gates View Post
    I also believe this is a typo!
    Fair enough - I'll stop shaking my head then

  5. #5
    Join Date
    Mar 2010
    Posts
    4
    Quote Originally Posted by mike_bike_kite View Post
    Fair enough - I'll stop shaking my head then

    What do you think of the database?

Posting Permissions

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