Design a database for an insurance company

Assignment Help Database Management System
Reference no: EM13313047

Objectives:
After completion of this assignment, you will be able to:
- Map real world scenarios into ER diagrams
- Design ER diagrams and EER
- Produce relational schemas with constraints requirements
- Use specialization and generalization techniques

Problem I:

Consider a video game store. For each game, the database contains information about title, producing company name, designer(s) name(s), version of the game, type of the game and characters in the game. For each character in the game, it contains the character's name. The video games may be available at the store in different formats. Different formats may have different prices. Each game and format has a status indicating whether it is discontinued or not.

1. Draw the ER diagram for the database described above.
2. Create a relational database schema for this model assuming
a) Each video game in the database is available at the store in exactly one format.
b) Some video games in the database may not be available at the store and others may be present in more than one format.

Provide the name of the table, primary key, and other attributes for each table in your solution. Think intelligently between various choices available to map the E/R diagram to relations, to get best design for the problem in hand. Minimize the use of NULLs. Your representation will be evaluated based on correctness and succinctness.

Problem II:

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. 


Attachment:- Assignment.doc

Reference no: EM13313047

Questions Cloud

How much work is done by the force of gravity on the box : A 20kg box slides 45m from the top down to the bottom of an incline that is 10 degrees to the horizontal. How much work is done by the force of gravity on the box
Explain how to verify that the third central moment is zero : Write a computer program that generates a sequence of random variables from a normal distribution with mean 5 and standard deviation 2. a) Verify that sample mean and the sample variance converge to the respective population values.
Prepare a job cost sheet : Prepare a job cost sheet and record the information given above and also a cost summary for job and prepare a purchases budget in units and dollars for the quarter ending 30th December 2014.
Find the magnification of the image : An object is 12.0 cm from the surface of a spherical Christmas tree ornament that is 8.00 cm in diameter. What is the magnification of the image
Design a database for an insurance company : Consider a video game store. For each game, the database contains information about title, producing company name, designer(s) name(s), version of the game, type of the game and characters in the game.
Write macro that will take the distance between two cities : Transportation need to evaluate the time spent in traveling from city A to city B. The distance between the two cities is a variable because the macro developed is to be used for other cities.
Marketing and finance majors are different : At alpha = 0.05 significance level, is there evidence to suggest that the number of courses successfully completed by management, marketing and finance majors are different? True or false: Ha: Umanagement not = Umarketing not = Ufinance
What are the criteria for selecting target markets : What are the criteria for selecting target markets. What are the criteria for selecting targets? Why would they be different from the criteria for segmentation?
Professional context must create negative messages : Sometimes, people writing in a professional context must create negative messages, such as a letter of termination, a press release regarding a company error, a denial of a claim, or a poor performance review. When you write such a negative message, ..

Reviews

Write a Review

 

Database Management System Questions & Answers

  Explain relation schema and set of functional dependencies

Consider relation schema r(A,B,C,D,E, F) and a set of functional dependencies {A BCD,BCDE,BD,DA}. Calculate canonical cover for set of functional dependencies (show each step of your derivation with an explanation).

  Analyzing hard-to-obtain data from two separate databases

You are interested in analyzing some hard-to-obtain data from two separate databases. Each database contains n numerical values.

  Write set of relational schemas-identify primary-foreign key

Sketch an E-R diagram which reflects the above reuirements. Write a set of relational schemas and identify primary and foreign keys. Try not to include redundant schemas.

  Types of relationships in a design model of a database

There are many kinds of relationships in a design model of a database. Why is it important to classify each of these types in an ERD Model?

  Design diagram data warehouse using star schema

Assume that data warehouse consists of three dimensions time, customer, and cell phone plan, and two measures number of calls and cell phone bill. Sketch a schema diagram for above data warehouse using star schema.

  What is the output when the following script is executed

Determine the answer (expected result) based on your reading of from text book: -  Just show the expected output when you run the syntax.

  Develop preliminary database tables for huffman trucking log

Use Microsoft Access to develop preliminary (no keys and no relationships) database tables for Huffman Trucking Driver Log.

  Compare two non-sequential file structure models

Compare the two non-sequential file structure models. What advantages does the first one have over the second and what advantages does the second have over the first?

  Create a crow''s foot erd using a specialization hierarchy

Given the following business scenario, create a Crow's Foot ERD using a specialization hierarchy if appropriate. Tiny Hospital keeps information on patients and hospital rooms

  Describe a minimum of three heuristics to optimize queries

Your supervisors and customers are very impressed with the database you have put together. Describe a minimum of three heuristics to optimize Queries.

  Write procedures using counter and sychronisation techniques

Write the following procedures: woman_wants_to_enter, man_wants_to_enter, woman_leaves, man_leaves, using counters and sychronisation techniques to ensure that the correct behaviour will occur.

  Indicate change to make original premiere products database

Indicate the changes (using the shorthand representation) that you would need to make to the original premiere products database desing to support the following requirements.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd