country
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!

OIT20247 Database Design And Development

tag 0 Download2 Pages / 300 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

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.

  • 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 andrelationships
  • show identifiers/identifying attributes as necessary
  • show multi-valued attributes, ifany
  • show participation andcardinality
  • show associative entities, ifappropriate
  • show weak entities, if any
  • use the notation described in the settext
  • use consistent and appropriate naming for entities and attributes  as specified in the unit text book

Provide assumptions and business rules relevant to your ERD.

 

Answer:

Business Rules

Every Entity Relationship Model must have a strong set of business rules. For the CQ Insurance company’s database adaptation, the business rules that have been implemented into the ER Diagram are as follows:

  1. A customer can apply for only one of the insurance policies. He can buy the insurance for either a building policy or a home-contents policy for a particular property of his interest, or may be a building-contents policy.
  2. The customers must pay the complete insurance payments beforehand, for a period of 1 year.
  3. The claims made by customers must be within 1 year of application.
  4. Each claim must have required reasons.
  5. Each claim can be linked to only one policy of the customer.
  6. One claim can cover multiple home-contents.
  7. An assessor must prepare and submit both initial for each claim.
  8. An assessor can reject a claim after initial assessment.
  9. If the initial assessment is passed, the assessor must submit a final assessment.
  10. If final assessment is submitted, each claim must have a final settlement amount.
  11. Each finalized claim may have a memo that describes the amount of settlement.
 

Assumptions

Quite a few assumptions have been made apart from the laid forward business rules to design the ERD. They are as follows:

  1. Each customer must have at least one insurance policy.
  2. One insurance policy can be linked back to only one customer.
  3. For the contents insurance, each content policy can have one or more items insured.
  4. For Building & Contents policy, each policy can have one or more items insured but only one building.
  5. Each assessor may have attended none or many claims.
  6. One claimID can have zero or only one existence in the finalized list.

Figure 1 below, represents the ER Diagram for the above discussed case study.

Figure 1. Entity Relationship Diagram for CQI

Download Sample

Get 100% money back after download, simply upload your unique content* of similar no. of pages or more. We verify your content and once successfully verified 100% value credited to your wallet within 7 days.

Upload Unique Document

Document Under Evaluation

Get Credits into Your Wallet

*The content must not be available online or in our existing Database to qualify as unique.

Cite This Work

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

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

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

My Assignment Help (2020) OIT20247 Database Design And Development [Online]. Available from: https://myassignmenthelp.com/free-samples/oit20247-database-design-and-development
[Accessed 03 August 2020].

My Assignment Help. 'OIT20247 Database Design And Development' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/oit20247-database-design-and-development> accessed 03 August 2020.

My Assignment Help. OIT20247 Database Design And Development [Internet]. My Assignment Help. 2020 [cited 03 August 2020]. Available from: https://myassignmenthelp.com/free-samples/oit20247-database-design-and-development.


MyAssignmenthelp.com can be your one-stop destination, if your aim is to avail remarkable academic writing services. More than often, students face real hardships in selecting remarkable topics like persuasive speech topics, informative speech topics, argumentative essay topics, research paper topics and the likes. Do the task of generating intriguing and remarkable topics seem like an arduous task for you? Instead of worrying, hire the remarkable services of MyAssignmenthelp.com. From selecting remarkable topics, drafting an accurate outline, writing a strong introduction, drafting the main body to writing a strong concluding note, our stalwarts can excel all the steps with absolute accuracy and precision. If your aim is to receive remarkable grades, do not hesitate to give us a call. Visit https://myassignmenthelp.com/ to know more about our services.

Latest Database Samples

MIS605 Systems Analysis And Design

Download : 0 | Pages : 10
  • Course Code: MIS605
  • University: Laureate International Universities
  • Country: United States

Answer: 1. (a). Stakeholders are an important part of any project or an organization and they are largely influenced by the outcome of the project. The stakeholders linked with the development of the online student enrolment system at ABC University are indicated as follows- ABC University The Pro Vice Chancellor Program Directors Student Enrollment Officers The above four stakeholders are the key stakeholders for the project of deve...

Read More arrow Tags: Australia Blackburn Database Systems analysis and designs Laureate International Universities 

ITAP3009 Software Analysis Design And Architecture 2

Download : 0 | Pages : 9
  • Course Code: ITAP3009
  • University: Victorian Institute Of Technology
  • Country: Australia

Answer: Introduction Social Services are activities which are focused on the creation of a strong community, effective organization while endorsing equity in opportunities and transparency in transactions. Some of the services rendered include, but not limited to, job training, education, policy research, adoption, health care and food subsidies. The social service system aims at providing happy and comfortable life for individuals around a g...

Read More arrow Tags: Australia 47 software analysis  design and architecture Victorian Institute of technology 

ICT700 Systems Analysis

Download : 0 | Pages : 10

Answer: Introduction: System analysis and design is a high level process that consist of methodologies to develop a high quality system. System analysis and design helps in understanding the logics behind the system and the best possible ways to turn those logics into functional components of the system. Information requirement techniques and system requirements are parts of the system analysis phase. The use cases, UML modelling are part of ...

Read More arrow Tags: Australia Rochedale 47 system analysis University of the Sunshine Coast 

ITECH2306 Agile Coding

Download : 0 | Pages : 4
  • Course Code: ITECH2306
  • University: Federation University
  • Country: Australia

Answer: UML Class Diagrams Before   After   Screenshots demonstrating that your JUnit tests prove that the system has worked as expected Screenshot 1:   Screenshot 1 represents passed JUnit test cases of the 7-property rate calculation when each of the ratepayer did not do any charitable work. Screenshot 2:   Screenshot 2 represents passed Junit test cases of the 7-property rate calculation when each of the ratep...

Read More arrow Tags: Australia Arlington Management University of New South Wales 

COIT20247 Database Design And Development 3

Download : 1 | Pages : 2

Answer: Entity Relationship Diagram   (Smartdraw, 2016) Assumptions and Business Rules Following business rules and assumptions are put into practice into the CQI database- A customer can insure more than one property. Each property should be attached with addresses. Each claim should be belonged to one customer. The policy premium will be on yearly basis in CQI. The policy types available at CQI are- ‘Home’, &lsquo...

Read More arrow
Next
watch

Save Time & improve Grade

Just share Requriment and get customize Solution.

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

1,376,172

Orders

4.9/5

Overall Rating

5,084

Experts

Our Amazing Features

delivery

On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

work

Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

time

24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat.

subject

Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

price

Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 5/5

285 Order Completed

99% Response Time

Eugene Baranowski

MBA in Supply Chain

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

1758 Order Completed

99% Response Time

William Martinez

MS in Biology

Washington, United States

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

1692 Order Completed

98% Response Time

Alfred Dodd

PhD in Computer and Information Science with specialization in Database

Wellington, New Zealand

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

1265 Order Completed

97% Response Time

James Cook

Masters in Management

Wellington, New Zealand

Hire Me

FREE Tools

plagiarism

Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

essay

Essay Typer

Get different kinds of essays typed in minutes with clicks.

edit

GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.

referencing

Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

calculator

Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

Refer Just 5 Friends to Earn More than $2000

Check your estimated earning as per your ability

1

1

1

Your Approx Earning

Live Review

Our Mission Client Satisfaction

Awesome work. Awesome response time. Very thorough & clear. Love the results I get with MAH!

flag

User Id: 383727 - 31 Jul 2020

Australia

student rating student rating student rating student rating student rating

Work was done in a timely manner took it through grammarly checked for plagiarism very well satisfied

flag

User Id: 463334 - 31 Jul 2020

Australia

student rating student rating student rating student rating student rating

Great work for the short notice given. Thank you for never disappointing and helping out.

flag

User Id: 194216 - 31 Jul 2020

Australia

student rating student rating student rating student rating student rating

I received a full point on the assignment. Thank you for all the help with the assignment.

flag

User Id: 411395 - 31 Jul 2020

Australia

student rating student rating student rating student rating student rating
callback request mobile
Have any Query?