Question: Need help on question 2 Question 1 (25 pts) Create an ER diagram for a car insurance company whose customers can own one or more
Need help on question 2
Question 1 (25 pts) Create an ER diagram for a car insurance company whose customers can own one or more cars. Each car can be associated with zero to any number of recorded accidents. An accident can involve multiple cars. The company stores information about the driver's licenses of customers which include driver's license number and state issued. Name of the customer, home address and phone numbers (of customers) will be stored. For a car, the company also stores make, model, year, color, vehicle identification number. The number of previous accidents should also be reported. For the accidents, a report number should be stored along with a date and time. Also stored is a composite location attribute (which has both the coordinates (with x and y coordinates) for analytics and an address that is closest to the point location of incident). Please use min-max notation and list all of your assumptions when constructing your ER diagram. Make sure your assumptions do not contradict with the requirements. Question 2 (15 pts) For all the attributes you have created for the car insurance company design (in Question 1), list the attributes and the domains of those attributes
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
