Question: please do not copy/past from a previous answer given. The Business Environment: Green Hardware would like to keep track of the following entities and their

please do not copy/past from a previous answer given.
please do not copy/past from a previous answer
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 1. Construct an ER Diagram mapping out the business environment. Identify the cardinality, modality, primary keys and foreign keys. Highfidelityprototype only. (10 points. grading criteria: accuracy)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!