+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
How sales of individual items would be entered? How the database would store the data compared to the current spreadsheet method? How monitoring of inventory levels based on s
They also want to know if registration trends are different for female students compared to male students. Here is the schemaView in a new windowfor the operational database
ITECH 1006 - Database Management Systems-  Design and implement a relational database using a database management system and utilise a query language tools and techniques to o
Find an example of an actual data warehouse. For this example, explain the content, user access methods, purpose, and sources of data (what on-line transaction processing [O
Design a minimal relational database for Pieces Boutique. By minimal, it is meant that option to post a key into existing table because of either needed participation or a d
Customers Dunne an Olowski are included in the CUSTOMER table also in CUSTOMER_2 table. Explain How many records are returned when using the MINUS operator?
Propose an efficient data structure that may hold the tour operator's data using a normalization process. Describe each step of the process that will enable you to have a 2n
COMP 108 Introduction to Databases - Pulling it All Together - Dentist's Office. Step by Step Description: Use all of the naming conventions discussed in this course. Create t