Results 1 to 1 of 1
  1. #1
    Join Date
    May 2004

    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)

    Im not sure did I put quantities on the right table, and also there could be something wrong with relationships, because I cant add data in all tables.

    Thanks for your time and help!!!!
    Last edited by Max30; 05-13-04 at 00:16.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts