Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2013
    Posts
    4

    need help in normalization!

    http://i40.tinypic.com/2rnfn5s.jpg

    hey guys. i need help in normalizing this table. will be great if the community can help me in 1NF, 2NF and 3NF.

    thanks alot!

  2. #2
    Join Date
    Oct 2013
    Posts
    4
    btw, this is the 3NF i came up with.

    Staff(StaffNo, PodName)
    Patient(PatNum, PatName, PatTelNo)
    Room(RoomNo, RoomExt)
    Appointment(StaffNo, PatNum, ApptDate, ApptTime, RoomNo)

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    appointment date and time should be a single item as they are related

    what do you think are the primary and foreign keys
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Oct 2013
    Posts
    4
    so it should be like this?

    Staff(StaffNo, PodName)
    Patient(PatNum, PatName, PatTelNo)
    Room(RoomNo, RoomExt)
    Appointment(StaffNo, PatNum, ApptDateTime, RoomNo)

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    i dunno...
    ...after all its your coursework not mine. Im not going to validate it, Im not going to effectively act as a marker/grader to allow you to pass your coursework.

    what do you think?
    havign tudied the subject, havign read up on it whats your opinion.

    if you are uncertain then perhaps its a good idea to read up on the subject
    The Relational Data Model, Normalisation and effective Database Design
    I'd rather be riding on the Tiger 800 or the Norton

  6. #6
    Join Date
    Oct 2013
    Posts
    4
    ah. ok thanks. i will read it up

Posting Permissions

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