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