Databases Reference
In-Depth Information
Figure 4-31
SALESPERSON table
Salesperson
Number
Salesperson
Name
Commission
Percentage
Year of
Hire
Department
Number
137
186
204
361
Baker
Adams
Dickens
Carlyle
10
15
10
20
1995
2001
1998
2001
73
59
73
73
DEPARTMENT table
Department
Number
Manager
Name
59
73
Lopez
Scott
PRODUCT table
Product
Number
Product
Name
Unit
Price
16386
19440
21765
24013
26722
Wrench
Hammer
Drill
Saw
Pliers
12.95
17.50
32.99
26.25
11.50
QUANTITY table
Salesperson
Number
Product
Number
Quantity
137
137
137
186
186
186
186
204
204
361
361
361
19440
24013
26722
16386
19440
21765
24013
21765
26722
16386
21765
26722
473
170
688
1745
2529
1962
3071
809
734
3729
3110
2738
Sample data in the third normal form.
