Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Based on the following description of operations, create the appropriate fully labeled ERD in both Chens Notation and Crows Foot Notation. An insurance company wants

Based on the following description of operations, create the appropriate fully labeled ERD in both Chens Notation and Crows Foot Notation.

An insurance company wants to maintain a database containing the following information relating to its automobile policies:

Each policy applies to exactly one car, but several people may be listed as drivers under the policy. A person may be listed under several policies.

People are identified by their social-security numbers, and have names and addresses; cars are identified by their registration numbers, and have model names and years.

Each policy has an identifying number and a list of coverage types (such as collision, comprehensive, damage to others property, etc.); for each coverage type the policy has a maximum amount of coverage and a deductible.

The database also contains information about accidents covered by each policy. For each accident, the company needs to know the car and driver involved, as well as the date of the accident and the total amount of money paid out

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

Big Data, Mining, And Analytics Components Of Strategic Decision Making

Authors: Stephan Kudyba

1st Edition

1466568704, 9781466568709

More Books

Students also viewed these Databases questions

Question

c. How is trust demonstrated?

Answered: 1 week ago