COIT20247 The Home Content Policy
Even though a property can be owned by many persons, it is assumed that only one person owns a property. A person’s details may be existing even though the related property details are not available at that time
A person can have many properties.
A policy cannot exist without the property details that it is covering. However, a property’s details may be existing and it may be related to a policy later on.
A policy can be either Home Building policy or Home Content policy or it can be of both.
A Home Content policy can cover many items of different kind/type. A policy can cover more than one item of the same kind. i.e., If there are more than one piece of item of the same kind such as 60” LED LG TV to be covered in the same policy, then quantity value has to be entered appropriately.
Each claim is for one policy only and every claim requires an existing policy. Due to operational reasons, a claim may contain details of some contents other than those mentioned in Home content policy. A claim when processed results into either settled or rejected claim only. If a claim is rejected, then it cannot be settled at all. i.e., combination of settlement of some items and rejection of remaining items from the same claim are not performed in this model.
Each claim is handled by one assessor only.
An assessor may handle many claims but for each claim, he/she submits one initial and one final report only and hence final report is assumed to be an extension of initial report (initial report has been treated as report).
Reason for rejecting a claim may be due to lapsed period or as recommended by the assessor.
An assessor is also a person and there could many other type of persons in future.
An assessor can have many qualifications.
Total premium amount is the sum of Home Building Premium and Content premium amount for a combined policy.
The amount settled for a claim is as per the final assessment submitted by the assessor.
The details of the recommendation for claim settlement is submitted in the form of memo/report by the assessor.
Answer:
1. Functional dependencies: -
I select PERSON and PROPERTY relations. Here we get all the information related to PROPERTY by PropertyID. PropertyID also provides the information of PersonId then PersonId provides all information related to Person.
PropertyID-> {Address, Street, City, Postcode, PersonId }
PersonId-> {PersonName, Address, Street, City, Postcode, PersonType }
2. Relation in Third Normal Form (3NF)
PROPERTY
|
PropertyID |
Address |
Street |
City |
Postcode |
PersonId* |
Person
|
PersonId |
PersonName |
Address |
Street |
City |
Postcode |
PersonType |
The above two relations are in 3NF because there is no transitive dependency. The relationship between property and person is one person has zero or many properties but each property takes care of one and only one person. Here in property relation, PropertyID is the primary key and PersonId is the foreign key. in Person relation, PersonId is the primary key.
3.Two interesting things: -
- How to create the report by using query and how to design a report in an effective manner. Firstly I create a query according to the report requirements. Then I create a report by using report wizard. In report wizard, I select query that I was created according to reporting requirements. Then I select only that information that required for the report. Then I used to group function group policy and property information. In detail section, I display claims information. I used sort function to order the claim by rejected date. Then I open the report in design view and format it in an effective manner.
- How to get correct result by using many functions in queries. In this assignment I used count function, also used queries as the column of a table. I also used sum function to calculate the amount according to requirements.
- 4. Complex requirement: -
When I try to solve the first and third query then I think how to count the child table's records by using parent table. Then I decide to type query as the column of the table and count the records of child table according to requirements. Then I execute the query. It displays right output but repeats the output. This output repeated equal to the number of records in the parent table. Then I try many conditions in the query and also try query by changing data in tables. But it displays repeat output. Then I used top 1 with select then it displays correct result.
References: -
Cronan, J. (2010). Microsoft Office Access 2010. New York: McGraw-Hill.
Eliot, G. (2016). The mill on the Floss. New York: Open Road Integrated Media.
Elmasri, R. and Navathe, S. (2017). Fundamentals of database systems. 1272 Seiten: [Verlag nicht ermittelbar].
Griffith, G., Bradly, T., Long, C., Ranlett, C. and Marshall, K. (2011). Microsoft Access 2010 24-hour trainer. Indianapolis, Ind.: Wrox/Wiley Pub.
MacWhinney, B. (2000). The database. Mahwah, NJ [u.a.]: Lawrence Erlbaum.
Munnelly, B. and Holden, P. (2002). ECDL3 for Microsoft Office 95/97. London: Prentice Hall.
O'Leary, T. and O'Leary, L. (2011). Microsoft Access 2010. New York, NY: McGraw-Hill.
O'Neil, P. (2014). Database. Elsevier Science.
SILBERSCHATZ, A. (2019). DATABASE SYSTEM CONCEPTS. [S.l.]: MCGRAW-HILL EDUCATION.
Tremblay, D. (2011). Access 2010. [Fairport]: Axzo Press.
Buy COIT20247 The Home Content Policy Answers Online
Talk to our expert to get the help with COIT20247 The Home Content Policy Answers to complete your assessment on time and boost your grades now
The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.
