Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microsoft SQL Server 2012 Unleashed

Authors: Ray Rankins, Paul Bertucci

1st Edition

0133408507, 9780133408508

More Books

Students also viewed these Databases questions