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.

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.

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!