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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started