OBJECT-ORIENTED DATABASE MANAGEMENT - Fundamentals of Database Management Systems - page 257

OFFICE
Office Number
Telephone
Size

1

0..1

SALESPERSON
Salesperson Number
Salesperson Name
Commission Percentage
Year of Hire
Calculate Commission
Calculate Bonus

CUSTOMER
Customer Number
Customer Name
HQ City

1 0..*

SALE
Quantity

1..* 1

1..* 1..*

PRODUCT
Product Number
Product Name
Unit Price
Calculate Discount
Change Unit Price

CUSTOMER
EMPLOYEE
Employee Number
Employee Name
Title

TOOL
Weight

LIGHT FIXTURE LUMBER

Type of Wood
Dimensions

Calculate Extended
Warranty Price

Add Lumber

POWER TOOL
Amperes

NON-POWER TOOL
Years of Warranty

FRAME
Weight
Dimensions

BULBS
Number of Bulbs
Watts per Bulb

Calculate Extended
Warranty Price
for Power Tools

Calculate Extended
Warranty Price for
Non-Power Tools

FIGURE 9.5
General Hardware Company class diagram