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

COIT20247 Database Design And Development 3

tag 1 Download2 Pages / 254 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.

 

Answer:

Entity Relationship Diagram

 

(Smartdraw, 2016)

Assumptions and Business Rules

Following business rules and assumptions are put into practice into the CQI database-

  1. A customer can insure more than one property.
  2. Each property should be attached with addresses.
  3. Each claim should be belonged to one customer.
  4. The policy premium will be on yearly basis in CQI.
  5. The policy types available at CQI are- ‘Home’, ‘Content’ and ‘HomeContent’.

Logical Design

TbPolicy(FlPolicyID, FlStartDate, FlEndDate, FlYearlyPremium, FlOtherDetails)

TbHome (FlPolicyID, FlHomeAddress, FlHomeBuiltDate, FlOtherDetails)

TbContent (FlPolicyID, FlContent, FlContentDetail)

TbHomeContent (FlPolicyID, FlHomeAddress, FlHomeBuiltDate, FlContent, FlContentDetail)

TbAddresses (FlAddressID, FlStreet, FlCity, FlState, FlPostcode)

TbCustomerContent (FlContent, FlContentDetail)

TbCustomer (FlCustomerID, FlName, FlAddressID, FlContent, FlDOB, FlPhone, FlMobile)

Foreign Key

References

FlAddressID

TbAddresses (FlAddressID)

FlContent

TbCustomerContent (FlContent)

 

TbCustomerPolicy (FlCustomerID, FlPolicyID)

Foreign Key

References

FlCustomerID

TbCustomer (FlCustomerID)

FlPolicyID

TbPolicy (FlPolicyID)

 

TbClaim (FlClaimID, FlCustomerID, FlPolicyID, FlDateOfClaim, FlDateOfSettlement, FlAmountClaimed, FlAmountPaid, FlTotalPoliciesRevenue, FlTotalClaimsSettlements, FlOtherDetails)

Foreign Key

References

FlCustomerID, FlPolicyID

TbCustomerPolicy (CustomerID, PolicyID)

 

TbAssessor(FlAssessorID, FlAssessorDetail)

TbClaimDocument (FlClaimID, FlDocumentType, FlAssessorID, FlCreatedDate)

Foreign Key

References

FlClaimID

TbClaim (FlClaimID)

FlAssessorID

TbAssessor (FlAssessorID)

 

TbClaimProcessStages (FlClaimStageID, FlClaimStatusName, FlClaimStatusDescription)

TbClaimStageOutcomes (FlClaimOutcomeCode, FlClaimOutcomeName, FlClaimOutcomeDescription)

TbClaimProcess (FlClaimProcessID, FlClaimID, FlClaimOutcomeCode, FlClaimStageID, FlAssessorID, FlOtherDetails)

Foreign Key

References

FlClaimID

TbClaim (FlClaimID)

FlClaimOutcomeCode

TbClaimStageOutcomes (FlClaimOutcomeCode)

FlAssessorID

TbAssessor (FlAssessorID)

FlClaimStageID

TbClaimProcessStages (FlClaimStageID)

(Edugrabs.com, 2015)

 

References

Smartdraw (2016), Entity Relationship Diagram, Retrieved from https://www.smartdraw.com/entity-relationship-diagram/.

Edugrabs.com (2015), Types of Attributes in DBMS with Example (ER MODEL – Part 2), Retrieved from: https://www.edugrabs.com/type-of-attributes-in-dbms/

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). Database Design And Development 3. Retrieved from https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development-3.

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

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

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

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


Are you not being able to crack overly tricky CPM homework? No worries. Ask us to write my paper and go stress-free. We have the best team of focused academic experts who knows how to solve each CPM questions with precision.  Our paper writing service aims to add excellence to the assignment with no loose ends. So, without much ado, get in touch with us right away, place your concern and take home brilliantly solved geometry homework on a plethora of intricate CPM topics.

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,382,993

Orders

4.9/5

Overall Rating

5,085

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

610 Order Completed

100% Response Time

Cheryl Zhao

PhD in Statistics

Singapore, Singapore

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

2109 Order Completed

99% Response Time

Emma Zhong

Ph.D in Project Management with Specialization in Project Communications Management

Singapore, Singapore

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

529 Order Completed

95% Response Time

Ivan Blank

PhD in Functional Human Biology

Wellington, New Zealand

Hire Me
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

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?