New

Learn smart - Learn online. Upto 88% off on courses for a limited time. View Courses

Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

IMAT5103 | Database System Design-Case Study Of CQ Insurance

tag 0 Download 3 Pages / 719 Words tag 15-07-2020
  • Course Code: IMAT5103
  • University: De Montfort University
    icon

    MyAssignmentHelp.com is not sponsored or endorsed by this college or university

  • Country: United Kingdom

Questions:

Case Study

CQ 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), CQI collects their details so that they can communicate with them in future. Each policy requires full premium payment prior to the coverage period of one year. At the time of preparing the policies, CQI collects the details of the property (Home) and/or items (Home contents) depending upon the type of the policy that the customer is interested in.

At the time when a customer lodges an insurance claim (hereafter called as claim) such as collapse of false ceiling, loss of home contents, etc., CQI ensures that the insurance policy has not lapsed prior to processing the claims and further verifies that the items claimed have been covered by the respective policy. A claim should be related to only one policy but each claim is not limited to only one item that has been covered by the policy. As part of the claim-processing for each of the claims, an assessor (appointed by CQI) prepares and submits an initial assessment and if required the assessor also prepares and submits a final assessment. The assessor’s initial assessment may recommend either to further process or reject the related claim. The assessor’s final assessment will provide the total amount that can be settled relating to the claim and may contain a memo that describes the recommended settlement amount for each of the items that have been claimed.

In this assignment, you need to create an Entity Relationship (ER) diagram relevant to the above case study and optionally perform logical design to produce appropriate 3NF Relations.
The attributes for various entities have not been purposely described in the case study so that the students are encouraged to further research and list the pertinent attributes in addition to the required identifier for each and every entity in their ERD.

1.Draw an appropriate ER diagram

Use the symbols as prescribed in your unit-textbook to draw the ER diagram (ERD) for the above case study.

Your ERD must

•show all necessary entities, attributes and relationships
•show identifiers/identifying attributes as necessary
•show multi-valued attributes, if any
•show participation and cardinality
•show associative entities, if appropriate
•show weak entities, if any
•use the notation described in the set text
•use consistent and appropriate naming for entities and attributes as specified in the unit text book

Some business rules or other aspects of the case study may not be clear to you when you read the case study. If this is the case, then you should either approach your lecturer or tutor for clarification, or you may simply make an assumption and then develop your ERD accordingly. For example, the case study might not mention all relevant participation information (also called minimum cardinalities). If so, you may make an assumption about what the minimum cardinalities might reasonably be, and then show them in your ERD accordingly. You should justify each assumption in terms of the business, for example: it is assumed that each customer must have at least one policy because it is assumed that the business does not record customer details until the customer opts for a policy with them. To get yourself started, ask yourself, 'If I were running this business, what things I need to keep a list of?' Write those things down. For each thing, what information would you need to record about it? How can it be identified? The answers to these questions will help you to develop your ERD.

2.Assumptions and Business rules

Provide assumptions and business rules relevant to your ERD.

3.Create Logical Design (Optional):

If you would like to perform this optional component of this assignment, you can map your Entity Relationship diagram (ERD) into relations and make sure that all the relations are in 3NF. Provide all the relations in the following format:

Customer (CustomerId, customerName, Street, Suburb, State, PostCode, Email)

Invoice (InvoiceNumber, invoiceDate, Total, CustomerId)

foreign key (CustomerId) references Customer(CustomerId)
 
 
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 3 pages

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2020). | Database System Design-Case Study Of CQ Insurance. Retrieved from https://myassignmenthelp.com/free-samples/imat5103-database-system-design-case-study-of-cq-insurance.

"| Database System Design-Case Study Of CQ Insurance." My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/imat5103-database-system-design-case-study-of-cq-insurance.

My Assignment Help (2020) | Database System Design-Case Study Of CQ Insurance [Online]. Available from: https://myassignmenthelp.com/free-samples/imat5103-database-system-design-case-study-of-cq-insurance
[Accessed 13 August 2022].

My Assignment Help. '| Database System Design-Case Study Of CQ Insurance' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/imat5103-database-system-design-case-study-of-cq-insurance> accessed 13 August 2022.

My Assignment Help. | Database System Design-Case Study Of CQ Insurance [Internet]. My Assignment Help. 2020 [cited 13 August 2022]. Available from: https://myassignmenthelp.com/free-samples/imat5103-database-system-design-case-study-of-cq-insurance.


We Can Help!

Get top notch assistance from our best tutors !
Excel in your academics & career in one easy click!

icon

Other Samples

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?