Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Data Base 1: Hypertension

Objective: To determine whether or not the community self-management program is effective to promote health and reduce blood pressure level in patients with hypertension

Rationale In low-to-middle income country, hypertension is the leading risk factor of cardiovascular disease. Currently the prevalence of hypertension in upper middle income country, for example, China, is 25-30%. Effective community based strategies to promote health and reduce blood pressure level is critical to improve health status and prevent high incidence of chronic diseases.

Subjects Eligible subjects are patients with hypertension aged 35 and above. Eligible patients with hypertension in a rural District, Fangshan District, Beijing, were selected to participate in the intervention study. There were 300 people with hypertension participated in the intervention group. Control group data were not included in this data set.

Data 1. Health related data

a. SBP: Range score, 60-220 mm Hg
b. DBP: Range score, 30-120 mm Hg
c. Hypertension knowledge (assess patient's knowledge in healthy diet, exercise, health behaviour, salt intake, anger control, smoking, alcohol intake): Range score: 0-8
d. Smoking
e. Diet habit
f. Vegetable and Fruit intake
g. Exercise (walking and jogging)
h. Hypertension management method

2. Demographic data: age, gender, education, income.

Intervention program Self-management skills Self-management skills:

Medication, diet, exercise, emotional control.

Length of intervention: 6 months.

Measurements:

SBP and DBP, knowledge of hypertension risk factors were measured at baseline (2011 March)

1. Reasonable range of SBP: 60-220 mm Hg
2. Reasonable range of DBP: 30-120 mm Hg
3. Hypertension knowledge score range (assess patient's knowledge in healthy diet, exercise, health behaviour, salt intake, anger control, smoking, alcohol intake): 0-8
4. Smoking range score: 1-3
5. Diet habit range score: 1-4
6. Vegetable and Fruit intake: 1-4
7. Exercise: 1-4
8. Hypertension management method: 1-4

Demographic variables: age, gender, education, income.

The aims of the study are to:

1. Describe the characteristics of hypertension patients (age, gender, education and income).

2. Describe characteristics of outcome variables: SBP, DBP, knowledge of hypertension, health behaviour (smoking, diet, vegetable and fruit intake, and exercise), management methods.

Your research questions are:

1. What are the demographic characteristics of hypertension patients ?

2. What are the characteristics of patients in relation to their blood pressure level, knowledge of hypertension, health behaviour (smoking, diet, vegetable and fruit intake, and exercise) and management method in preintervention time?

1. Variables: you need to identify-

- Demographic data: age, gender, education, income
- Blood pressure: SBP, DBP
- Knowledge of hypertension
- Health behaviour (smoking, diet, vegetable and fruit intake, and exercise)
- Blood pressure management method

Variables/measurement type for each variable.

(You need to describe the type of variable, ie., specify whether they are dichotomous, nominal, ordinal, interval or ratio type for the variables)

2. Data management and data cleaning.

Please delete data are outside the range of the scores which were specified below:

1). Reasonable range of SBP: 60-220 mm Hg
2). Reasonable range of DBP: 30-120 mm Hg
3). Hypertension knowledge score range (assess patient's knowledge in healthy diet, exercise, health behaviour, salt intake, anger control, smoking, alcohol intake): 0-8
4). Smoking range score: 1-3
5). Diethabit range score: 1-4
6). VegetableandFruitintake: 1-4
7). Exercise: 1-4
8). Managementmethod: 1-4
9). Age: 35 and above

(REMEMBER THAT DATA CLEANING would be included as part of the Process in determining the quality of the data - Please check invalid values and duplication of the cases). Please record every action you will make and present the ID number and action you will take in a table (eg., deletion of invalid values and duplication of the cases). Please use table to list up three columns: ID number, problems, actions.

3. Descriptive Analysis: For each variable, choose the appropriate numerical statistical summary and or graphical summary for hypertension patients group,provide the results of statistical assumption (skewness and kurtosis figures) if the variables are ratio or interval data type.

a. Normality check.The distribution of the continuous variables need to be checked. This can be checked by using descriptive statistics analysis (checking skewness and kurtosis)(This is for you to answer research question only).

b. Conduct data analysis using SPSS and present data using publication format: please run descriptive analysis and then use either publication table presentation format or graph to present the results. Please justify the reason of your choice of data presentation method. You need to describe how you will present the data for each variable based on the statistical assumption check. The statistical assumption is normality check if the variables are interval or ratio data. If the variable does not show the normal distribution pattern, you need to present data using median and range (min, max). Please do not do any comparison analysis or association analysis for this assignment as you are only assessed for your understanding of descriptive analysis.

c. Interpretation of the results:Finally you need to describe the descriptive analysis results for each variable and explain what the results mean to audience using descriptive analysis method.

Database 2: Diabetes: Calculation Risk, Rate based on the given database

200 diabetes patients undergoing treatment were followed up in several large medical centers and observe how many patients developed cardiovascular disease over the 50 weeks. At baseline stage, none of the patients had cardiovascular disease.

Risk (incidence) and rates of cardiovascular disease with and without medication and lifestyle intervention (50 weeks intervention for intervention group, and no medication for control group)

Question 1: What is the risk (Incidence) of cardiovascular disease after 50 weeks intervention in both intervention and control group?

Question 2: What is the rate of cardiovascular disease (based on the person-weeks) after 50 weeks intervention in intervention and control group? (Calculate person-weeks of observation first, then answer the question).

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M91954820

Have any Question?


Related Questions in DBMS

Sql transactions exercisesconsider table itemnameprice

SQL Transactions Exercises Consider table Item(name,price) where name is a key, and the following two concurrent transactions. T1: Begin Transaction; Update Item Set price = 2*price Where name = 'pencil'; Insert Into Ite ...

A schools office of the registrar maintains data about the

A School's office of the registrar maintains data about the following entities: a) courses (including course number, title, credits, syllabus and prerequisites), b) course offerings (including course number, year, semest ...

Question as explained throughout this course entity

Question: As explained throughout this course, entity relationship modeling is a critical element of database design. If the database is not properly modeled, it is unlikely that the database will be properly developed. ...

This is a starting out with visual basic programming

This is a starting out with visual basic programming problem, meaning its a basic programming nothing advanced. Question: Add a linq statement to the combo box text-changed event to dispaly the city field of the selected ...

Instructionsfor decades relational databases remained

Instructions For decades, relational databases remained essentially unchanged; data was segmented into specific chunks for columns, slots, and repositories, also called structured data. However, in this Internet of Thing ...

Question lab 1 creating a database designthis assignment

Question: Lab 1: Creating a Database Design This assignment contains two (2) Sections: Database Design Diagram and Design Summary. You must submit both sections as separate files in order to complete this assignment. Not ...

Q1 given the following file for assignment workercom

Q1. Given the following file for assignment worker.com, identify data anomalies that must be removed before data can be loaded in data warehouse. Worker_assignment ← -----------------on course web site File is available ...

Data model development and implementationpurpose of the

Data model development and implementation Purpose of the assessment (with ULO Mapping) The purpose of this assignment is to develop data models and map Database System into a standard development environment to gain unde ...

Project outline and requirements provide a brief

Project Outline and Requirements Provide a brief description of the organization (can be hypothetical) that will be used as the basis for the projects in the course. Include company size, location(s), and other pertinent ...

Select from e d pwhere edeptddept and dcitypcity and

Select * From E, D, P WHERE E.dept=D.dept AND D.city=P.city AND D.budget>1M AND P.priority=A; Assuming relations have the same size and uniform distributions, what is the best plan with Nested Loop joins only? Write it a ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As