301028: Advanced Healthcare Data Environments Report - IT Computer Science Assignment Help

Assignment Task:

Task:

Task Description

SECTION 1

 Students are to conduct a detailed analysis of the publicly available critical care database named MIMIC-III (Medical Information Mart for Intensive Care III) at https://mimic.mit.edu/docs/iii/ . You need to thoroughly study of all the table information provided in relation to MIMIC-III at https://mimic.mit.edu/docs/iii/tables/ to complete this assessment task. NOTE: You are NOT required to download and install the MIMIC-III database. After careful analysis of MIMIC-III information given on the website create a report addressing the following:

1. Identify and discuss** specific data items out of the tables of MIMIC-III dataset that would be used to create a report (see Figure 1 below) that lists the number of patients that were prescribed the four (4) drugs Lotensin, Capoten, Vasotec, and Monopril in the year 2020. Write the correct SQL statement/s that you would use to extract data for this part (15 marks) Figure 1: Sample Report

2. Identify and discuss** specific data items out of the tables of MIMIC-III dataset that would be used to create a report (see Figure 2 below) that lists the patient IDs, Gender, Ethnicity, date of birth and date of death of the people who died in the year 2020 AND was given any one of the hypertension medications: Lotensin, Capoten, Vasotec, and Monopril. Write the correct SQL statement/s that you would use to extract data for this part. (15 marks) Figure 2: Sample Report

3. Identify and discuss** the data items that would be used to create a full discharge summary for each patient for an episode of care, and explain why each of these data items is needed. (10 marks)

4. Provide a summary of your reflections in working with the MIMIC-III dataset, And explain a research project that you would like to conduct using the data available in this MIMIC-III dataset. (10 marks)

The above IT Assignment has been solved by our  IT Assignment  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 considered worthy of the highest distinction.