Is This Data Normalised?

decmatt

decmatt

decmatt

Soldato
Joined
10 May 2004
Posts
3,774
Location
East Yorkshire, UK
Hi,

Just wondering is this data normalised?

Table: Member
Member Number
First Name
Last Name
House Name
Street 1
Street 2
City
State/Province
Country/Region
Postal Code
Email Address
Home Phone
Birth Date

Table: Payment
Payment Id
Pay 08
Pay 07
Pay 06
Pay 05


Table: Dinner
Dinner Id
Attendance
Choice
Paid


Or can this be normalised further?
 
so...

Table: Member
Member Number
First Name
Last Name
House Name
Street 1
Street 2
City
State/Province
Country/Region
Postal Code
Email Address
Home Phone
Birth Date

Table: Payment
Member Number
Payment Id
Pay 08
Pay 07
Pay 06
Pay 05


Table: Dinner
Member Number
Dinner Id
Attendance
Choice
Paid
Click to expand...

that what you mean?
 
The attendance field is for whether the member is going to the dinner, the table is for whether they are going to the dinner, and if they are what menu are they having (Chicken, Salmon or Pasta) and if they have paid for the dinner yet.
 
You must log in or register to reply here.
Back
Top Bottom