Results 1 to 2 of 2

Thread: Help with Normalisation

  1. #1
    Join Date
    Mar 2009
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Help with Normalisation

    Hi, I need help with 1NF, 2NF and 3NF.

    I've had a go, but need to know if theres anything else I can do.

    This is my data. the first table is:

    Group ID, Group Name, Group Leader, Amount In Group, Start Date, End Date, Member ID, Member Forename, Member Surname, D.O.B, Address , Emergency Telephone.

    I've got it down to this:

    (GROUP ID, GROUP NAME, GROUP LEADER, AMOUNT IN GROUP, START DATE, END DATE)

    (GROUP ID*, MEMBER ID,MEMBER FORENAME, MEMBER SURNAME, D.O.B, ADDRESS, EMERGENCY TELEPHONE)


    I can't see how I can Normalise this anymore, is it already in 3NF??

    the 2nd table is Chalet ID, Chalet Name, Occupancy No, Price per week, Group ID, Amount from Group.

    so far I've done:

    (CHALET ID, CHALET NAME, OCCUPANCY NO, PRICE PER WEEK PER INDIVIDUAL)

    (CHALET ID*, GROUP ID, AMOUNT FROM GROUP)

    can I normalise this anymore??

    any help would be greatly appriciated.

  2. #2
    Join Date
    Jul 2006
    Location
    just north of Boston, MA
    Posts
    1,806
    Thanks
    13
    Thanked 72 Times in 72 Posts

    Default

    If 1 user can be in multiple groups, you can use another table to reference group/member.

    Member_has_group
    group_id
    member_id

Bookmarks

Posting Permissions

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