Logo
Home Study Material Contact Search
AI Chat FREE
  1. computer science
  2. programming
  3. normalize the following table into 1nf, 2nf and 3n

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

Other questions asked by students

Q

WEEK 4 DISCUSSION #3ANSWER THE FOLLOWING QUESTIONS BELOW:1: Do you need to identify and...WEEK...

Accounting
Q

What is the difference between afferent and efferent neurons? List the 6 glial cells and list at...

Medical Sciences
Q

I have to write an assignment using either a theory of “critical criminology\" or an \"integrative...

Psychology
Q

What happens to proteins made in the

Biology
Q

Friends compared the number of pets they had at home. Their results are below: 2,3,1,...

Basic Math
Q

Use algebra to find the point at which the line g(x)= -4/5x+19/60f(x)= 8/3x+469/36Write the values...

Basic Math
Q

Observational studies are designed to be able to determine cause and effect True or False...

Statistics
Q

We project unit sales for a new household-use laser-guided cockroach search and destroy...

Accounting
Q

1. The Hass Machinery Company has told you that they will sell you a CNC...

Accounting
Q

please show work Carter Labs \& Medical Office from MA...

Accounting
Q

Which of the following is not a characteristic of an effective responsibility accounting system? Reports...

Accounting
Q

Suppose you just bought an annuity with 25 annual payments of $7,200 per year at...

Finance