Databases Reference
In-Depth Information
Non-loss Decomposition
Figure 4-35 is the E-R diagram for General Hardware
Company.
Figure 4-35
OFFICE
*
Office Number
Telephone
Size
Works in
SALESPERSON
CUSTOMER
Salesperson
Number
Salesperson
Name
Commission
Percentage
Year of Hire
Customer
Number
Customer
Name
HQ City
*
*
Sells to
Sells
Quantity
Works for
CUSTOMER
EMPLOYEE
PRODUCT
Product
Number
Product
Name
Unit Price
*
*
Employee
Number
Employee
Name
Title
General Hardware Company E-R diagram.
144
