Question: You are asked to design a database for an auto insurance company Green Angel that satisfies the following requirements: a. Green Angel has several local

 You are asked to design a database for an auto insurance

You are asked to design a database for an auto insurance company Green Angel that satisfies the following requirements: a. Green Angel has several local offices. Each local office has a unique number, a unique name, an address, and a telephone number. A specific employee who manages the local office. b. The employee record includes social security number, name, address, phone number, date of birth, sex, and salary. Every employee works for a local office. c. Green Angel has several insurance plans. Each plan has a unique code, a fixed premium, a set of criteria for the people who are eligible for the plan. The set of criteria include age range, sex, and the state of residence. d. A subscriber has a unique subscriber's number, name, date of birth, sex, address, telephone number, insurance plan and the employee that handles the subscriber's paper work. Some queries access the records by the last name of the subscriber. Some queries need to refer to the zip code in the address. e. Each claim has a unique claim number, a subscriber, a date, a type of claim, the local office that accepts the claim, and the employee who processes the claim. f. Each claim may have several follow-up records. The record has a sequence number that is unique within the claim, the date of the record and the nature of the record. Design the database using ER model. Show your design by an ER diagram

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!