Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started