Consider all the data stores shown in Figure. Draw an E- R diagram showing the database for the IPP based on the data stores shown in the figure. You do not need to includecardinalities.

Transcribed Image Text:

Bill of materials master Routing master Move tickets Inventory Manufacturin (production work centers agement process Manufacturing orders 1.0 Design product and Work center master Labor time, material use, and work progress data Finl shed goods Inventory status Productproduction design 4.0 Develop delalled processes Work center statusproduction instructions 5.0 manufacturing events Job time records Engineers Parts master Employee/payroll master data Time phased order requirements schedule RM Issuel return nolces Work center status Master production schedule Raw materlals requisitions Order prooess entry/ sales Sales orders and/or demand forecast 2.0 Generate master production schedule process 3.0 Determine needs for materials RMWIP inventory status Bill of materials master FG inventory status reorder points lead times Open purchase order data Parts master Inventory managemen process Purchase requisitons KEY: FG Finlshed goods RM Raw materlals WIP Work-In-process Purchasing process