Hi i need some help. i have done my tables and would like to know if they are correct or not.
CODE
Unnormalised
Order No
Customer Name
Address
County
Postcode
Telephone Number
Date Of Order
Delivery Address
Delivery Date
Time Of Delivery
Payment Method
Item
Item Name
Price
Quantity Ordered
Total
Staff Id
Name
Total Cost Of Order
1 NF Table
Customer Table
Order No
Customer Name
Address
County
Postcode
Telephone Number
Staff id
Order Table
Date Of Order
Delivery Address
Delivery Date
Time Of Delivery
Payment Method
Item
Item Name
Price
Quantity Ordered
Total
Staff Id
Name
Total Cost Of Order
2 NF Table
Customer Table
Customer ID
Customer Name
Address
County
Postcode
Telephone Number
Staff Id
OrderID
Order Table
OrderID
Date Of Order
Delivery Address
Delivery Date
Time Of Delivery
Payment Method
Items Table
Item ID
Item Name
Price
Quantity Ordered
Total
Staff Id
Name
Total Cost Of Order
3 NF Table
Customer Table
Customer ID
Customer Name
Address
County
Postcode
Telephone Number
Order Table
Order ID
Date Of Order
Delivery Address
Delivery Date
Time Of Delivery
Payment Method
Staff ID
Item ID
Items Table
Item
Price
Quantity Ordered
Total
Total Cost Of Order
Staff Table
Staff Id
Name
| 