Produce an entity-relationship diagram

Assignment Help Database Management System
Reference no: EM13313949

A policy-holder may have a number of policies with the insurance company. Each policy is given a policy number and relates to a single policy-holder. The company has a range of insurance products and may put together a range of products to form a policy. Examples of motor products are: third party, fire, theft, accident damage, windscreen cover, etc. Brokers sell policies for commission and any one policy may have commission payable to more than one broker. Claims are made against policies. A claim relates to only one policy and each claim is classified according to one of six claim types. The company's products are grouped by business area, i.e. life, motor, marine, etc. Any particular product belongs to only one business area. The company holds information on clubs and associations, for promotions and selective mailings. A policy-holder may belong to a number of different associations.

(a) Produce an Entity-Relationship diagram which represents the above activities of the insurance company. Indicate the names and degrees of all the relationships. Give appropriate attributes for each entity shown, and identify the primary key for each entity.

(b) Give three queries which would be most likely to be asked in this scenario and give a clear explanation of how each may be answered.

 

Attachment:- Assigment.docx

Reference no: EM13313949

Questions Cloud

Explain what is the ph of this new solution : at is the pH of this new solution. Assume no volume change after NaOH(s) was added. Molar Mass NaOH= 39.998 g/mol. Answer given was pH = 13.52, What are the steps to get here
Could a relation be stored as a sequential file : Suppose a sequential file contains 50,000 records, and 5 milliseconds are required to interrogate an entry. How long should we expect to wait when retrieving a record from the middle of the file?
How much work is done by you on the pulling : A wheel is mounted on a stationary axle which we can assume frictionless. As a result, the wheel can turn freely but cannot translate. How much work is done by you on the pulling
Determine the position of the center of mass of this object : A toy is made with three equal masses of 100 grams in the vertices of an equilateral triangle of side 7 cm. Determine the position of the center of mass of this object
Produce an entity-relationship diagram : Produce an Entity-Relationship diagram which represents the above activities of the insurance company. Indicate the names and degrees of all the relationships. Give appropriate attributes for each entity shown, and identify the primary key for eac..
Determine what is the maximum shear stress : A steel tube has an outside diameter of 2.5 inches and an inside diameter of 2.375 (1/8" thick). If it transmits 35 hp when turning at 2700 rpm, what is the maximum shear stress
Explain the solution and allowed to dissolve : A sample of 0.05567 mole sodium acetate was dissolved into 150.0 mL of water. If 2.00g of NaOH(s) was added to the solution and allowed to dissolve
Discuss your company of expertise : Discuss your Company Of Expertise
How many excited states are there : Use the semi-infinite-well potential to model a deuteron, a nucleus consisting of a neutron and a proton. How many excited states are there

Reviews

Write a Review

 

Database Management System Questions & Answers

  Advantages and disadvantages of working with multiple tables

Write down the advantages and disadvantages of working with multiple tables? Write an example of situation where multiple tables would be suitable in the application.

  What messages are sent if not well-formed

Create new DOM documents for each of your .xml file and .xsl file. Use these to generate output to the browser.

  Determine functional dependencies of table

Using your knowledge of Premiere Products, determine the functional dependencies that exist in the following table.

  Discuss the costs involved in implementing the database

Using the SafeAssign link in Blackboard to submit your report. Download and print out the FULL report and attach to the appendix at the back of your report. Assignments without the full SafeAssign report will NOT be marked.

  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?

  What are input and‘output tax accounts in sap

Explain the ‘Document Principle' as used in SAP. What information is presented in the ‘header' section of a document versus the ‘line item' section?

  Define security threats as it relate to the operating system

Discuss security threats as it relate to the Operating Systems and Memory Management. Consider a fixed partitioning scheme with equal-size partitions of 2 16 bytes and a total main memory size of 2^24 bytes. A process table is maintained that inc..

  Evaluate a dbms in terms of lock granularity

Suppose you are asked to evaluate a DBMS in terms of lock granularity and the different locking levels. Create a simple database environment in which these features would be important.

  What are the data entities of this enterprise

Consider a student club or organization in which you are a member. What are the data entities of this enterprise? List and define each entity

  Assume that a student table in a university

Assume that a student table in a university database has an index on StudentID (the primary key). and additional indexes on Major, Age, Marital status, and HomeZipCode.

  Create an update query to select all records in the tbl over

Create an update query to select all records in the tblOverPriced, decrease the Price field values by 10%, run and close the query.

  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.

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