Hey guys and girls,
New member
Basically my parents run a shop and its getting quite hard to store files now because they just use a basic paper based system (stuck in the last century
) Well I offered to build a database that would be easy for them to use and well I'm stuck
Ive identified all the fields I need to include (listed below) Ive been told by a friend that ideally you should do it to 3rd or 4th normal form? IVe had a look at some tutorials on the net and none of them have really helped. Im fine building databases but its just normalising I cant do.. any chance any one here can look over my fields and help?
Fields -
OrderNo, Order Date, Quantity ordered, Customer ID, Customer name, Customer address line 1, Customer address line 2, Customer phone number, Customer town, Customer County, Customer postcode, Customer credit card no., Customer credit card type, Customer email address, Product ID, Product name, Product type, Product size id, Product colour id, Product Price, Product stock, Delivery date, Manufacturer ID, Manufacturer name, Manufacturer phone number, Manufacturer address line 1, Manufacturer address line 2, Manufacturer country, Manufacturer town, Manufacturer County, Manufacturer postcode, Manufacturer email address, Staff ID, Staff Name, Staff age, Staff address line 1, Staff address line 2, Staff postcode, Staff email address, Staff type, Staff wage, Staff overtime,
ANy other info needed just ask
Regards, James
