Design a database for an insurance company

Assignment Help Database Management System

Reference no: EM13188118

You are to design a database for an insurance company. The data will include information about customers (name, address, phone number), information about insured cars (make, model, year, vehicle-ID#, license#, insurance rate), information about insured homes (address, insured value, insurance rate), and information about claims made on insured cars and homes (date of claim, date of settlement, amount of settlement). You may assume that all insured cars and homes are owned by a single customer, but you should allow a customer to own several cars and homes. Please state any additional assumptions you make about the real world in your design.

a) Specify an entity-relationship (E/R) diagram for your database. Don't forget to underline key attributes for entity sets and include arrowheads indicating the multiplicity of relationships (with rounded arrowheads for referential integrity). If there are weak entity sets or "isa" relationships, make sure to notate them appropriately.

Reference no: EM13188118

Questions Cloud

How the equilibrium price and equilibrium quanity changes : Milk becomes more popular amd better feed increases milk production. how do these events influence demand and supply describe how the equilibrium price and equilibrium quanity changes.

Explain hypochlorous acid and hypochlorite ion : Write the reaction equation for acid-base equilibrium between hypochlorous acid and hypochlorite ion.

What is the dollar value of the dead weightloss : q1=20 Q2=15 Q3=27 mARKET EQUILIBRIUM IS $45 price at A=85 C=5 F=59 G=31 what is the dollar value of the dead weightloss when output level q2 is produced what is the total surplus wen output q2 is being produced

State concentration of the standard naoh solution : Explain the difference in the answers to question 2 and question 5. Which is the "correct" value for the concentration of the standard NaOH solution? Why?

Design a database for an insurance company : Don't forget to underline key attributes for entity sets and include arrowheads indicating the multiplicity of relationships

How many ways a vending company can buy three : Determine how many ways a vending company can buy three of these units and receive (a) no defective units, (b) all defective units and, (c) at least one good unit.

How to design a breathing machine : Get a glass and fill it with cold tap water. Observe the water in the glass as it warms to room temp. What effect does temp have on the amount of gas that can remain dissolved in water? Can you use this information to explain boiling?

What is the index of a radical : What is the index of a radical? When working with radicals, can the radicand be negative when the index is odd? Can it be negative when the index is even?

Create a relational database schema : Draw the ER diagram for the database described above and create a relational database schema for this model assuming

User Account

All Pages