Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

How To Build A Million Dollar Database

Authors: Michelle Bergquist

1st Edition

0615246842, 978-0615246840

More Books

Students also viewed these Databases questions