Question

Please I need serious help.

Please consider the following scenario for a manufacturing company.

A company can have more than 1 branch in a city.

1 branch can have more than 1 manufacturing plants under it.

1 Plant can have multiple storage_units for storing raw materials or semi-finished materials or finished materials for testing in production units(work centers).

Also, 1 plant can have more than 1 work centers where the production of materials actually takes place.

This Process of Production of materials is called "Routing".

Also there is a supplier supplying materials from one work center to another for production of materials.

Now I have developed a following table:

Enitty----------->Routing

Attributes----->(Work_center_id, Material_id, Storage_unit_id, operation_id, operation_performed, description_of_operation, Time_of_operation, branch_id, city, country, plant_id, location_of_plant, supplier_id, supplier_name, material_status(e.g. raw, finished...), quantity, Total_Time_of_production_of_a_material).

I am unable to normalize the above table.

Please I need 1NF, 2NF AND 3NF forms of the above table with keys(primary and foreign) mentioned and kindly also provide some explanation.

I would really appreciate your sincere help.

Answer 1

hetere inf he the one nihars afau hans allryour athui bus OPERATION- PERfoMED DASC-0P-OPER TIMf Of DPEATION PANCH D ATUS

Supplier OPEA TDN

Lonne -can OPERATION 10PER-PepfpMEp Ti