+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
Mr Sev N O'Nine, your manager, has set up the following tasks for you to complete for this phase of the project: Create a Database and import the four (4) Text files into four
Describe the role of databases and database management systems in managing organizational data and information. Recognize the historical development of database management sys
Draw a deperldency diagram to show the functional dependencies that exist in this relation - Decompose the Home Library relation into a set IMF relations and draw a dependenc
What is the difference Data-mining and Data Warehouses? How does data mining works? What technological infrastructure is required? Design a star schema for this problem with d
Describe how an ERD can be taken as a logical representation, and implemented into a physical representation in a database. Find and explain some more advanced SQL queries tha
Give a primary key for each relation. Are there any relations for which there is an alternate candidate key which you have not chosen as the primary key? Why or why not?
Each query is worth 2 marks. These tables exist in sphinx and are owned by the user dtoohey. You may, if you wish, create your own copies of the tables under your own accoun
A controller action is taking 10 seconds to run. Most of the time is being spent in a view which is a large file.(1000 lines). How will you go about debugging the speed issu