var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: normalization hellp?
I have following fields ,which I wont put in the tables ,but I an not sure is it right way, so if anyone could hell me or give any suggestion.
Customer ID, Customer Name, Product ID, Product Name, Part ID, Part Name,
Quantity Needed, Supplier ID, Supplier Name
I have done like this
Customers (Customer ID, Customer Name)
Parts (Part ID, Part Name, Supplier ID, Quantity on Hand, Quantity on Order
Supplier (Supplier ID, Supplier Name)
Product (Product ID, Product Name)
Ordered Items (Product ID, Part ID, Customer ID, Quantity Needed)
I’m not sure did I put quantities on the right table, and also there could be something wrong with relationships, because I can’t add data in all tables.
Thanks for your time and help!!!!
Last edited by Max30; 05-13-04 at 01:16.