Relational Database Management Systems
for Epidemiologists

UC Berkeley Center for Infectious Disease Preparedness



[Download PDF] | [Go to Home Page] | [Go to Courses Page]


Disclaimer:

All data files (except for the oswego dataset) were created for the exercises in our courses. All personal information referred to in the data are fictitious and are not intended to refer to any person living or dead. Any such reference is coincidental and unintentional. The data were created to mimic real world datasets that one may encounter in an outbreak situation in order to illustrate and highlight the use of the course material.


These materials are a work in progress. If you have any questions about these materials or note any errors in the content, please contact:


Wayne Enanoria, PhD, MPH
Center for Infectious Disease Preparedness
University of California at Berkeley
1918 University Avenue, 4th Floor
Berkeley, CA 94720
Phone: (510) 643-4934
Email:
enanoria@berkeley.edu


Relational Database Management Systems



Topic

Exercise

Data

Starting the Process [PDF] [OpenOffice.org]

Exercise 1 [PDF] [OpenOffice.org]

SARS forms [PDF]

(last accessed 07.20.04 from CDC)

none

Entity-Relationship Diagrams [PDF] [OpenOffice.org]

Exercise 2 [PDF] [OpenOffice.org]

none

Normalization [PDF] [OpenOffice.org]

Exercise 3 [PDF] [OpenOffice.org]

none

Setting up a database in MS Access [PDF] [OpenOffice.org]

Exercise 4 [PDF] [OpenOffice.org]

none

SQL Part I: Retrieving data from a table [PDF] [OpenOffice.org]

Exercise 5 [PDF] [OpenOffice.org]

Exercise 5 Answers [PDF] [OpenOffice.org]

sarsdbase.mdb

SQL Part II: Summarizing and grouping data [PDF] [OpenOffice.org]

Joins in Action [PDF] [OpenOffice.org]

Exercise 6 [PDF] [OpenOffice.org]

Exercise 6 Answers [PDF] [OpenOffice.org]

database_joins.mdb

sarsdbase2.mdb

SQL Part III: Subqueries [PDF] [OpenOffice.org]

Exercise 7 [PDF] [OpenOffice.org]

Exercise 7 Answers (given in the exercise)

database_subqueries.mdb


SQL Part IV: Table/row modifications [PDF] [OpenOffice.org]

Exercise 8 [PDF] [OpenOffice.org]

Exercise 8 Answers [PDF] [OpenOffice.org]

sarsdbase2.mdb


Open Database Connectivity [PDF] [OpenOffice.org]

Exercise 9 [PDF] [OpenOffice.org]

Download oswego dataset.

Generating Reports [PDF] [OpenOffice.org]

Exercise 10 [PDF] [OpenOffice.org]

laboratory.mdb



Additional Documents:

  1. Field Data Types [doc]

  2. PROC SQL Example in SAS (courtesy of Jean Tsu-Ying Kuo and Hepei Chen, graduates of the Master's Program in Biostatistics)



Basic Field Epidemiology using Epi Info



Topic

Exercise

Data

Creating Data Entry Screens [PPT]

Workshop I [PDF]

none

Creating Check Codes [PPT]

Entering and Editing Records [PPT]

Workshop II Description [doc]

Workshop II Data Forms [PDF]

sarswkshop2.MDB

Descriptive Epidemiology and Simple Analysis [PPT]

Creating Variables, Manipulating Data and Working with Output [PPT]


Workshop III [doc]

case1.txt

case2.txt

contact1.txt

contact2.txt

Data Management [PPT]

Generating Reports [PPT]

none

none

Additional Documents:

  1. Epi Info Step-By-Step Guide [PDF]

  2. SARS Database: Behind the Scenes [PDF]

  3. Epi Info Resources [doc]



This page was created on 6 September 2004.