Question: Case Study: Create ER diagram that describes car insurance database. The database contains information about Customers, Cars, Accidents and Insurances. Each of these entities has

Case Study: Create ER diagram that describes car insurance database. The database contains information about Customers, Cars, Accidents and Insurances. Each of these entities has the following attributes: Customer: CustomerID, CustomerName, Address Car: RegistrationID, Manufacture, Type Accident: AccidentID, Description Insurance: PolicyID, PolicyName Relationships between the entities are the following: each customer has one or more cars each car has one owner each car is associated with zero or more accidents each accident is associated with one car each insurance policy covers one or more cars each car is covered by one policy

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!