S
Saxman
I have been asked to build a simple database of customer records. Below
are the fields required.
My problem always seems to be deciding how many tables I will require.
Salutation and Product will require separate tables as I intend them to
be drop-down lists.
What I need to consider is that a customer could have maybe five
different orders.
Do you think the data should all be contained within one table?
Also, what would be best to use as a primary key? Customer or Order
Number? The customer is unlikely to change except maybe their
salutation if they married/remarried. The order number is unique.
The emphasis is on customer records rather than orders.
Order Number
Salutation
First Name
Last Name
Address 1
Address 2
Town
County
Postcode
Telephone
Email Address
Order Date
Order Number
Product
Order Cost
Salesperson
Notes
TIA
are the fields required.
My problem always seems to be deciding how many tables I will require.
Salutation and Product will require separate tables as I intend them to
be drop-down lists.
What I need to consider is that a customer could have maybe five
different orders.
Do you think the data should all be contained within one table?
Also, what would be best to use as a primary key? Customer or Order
Number? The customer is unlikely to change except maybe their
salutation if they married/remarried. The order number is unique.
The emphasis is on customer records rather than orders.
Order Number
Salutation
First Name
Last Name
Address 1
Address 2
Town
County
Postcode
Telephone
Email Address
Order Date
Order Number
Product
Order Cost
Salesperson
Notes
TIA