Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
12 Pages 3210 Words

Management Add in library

Referencing Styles : Harvard
Case StudyCQ Insurance (CQI) offers insurance policies to insure Home-buildings and Home-Contents of Australian residents.  For each of their properties (Homes) of interest, the customers can apply for either a Home-buildings policy or a Home-contents policy or a combined Home-buildings-contents policy.  CQI allows a customer to have only one of the above mentioned policies for each of his/her properties.When new customers approach for an insurance policy (hereafter called as policy), ...

View More
Brice Key Completed Orders: 2418
Customer Feedback   4/5

Very satisfied with the quality of the work. professionally done a received a very good grade for this. will definitely use your service again.

Tags: Australia Melbourne Management Management University of Melbourne Management 



The ERD (Entity Relationship Diagram) has been presented above according to the case of CQ Insurance (CQI) that provides insurance policies for Home buildings as well as contents. The assumptions that has been made for designing the ERD from the CQ Insurance case study are listed as below:
•    A single person may be owner of different properties and the properties may contain several items.
•    A single person will be able to select only one policy for each of the properties.
•    The items contained within the properties may or may not be contained within insurance coverage as it depends on the type of chosen policy.
•     There is involvement of agents who are working as employees of the organization to handle the claims processing for customers.
•    A single agent will be associated with handling of several number of policies.

Business Rules

The design of the ER diagram has been done in accordance with the set of rules that has been defined in the case study of CQ Insurance. Various assumptions has been made while designing the ER diagram. The assumptions led to changes in the defined business rules from certain perspectives. The business rules that has been determined after making the assumptions are illustrated as below:
•    Unique policy numbers will be used to store the various policies that will be enrolled by the customers by following a set of specific standards and guidelines. The customers will have the capability to handle their policies by using their unique policy numbers.


If you desire to get fast, safe and affordable assignment services, is the one name you should refer to. Here 3000+ subject experts are dedicated to help and resolve the problems in assignment, essay and dissertation writing. Our 24*7 live chat support team will be happy to help the moment you approach them from anywhere like UK, USA or Australia.

Management has been added in your library.
Free plagiarismFree plagiarism check online on mobile
Have any Query?