Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use ER diagram and do not use UML Instructions Design a database for a car insurance company with a set of customers each of which

Use ER diagram and do not use UML image text in transcribed
Instructions Design a database for a car insurance company with a set of customers each of which owns a number of cars. Each car has current insurance information and a number of recorded accidents associated with it if there is any). Customer's information like social security number, name, gender, data of birth, points should be stored in the database. Each car has VIN (vehicle identification number), make, model, year, color. Different insurance has different policy number. Several cars can be covered under the same insurance policy. Information like coverage, starting date, expire date are used to describe an insurance for different cars. [They can be different even though they are under the same insurance policy ] Each accident has a report number. If there are several cars involved in one accident they will have the same report number. The detail information like damage of each car, location date description of the collision also needs to be recorded. Construct an ER model for the database using UML diagram

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

DB2 9 For Linux UNIX And Windows Advanced Database Administration Certification Certification Study Guide

Authors: Roger E. Sanders, Dwaine R Snow

1st Edition

1583470808, 978-1583470800

More Books

Students also viewed these Databases questions

Question

7. How will you encourage her to report back on the findings?

Answered: 1 week ago

Question

Were the decisions based on appropriate facts?

Answered: 1 week ago

Question

Were the right people involved in the decision-making process?

Answered: 1 week ago