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

Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

COIT20247 Database Design And Development 4

tag 0 Download 1 Pages / 244 Words tag 24-09-2020

Question:

Objectives

  • To develop a conceptual data model diagram
  • To perform logical design (optional)

Assignment Specification

In this assignment, you need to perform the following tasks for the given case study:

  • Draw an Entity Relationship (ER) diagram
  • Perform logical design (optional)
  • Create 3NF Relations (optional)

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.

Assignment Requirements

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.

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 1 pages

Cite This Work

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

My Assignment Help. (2020). COIT20247 Database Design And Development 4. Retrieved from https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development-4.

"COIT20247 Database Design And Development 4." My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development-4.

My Assignment Help (2020) COIT20247 Database Design And Development 4 [Online]. Available from: https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development-4
[Accessed 28 January 2023].

My Assignment Help. 'COIT20247 Database Design And Development 4' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development-4> accessed 28 January 2023.

My Assignment Help. COIT20247 Database Design And Development 4 [Internet]. My Assignment Help. 2020 [cited 28 January 2023]. Available from: https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development-4.


Stuck on Any Question

Our best expert will help you with the answer of your question with best explanation.

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

loader
250 words
Error goes here

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

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?
close
Subtraction Payment required!

Only one step away from your solution of order no.