THE RELATIONAL DATABASE MODEL: ADDITIONAL CONCEPTS - Fundamentals of Database Management Systems - page 147

Customer 0839

Salesperson 137

Salesperson 137 sold
Product 24013 to
Customer 0839

FIGURE6.8
A ternary relationship

Product 24013

(a) SALESPERSON relation

Salesperson Salesperson Commission Year

Number Name Percentage of Hire

137 Baker 10 1995

186 Adams 15 2001

204 Dickens 10 1998

361 Carlyle 20 2001

(b) CUSTOMER relation

Customer Customer

Number Name HQ City

0121 Main St. Hardware New York

0839 Jane's Stores Chicago

0933 ABC Home Stores Los Angeles

1047 Acme Hardware Store Los Angeles

1525 Fred's Tool Stores Atlanta

1700 XYZ Stores Washington

1826 City Hardware New York

FIGURE6.9
A portion of General Hardware Company
relational database modified to
demonstrate a ternary relationship

2198 Western Hardware New York

2267 Central Stores New York

(Continues)