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
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
Get step-by-step solutions from verified subject matter experts
