Subject: Data base design
Question: I want a database has to be designed under the following considerations:

It is for a manufacturing company.

A table for orders is needed ( customer order number, part number, date, promised date, Quantity ordered).

The part numbers have different internal processes (proc1, proc2, proc 3).

The tracking of the orders is with a table that has the following information ( part number, process, operator of the process, quantity processed, time used to process)

Any production run is limited by the quantity ordered by the customer.

I will appreciate if someone can help me with the design.

Barry Williams

September 18th. 2011

Principal Consultant

Database Answers