addio569
03-05-2009, 12:50 PM
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. :)
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. :)