+1-415-670-9189
info@expertsmind.com
Find the oldest person in the data
Course:- Database Management System
Reference No.:- EM131415474




Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
Assignment Help >> Database Management System

Question 1: Using the attached data previously provided to you, do the following tasks as separate SQLs. 

1. Remove visits from dead patients and count distinct number of remaining patients

2. Remove diagnoses before birth, i.e. negative age of diagnosis and count number of distinct diagnoses remaining

3. Remove patients with more than 365 diagnosis per year of age and count number of patients remaining

4. Remove diagnoses after age of 110

5. Remove diagnoses with no age of diagnosis

6. Find the oldest person in the data

7. Remove patients with less than 365 days between their first and last diagnosis. 

8. Report the number of distinct patients who have only 1 diagnosis

9. For patients who have diabetes, identify the average age of diabetes and standard deviation of the age of diabetes.  Define as diabetic any patient who meets the AHRQ requirement for diabetes

Provide your SQL code as well as answers but no data. 

Question 2: Assess the average impact of CHF on length of stay while controlling for all other comorbidities. To do this, compare all cases with CHF to all controls without the disease. Make sure that in each comparison, patients with and without disease have the same set of comorbidities. Produce a table with the 10 estimates n1 through n10 provided below.

Strata

Cases of CHF

Controls with No CHF

Difference

AA

n1

n6

n1-n6

AA, MI

n2

n7

n2-n7

AA,DM

n3

n8

n3-n8

DM, MI

n4

n9

n4-n9

AA,DM,MI

n5

n10

n5-n10

 

Case

1st Diagnosis

2nd Diagnosis

3rd Diagnosis

4th Diagnosis

Length of stay

Number of Patients

Type

1

MI

CHF

DM


5.56

10

2

MI



AA

4.1

10

3


CHF

DM

AA

5.54

10

4


CHF

DM


3.56

20

5

MI

CHF


AA

7.03

30

6

MI

CHF



5.02

30

7


CHF


AA

5.04

30

8

MI

CHF

DM

AA

7.62

40

9

MI




2.03

40

10


CHF



3.03

40

11

MI


DM


2.6

50

12



DM

AA

2.57

50

13



DM


0.61

60

14




AA

2.12

70

15





0.01

80

16

MI


DM

AA

4.57

120

MI = Myocardial Infarction; CHF = Congestive Heart Failure; DM=Diabetes Mellitus; AA=Alcohol abuse

Attachment:- Assignment File.rar




Put your comment
 
View Conversion
Minimize
  1. user image
    len1415474

    Assignment Work with following details. Subject : SQL, Acess, Excel. Comments/Deadline : Please provide screenshots as well as written code. These are the data needed to complete the assignment. I also sent the assignment. Thanks. Please answer all questions. Use this word document to provide your answers. Provide SQL code and first 10 row of data asked for. Copy charts into this document. Make sure that charts are labeled appropriately. Copy tables into this document, format to fit the space. You can lose points if your work does not look professional. Use only black font color. Use only one font size. Submit only one file, this file – nothing else. Keep all of your work, we may ask for it. Submit on time, any delay in submission will lead to 10% loss of grade.



Ask Question & Get Answers from Experts
Browse some more (Database Management System) Materials
A narrative description of the field chosen for the application being created. This should also include a description of the problem and addressing the weaknesses to be solv
Explain the primary manner in which the chosen method is used in database management systems. Describe the impact and alternative of not having the chosen method available t
Summarize the difference between on-line transaction processing (OLTP) and online analytic processing (OLAP), and their relationship among business intelligence, data wareho
What are the steps you are going to take to complete the development process. You should include a detail requirements (5 pages max), suggested design and ER diagram (you ca
The first part is to create a database and some tables which will be appropriate for a home-budgeting application. That portion of the assignment should be completed from
Your goal is to develop a database that shall allow ECI to keep track of its business and provide the management with the following information regarding the performance of
It should state the problem, provide background and motivation, and describe novel approaches (proposed by others or by you). Your paper might or might not require programmi
This is the final installment of the project! The focus is to write SQL queries that combine data from both Mondial and GapMinder (GM). For most queries you will need both Mon