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
Get step-by-step solutions from verified subject matter experts
