This is the starting point. Charts would break off and be related 1 to many or many to 1.

Data Modeling Exercise Figure I shows a sample production order used by Alpha Omega Engineering (ACE) 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. Sample Production Order for AOE 105 Alpha Omega Engineering PRODUCTION ORDER Order Product Description: Production Quantity No.2289 No.4430 Cabinet Side Panel 1000 Approved Release Issue Completion Deliver to: y: Pate: Date: Date: Assembly Department John Smith 02/24/97 02/25/97 03/09/97 Work Product Station Operation Operation Start Finish No. No. Quantity Description Date & Time Date & Time MH25 100 1003 Transfer from stock 02/28 0700 02/28 0800 MI15-12 1003 Cut to shape 102/28 0800 02/28 1000 MI15-9 106 Corner cut 02/28 1030 02/28 1200 $28-17 124 1002 Turn & Shape 02/28 02/28 1700 F54-5 142 1001 Finish 03/01 0800 03/01 1100 P89-1 155 1001 Paint 03/01 1300 03/02 1300 PC94 194 1001 Inspect 03/02 1400 03/02 1600 MH25 101 1000 Transfer to assembly 03/02 1600 03/02 1700 Explanation of numbers in Quantity column: i. 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 inspection 4. One panel rejected during final inspection; thus only 1000 good panels transferred to assembly department. 1002 1300 Requirements: Use Figure 1 to prepare a data model (Entity-Relationship Diagram) to store data about production orders at AOE 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. one PRODUCTION ORDER Order No(PK) 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