Question: Case Study: Create ER diagram that describes car insurance database. The database contains information about Customers, Cars, Accidents and Insurance Policies. Each of these entities
Case Study: Create ER diagram that describes car insurance database. The database contains information about Customers, Cars, Accidents and Insurance Policies. Each of these entities has the following attributes: Customer: CustomerID, CustomerName, Address Car: RegistrationID, Manufacture, Type Accident: AccidentID, Description Policy: 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
Get step-by-step solutions from verified subject matter experts
