Question: please provide me a full visual , it doesnt have to be neat a paper drawing or picture art is fine In this assignment, you

please provide me a full visual , it doesnt have to be neat a paper drawing or picture art is fine  please provide me a full visual , it doesnt have to

In this assignment, you will draw the entity-relationship diagram for a car insurance system. The rules of this system are the following: 1. A car dealership has many cars. 2. Each car is sold at one dealership. 3. A car owner can own multiple cars from a dealership. 4. A car can be owned by only one person. 5. A car requires a finance plan, and a plan can only be assigned to one car. 6. One payment is applied to exactly one plan, and one plan can be paid off over time by several payments. 7. Owners can make many payments, but a payment can only be paid by one owner. 8. Owners must be insured and they can only carry insurance with one insurance company. 9. An insurance company can have many owners carry their policies. 10. The insurance company will make payments, with each single payment made by exactly one insurance company

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!