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

OFFICE

PK Office

Number

Telephone
Size

Occupied by
Works in

SALESPERSON CUSTOMER

PK Salesperson

Number

PK Customer

Number

Sells to
Buys from

Salesperson
Name
Commission
Percentage
Year of Hire

Customer
Name
HQ City

Employs

Sold
Sold by

Employed by

CUSTOMER
EMPLOYEE

SALES

PK Salesperson

Number

PK Customer

Number

PK Product

Number

PK Employee

Number

Quantity

Employee
Name
Title

Sold

Sold
Product

PRODUCT

PK Product

Number

Product
Name
Unit Price

F IGURE 7.18
The General Hardware
Company E-R diagram