You are to design a database for an insurance company the

Assignment Help Database Management System

Reference no: EM13380057

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: EM13380057

Questions Cloud

This assignment will focus on creating java servlets that : this assignment will focus on creating java servlets that can not only serve html to web users but also provide a web

What needs to be considered in devising a companys policy : what needs to be considered in devising a companys policy for selecting a methodology to develop software

Open source technology is a reliable basis for system-level : open source technology is a reliable basis for system-level software and open source tools are finding their way into

Consider the eer diagram for a car dealer in the figure : consider the eer diagram for a car dealer in the figure below. map the eer schema into a set of relations. for the

You are to design a database for an insurance company the : you are to design a database for an insurance company. the data will include information about customers name address

Consider a video game store for each game the : consider a video game store. for each game the databasenbspcontains information aboutnbsptitle producing company name

1 create a new database named membership2 write the create : 1 . create a new database named membership.2. write the create table statements needed to implement the following

Many midsized firms are investing in erp system packages : many midsized firms are investing in erp system packages such as sap and peoplesoft.comment on what you think might be

You are a manager in a company that has a lot of in-house : you are a manager in a company that has a lot of in-house is expertise.what might be your key decision rules for when

User Account

All Pages