Back to the Data Model
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.
September 18th. 2011