Starting point

ata Modelin Figure 1 shows a sample production order used by Alpha Omega Engineering (AOE) for the planning and scheduling process. The production order authorizes the manufacture of a specified quantity of a particular product. It lists the operations that need to be performed, the quantity to be produced, and the location where the finished product should be delivered. Figure 1 1. Sample Production Order for AOE Alpha Omega Engineering PRODUCTION ORDER roduct No.2289 No.4430 | Cabinet Side Panel elease Issue 1000 eliver to: hn Smith 02/24/97 02/25/97 roduct 03/09/97 inish ate & Ti 2/28 2/28 1000 ate & Time 100 15-12 o5 106 124 ransfer from stock 700 15-9 28-17 54-5 to shape orner cut un & Shape 1002 1002 1001 1001 1001 1000 1030 3/01 100 3/02 1300 3/02 1600 3/02 1700 194 101 H25 ransfer to assembly 1600 Explanation of numbers in Quantity column . Total of 1003 sheets of raw material used to produce 1000 good panels and 3 rejected panels 2. One panel not cut to proper shape, thus only 1002 units had operations 106 and 124 per fanned on them 3. One panel not properly turned and shaped; hence only 1001 panels finished, painted, and received final 4. One panel rejected during final inspection; thus only 1000 good panels transferred to assembly Use Figure 1 to prepare a data model (Entity-Relationship Diagram) to store data about production orders at .Use short descriptive names for the tables. Clearly indicate cach table's primary key using "(pk)." For composite keys include a plus sign (+) after each field that is part of the composite key .Do not extend the scope of the data model beyond what is needed to process production orders using the sample form. Do not specify data types. PRODUCTION ORDER rder No(P Product No Description Production Q Approved By Release Date Issue Date Completion Date Deliver To Work St No Prd Op No Quantity Op Description Start Date Start Time Finish Date Finish Time