+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
What kinds of databases track relationships? Give a brief description and the advantages of at least three. How does a query language like SQL work? Give brief descriptions of
Use the Internet or the Strayer Library to research one (1) concept in information systems that you have studied in this course. You may select a topic of your choice or you
Assignment: Creating the Babbage Bookkeeping Database. Problem: Babbage Book keeping is a local company that provides bookkeeping services to several small businesses in the
Find or create an example of a violation of a normal form that you would allow, tell why you are allowing the violation and explain how you would protect against anomalies.
Find the total number of orders submitted in 2015. List all distinct customer IDs (O_C_ID) who submitted the largest number of orders in 2014. Find the total number if orders
Show all attributes and include relationship and connectivity. Convert all M:N relationships into entities. You are to use Crow's Foot notation showing all attributes for each
Identifying risk in an organization and the environment in which it operates is the first step in approaching a potential audit and designing an effective audit program.
Write the application for university admissions office. Prompt user for a student's High School Grade Point and an admission test score.