Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Assessment item 1—Assignment 1 Due date: Friday of Week 5 (April 6, XXXXXXXXXX:45 pm AEST) Weighting: 30% Length: N/A Objectives · To develop a conceptual data model diagram · To perform logical...

1 answer below »
Assessment item 1—Assignment 1
Due date:    Friday of Week 5 (April 6, XXXXXXXXXX:45 pm AEST)    
Weighting:    30%
Length:    N/A
· 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.
The attributes of the possible entities have not been mentioned clearly. Hence, you need to assume at least two and at most nine relevant attributes for each of the entities that you will identify for your ER diagram.
In addition to the recommendations in the assessor’s report, the following processes can also provide the reasons for rejection of the claim:
· Verification to ascertain whether the claimed items have been covered by the respective policy or not
· Ensuring that the policy is in force (has not lapsed) at the time of lodging the claim
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.
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, Subu
, State, PostCode, Email)
Invoice (InvoiceNumber, invoiceDate, Total, CustomerId)
foreign key (CustomerId) references Customer(CustomerId)
How and what to submit:
You must make an electronic submission for this assignment using the appropriate assignment submission link in the unit web site.
You should submit a Microsoft Word document containing:
· A copy of your ERD.
· A list of business rules and assumptions including their justifications.
· 3NF Relations – optional
Your document should contain appropriate identifying information (your student number, name, unit number, etc.) and should contain appropriate headings for each section.
Important points
· You must work individually on this assignment.
· The model solution to this assignment will be released approximately TWO (2) weeks after the due date.
· Assignments that are submitted after the release of the model solution will receive zero marks.
· You must state in your assignment (at the end under the heading Acknowledgements is a good place) all materials and sources you used. This may be as simple as 'This assignment was completed using only the COIT20247 unit materials' to mention that you have used only the items provided by the unit COIT20247.
· Before submitting your assignment, review the marking criteria that are available in the assignment specification. Ensure that all the criteria are addressed in your submission.
· After submitting your assignment, please verify that your submission was successful, i.e. download your submitted files to ensure that they are co
· Penalty related to late submission and plagiarism is handled as per the university policies.
Marking Criteria:
    Maximum Marks
    Identified entities (including super type and sub type entities), associative entities, weak entities (if any) and named appropriately
    Provided appropriate attributes
    Provided identifiers/identifying attributes
    Drawn co
ect relationships between entities and named them appropriately
    Used proper symbols for
· entities including super type and sub type; associative entities; weak entities if any
· relationships
· identifying attributes
· min and max cardinalities for the relationships
    Provided appropriate justification for assumptions and business rules
    Penalty due to plagiarism/copying
    Late Penalty: Less 5% of available marks per calendar day
Answered Same Day Apr 05, 2020 COIT20247 Central Queensland University


Amit answered on Apr 06 2020
149 Votes
Student name:
Student ID number:
Course name:
Professor name:
Table of content
    Serial numbe
    Task name
    Page numbe
    Developed ERD to the given case of CQ Insurance company
    Assumptions and other required business rules
    3NF relationships
Developed ERD to the given case of CQ Insurance Company
As CQ insurance is a middle size organization which requires an Information system development. To develop the information system for CQ Insurance Company, the ERD creation is required on initial bases [Minker, 2014]. The creation of ERD defines the entities, attributes and possible relationships for information system development. The crow’s foot ERD for this insurance company is provided below:
Assumptions and other required business rules
Each ERD creation requires different business rules and different possible assumptions in its development [Coronel & Mo
is, 2016]. The used business rules to the ERD development of given case of CQ insurance are mentioned here:
1. The policyNumber, customerNumber, invoiceNumber, claimNumber, and propertyNumber are considered as numeric values.
2. The text data form is used for property details, customer details and details related to any claim.
3. The date data form...

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here