Construct an ER Diagram mapping out the business environment. Identify the cardinality, modality, primary keys and foreign keys. High-fidelity prototype only

The Business Environment:

Green Hardware would like to keep track of the following entities and their attributes:

Salespeople

Salesperson Number

Salesperson Name

Commission Percentage

Year of Hire

Salary

Customers

Customer Number

Customer Name

HQ City

Customer Employees

Employee Number

Employee Name

Title

Products

Product Number

Product Name

Unit Price

Sales

Quantity

Offices

Office Number

Telephone Number

Size

Business Relationships:

• A salesperson can occupy 1 office, or an office may be empty
• A salesperson sells to many customers or no customers
• A salesperson makes 1 or many sales.
• A product is sold 1 or many times
• A customer employs 1 or many employees