Question: Please I badly need help with this. I really stuck and can't figure out the Entity-Relationship diagram for the following case. Please help me with

Please I badly need help with this. I really stuck and can't figure out the Entity-Relationship diagram for the following case.

Please help me with the ER-diagram(ER-MAPPING WITH CARDINALITIES) of this case.

I have also provided the summary of this case in the block diagram in the last and second last picture.

And please ignore the area where "Pump P-100 BOM PUMP" is labeled.

Also note that each picture is the continuation of the previous picture.

I shall really appreciate your sincere help.

Please I badly need help with this. I really stuck and can'tfigure out the Entity-Relationship diagram for the following case. Please help mewith the ER-diagram(ER-MAPPING WITH CARDINALITIES) of this case. I have also providedthe summary of this case in the block diagram in the last

CASE BRIEF Introduction In a large whole sale company, materials are supplied by the supplier/vendor. Supplied materials are stored in supply-storage area of this company. For manufacturing raw material is made available in plants. Some materials need special amangements such as cool fridge. This company has several plants, storage units. Assembled or ready-made materials are made available in warehouse WH) locations. Customers buy such WH materials through POS point-of-sale) counters. This company has more than one branch in different cities (kn as company code) with units such as plants, own storages and WHs located in many cities. Each material is associated with these branches and units Plant: An organizational unit within a company. A plant produces goods, renders services, or makes goods available for distribution. A plant can be a manufacturing facility or a warehouse distribution Centre Storage Location: An organizational unit within a plant. A storage location identifies the general area in the plant where material is stored. Plants can have multiple storage locations. Storage c stores raw material, finish good items to be testing or tested, or semi-finished gooditems etc Warehouse: Place where material is assembled or finished good items are placed and ready to sale or deliver or install. Work Center: A work center is where an operation or an activity is carried out in a plant. It therefore specifies where production ultimately takes place. Work centers are used in routings or inspection plans or in maintenance routings. Work center is they nay also be used in networks generally a specific geographical location in the plant, for example, a specific machine or department in plant

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!