ER diagram

Question

Consider the following scenario modeling project management activities in an organization.

A car sales company offers to its customers the option of purchasing a car using repayment schemes of over 1 year, 2 years, 3 years, 4 years or 5 years.
A customer may purchase one or more cars under the scheme. When a customer purchases a car, he or she gets to choose one of the repayment scheme options for each purchase or may pay the whole amount in one go, meaning a repayment scheme option may be selected by one or more customers or may not be selected at all. A customer will have a unique customer number, a name, an address, and a phone number. A repayment scheme option will have a unique repayment scheme number, a name and the number of years for repayment. A car will have a unique car code, a make, a model, year of manufacture and a price.

The company pays commission on sales of cars to its salespeople and therefore it will also keep information about each sale which will include a unique sales ID and commission to be paid on that sale. The company will also want to know who made the sales and the car involved in that transaction so that the commission can be determined. A salesperson will have a unique salesperson ID, a name, a phone number and an email address.

And this is the requirements/Question: Construct the Entity Relationship Diagram (ERD) for the above given scenario. Identify all the entities, attributes of each entity including primary key, foreign key, relationship between the entities and cardinality constraints. State any assumptions necessary to support your design.

Details
Purchase An Answer Below

Have a similar question?