In this assignment, you need to perform the following tasks for the given 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.
Use the symbols as prescribed in your unit-textbook to draw the ER diagram (ERD) for the above case study.
Your ERD must
Provide assumptions and business rules relevant to your ERD.
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.
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
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
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
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
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
Just share Requriment and get customize Solution.
Our writers make sure that all orders are submitted, prior to the deadline.
Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.
Feel free to contact our assignment writing services any time via phone, email or live chat.
Our writers can provide you professional writing assistance on any subject at any level.
Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.
Get all your documents checked for plagiarism or duplicacy with us.
Get different kinds of essays typed in minutes with clicks.
Calculate your semester grades and cumulative GPa with our GPA Calculator.
Balance any chemical equation in minutes just by entering the formula.
Calculate the number of words and number of pages of all your academic documents.
Our Mission Client Satisfaction
Awesome work. Awesome response time. Very thorough & clear. Love the results I get with MAH!
Work was done in a timely manner took it through grammarly checked for plagiarism very well satisfied
Great work for the short notice given. Thank you for never disappointing and helping out.
I received a full point on the assignment. Thank you for all the help with the assignment.