Question: How would I complete this two part question? 1. Normalize Get the following table into First Normal Form SALESPERSON/PRODUCT Table Salesperson Number Product Number Salesperson

How would I complete this two part question?

1. Normalize

Get the following table into First Normal Form

SALESPERSON/PRODUCT Table

Salesperson

Number

Product

Number

Salesperson

Name

Commission

Percentage

Year of

Hire

Department

Number

Manager

Name

Product

Name

Unit

Price

Quantity
137

19440

24013

26722

Baker 10 1995 73 Scott

Hammer

Saw

Pliers

17.50

26.25

11.50

473

170

688

186

16386

19440

21765

24013

Adams 15 2001 59 Lopez

Wrench

Hammer

Drill

Saw

12.95

17.50

32.99

26.50

1745

2529

1962

3071

204

21765

26722

Dickens 10 1998 73 Scott

Drill

Pliers

32.99

11.50

809

734

361

16386

21765

26722

Carlyle 20 2001 73 Scott

Wrench

Drill

Pliers

12.95

32.99

11.50

3729

3110

2738

2. Further normalize

Draw a dependency diagram and

Normalize into 3rd normal form

Salesperson

Number

Product

Number

Salesperson

Name

Commision

Percentage

Year of

Hire

Department

Number

Manager

Name

Product

Name

Unit

Price

Quantity

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!