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
expert
Brice Key Completed Orders: 2418
5/5
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 

Solutions

Assumptions

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.

OR

MyAssignmenthelp.com is committed to alleviate the academic stress of students and help them achieve the desired academic results. Our college coursework help service has assisted numerous students from all corners of USA. Students recommend our services because they get everything under one roof. Our wide range of coursework help services include chemistry coursework help, marketing coursework help, finance coursework help, maths coursework help and much more. We also have GCSE coursework writing experts who take care of students studying under this board. Students, who often wonder is it safe to pay someone do my coursework can rely on us.

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