Coit20247 The Home Content Policy Assessment Answer

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 Assessment Answers Online

Talk to our expert to get the help with Coit20247 The Home Content Policy Assessment Answers from Assignment Hippo Experts to complete your assessment on time and boost your grades now

The main aim/motive of the finance 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 assignment help Australia. 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 www.assignmenthippo.com are so much skilled, capable, talented, and experienced in their field and use our best and free Citation Generator and cite your writing assignments, so, for this, they can effectively write the best economics assignment help services.

Get Online Support for Coit20247 The Home Content Policy Assessment Answer Assignment Help Online

Want to order fresh copy of the Sample Coit20247 The Home Content Policy Assessment Answers? online or do you need the old solutions for Sample Coit20247 The Home Content Policy Assessment Answer, contact our customer support or talk to us to get the answers of it.

Assignment Help Australia
Want latest solution of this assignment

Want to order fresh copy of the Coit20247 The Home Content Policy Assessment Answers? online or do you need the old solutions for Sample Coit20247 The Home Content Policy Assessment Answer, contact our customer support or talk to us to get the answers of it.