Answer to Question #221464 in Databases | SQL | Oracle | MS Access for XXX

Question

An automobile insurance company needs to keep track of information about vehicle policyholders. The company has to store information of customer, car, and accident. Customer information is License no, name and address. Customers can own one or more cars, where the car information is Plate_no, model and year. A car not involved or involved in many accidents. If the car is involved in an accident the information that will be stored is Report_number, location, and date. Each car that is involved in accident the damage amount will be estimate.

Draw the ERD.

Answer 1

The answer to your question is provided in the image: