HIM3 - Health Data Extraction and Reporting - Medical Science Assignment Help

Assignment Task

In this assignment you are required to create queries and write a report based on the following scenario. The database for this assignment is provided.

Scenario: The Health Promotion officer at the local community health centre requires information that would assist in the planning of sessions to be given at local schools aimed at reducing injuries. You will need to identify the most common (top 10) injuries occurring in the young in Victoria and for each of those injuries identify the group of people to which they occur (gender, age group), and what are the common causes of each injury.

You are required to:

• Decide the table/s you will need to answer your question.

• Prepare your queries

• Firstly, build a query to identify the top 10 and save that query to use as the basis for all other processing Hint: Use count of Tdiag1 field
• Create a separate query for Age and Sex using Q1 and adding other tables. Hint: you can use Q1 and original table to create a crosstab query for these ones.
• Create a query to show the most common causes (top 10) of the top 10 diagnosis. Hint

1: you need to use Q1 and Hint

2: For the report is better to have levels (First level shows a Tdiag1 and the next level are causes in multiple rows)

This (HIM3) Medical Science Assignment has been solved by our Medical Science experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinctio.