Normalize the following table into 1NF, 2NF and 3NF. Salesperson name Sales area Customer Number Customer Name Warehouse Number Warehouse Location Sales...

70.2K

Verified Solution

Question

Programming

Normalize the following table into 1NF, 2NF and 3NF.
Salesperson name
Sales area
Customer Number
Customer Name
Warehouse Number
Warehouse Location
Sales Amount
76458
Hariharan
East
17658
Asani
3
Govandi
13545
17645
Madhuram
6
Vasai
10600
17623
Sumit
6
Vasai
9700
76567
Dheerendra
North
18190
Dhanram
4
Thane
11560
18173
Toshi
4
Thane
2590
18150
Ganesh
1
Kalyan
8090

Answer & Explanation Solved by verified expert

4.3 Ratings (629 Votes)

Three Steps of Normalization Step 1 Flatten the relation ie get rid of composite attributes and multivalued attributes 1NF Step 2 Remove partial key dependencies 2NF Step 3 Remove nonkey dependencies 3NF Step 1 Flatten the relation 1NF To convert to firstnormal form is easy simply combine each row in the nonsimple column with the items in the other columns See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

	Salesperson name	Sales area	Customer Number	Customer Name	Warehouse Number	Warehouse Location	Sales Amount
76458	Hariharan	East	17658	Asani	3	Govandi	13545
17645	Madhuram	6	Vasai	10600
17623	Sumit	6	Vasai	9700
76567	Dheerendra	North	18190	Dhanram	4	Thane	11560
18173	Toshi	4	Thane	2590
18150	Ganesh	1	Kalyan	8090