LOGICAL DATABASE DESIGN - Fundamentals of Database Management Systems - page 184

SALESPERSON table

Salesperson Salesperson Commission Year of Departmen t

Number Name Percentage Hire Number

137 Baker 10 1995 73

186 Adams 15 2001 59

204 Dickens 10 1998 73

361 Carlyle 20 2001 73

DEPARTMENT table

Department Manager

Number Name

59 Lopez

73 Scott

PRODUCT table

Product Product Unit

Number Name Price

16386 Wrench 12.95

19440 Hammer 17.50

21765 Drill 32.99

24013 Saw 26.25

26722 Pliers 11.50

QUANTITY Table

Salesperson Produc t

Numbe r Numbe r Quantity

137 19440 473

137 24013 170

137 26722 688

186 16386 1745

186 19440 2529

186 21765 1962

186 24013 3071

204 21765 809

204 26722 734

F IGURE 7.34
The salesperson and product attributes in
third normal form with sample data

361 16386 3729

361 21765 3110

361 26722 2738

not appear from the sample data of Figure 7.34 to be causing any data redundancy
problems. Since it was a candidate key, its defining other non-key attributes is not a
problem.