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 ERNeed 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

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 Databases Questions!