Database Answers Checking the Paperwork
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Tracking Manufactured Orders 
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. 

Barry Williams 

September 18th. 2011
Principal Consultant
Database Answers
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map