· Home
 · Overall Schedule 
 · Courses
 · Programs
 · Rosters
 · Career Awards
Syllabus

Database Management Systems for Clinical Research EPI218

Date/Time Activity Topic/Content Faculty Locations
Tues 1/5/2010
8:45 AM-10:15 AM		Lecture

Database Management Systems (DBMS) for Clinical Research

The concept of a multi-table relational database and data normalization. Rows as entities, columns as attributes. Primary and foreign keys. One-to-Many, Many-to-Many, and One-to-One relationships. The basic tables in a clinical research study: subjects, measurements, and examiners.

Prospectus Files: Epi218WelcomeMemo.doc (27 KB)

Required Reading:

  1. Chapter 16 -- "Data Management" in Designing Clinical Research (Hulley et al), 3rd Edition

Optional Reading:

  1. Relational Databases for Clinical Research

Note/Slide Files: DBMSLecture1-5-10_RelationalDatabases.ppt (1298 KB)

Assignment:
Work through the Chapter 16 ("Data Management") Exercises in Designing Clinical Research (Hulley et al), 3rd Edition.

These are not to turn in (especially since the answers are in the book).

Assignment Due Date: To be discussed at first lecture on 1/5/2010 -- not to be turned in.

Final Exam Files: Final Project.doc (34 KB)

Final Exam Due Date: Due 3/9/2010, send to ucsfdbclass@yahoo.com
Note: Changed from 2/16/2010.

M KohnCB 6702
Tues 1/12/2010
8:45 AM-10:15 AM		Lab

Tables and Relationships, Data Entry Forms

Creating a table in design or “data dictionary” view. Field names, types, and descriptions; validation rules, primary and foreign keys, lookup tables, and relationships between tables. Creating data entry forms/subforms.

Required Reading:

  1. Learn Access Video (Username and Password provided in class)

Assignment Files: Epi 218 Lab 1 Instructions for Access 2003 or prior versions (Not Access 2007).doc (374 KB) Epi 218 Lab1 Instructions for Access 2007.doc (367 KB)

Assignment Due Date: Email the completed Access mdb file, LASTNAMElab1.mdb, to ucsfdbclass@yahoo.com by 1/18/2009 at 5 pm.

M KohnCB 6704
Tues 1/19/2010
8:45 AM-10:15 AM		Lab

Queries and Reports, Importing Data

Filtering by form. Writing select queries and reports for monitoring study progress. Importing data and appending and updating records.

Prospectus Files: Epi218PostLab1Memo.doc (31 KB)

Assignment Files: Epi 218 Lab 2 Instructions for Access 2003 or prior.doc (58 KB) Epi 218 Lab 2 Instructions for Access 2007.doc (59 KB) Epi 218 Lab 2 Instructions for QuesGen.doc (117 KB) Epi 218 QuesGen Usernames.doc (86 KB)

Assignment Due Date: Email the two rtf files, LASTNAMECountsByRace1.rtf , and LASTNAMECountsByRace2.rtf to ucsfdbclass@yahoo.com by 1/25/2010.

Dataset Files: Baby2007.xls (44 KB) InfantJaundice2010.zip (704 KB)

M KohnCB 6704
Tues 1/26/2010
8:45 AM-10:15 AM		Lab

Queries and Exporting Data

More sophisticated queries, including totals (“group by”) queries. Exporting data for statistical analysis.

Prospectus Files: Epi218PostLab2Memo.doc (33 KB) Epi218REDCapMemo.doc (32 KB)

Optional Reading:

  1. Bland, Altman --Measurement Error

Assignment:
Using the Infant Jaundice Database determine if neonatal jaundice was associated with the five-year neuropsychological (IQ) scores and create a table, figure, or paragraph, appropriate for the "Results" section of a manuscript summarizing the association.

Extra Credit: Write a sentence or two for the "Methods" or “Results” section on inter-rater reliability.

Assignment Files: Epi 218 Lab 3 Instructions for Access 2003.doc (40 KB) Epi 218 Lab 3 Instructions for Access 2007.doc (43 KB) Epi 218 Lab 3 Instructions for QuesGen.doc (88 KB)

Assignment Due Date: Please email your assignment as an attachment (Word or Excel files only) to ucsfdbclass@yahoo.com by 2/1/2010.

M KohnCB 6704
Tues 2/2/2010
8:45 AM-10:15 AM		Lecture

Review of Assignment 3, Loose Ends, Web-Based Research Data Management Platforms

Assignment 3 Review
Loose Ends
HIPAA and CFR 21 Part 11
Web-based Data Entry (SurveyMonkey, REDCap, and QuesGen)

Prospectus Files: REDCap and MyResearch Attestation Form.doc (71 KB) REDCap User Account Request Form-Education.xls (19 KB)

Note/Slide Files: DBMSLecture02-02-10ReviewOfAssignment3LooseEnds.ppt (380 KB)

M KohnCB 6702
Tues 2/9/2010
8:45 AM-10:15 AM		Lecture

Research Study Database Demonstrations

Research database demonstrations and guidance for building a database for your own research study. Where to get help and how much it will cost.

Prospectus Files: Example Assignment 4B CT Syndesmosis.doc (191 KB)

Note/Slide Files: DatabaseDemonstrations02-9-2010forPosting.ppt (53 KB)

Assignment Files: Epi218FinalProjectMemo.doc (33 KB) Final Project (Assignment 4).doc (34 KB)

Assignment Answer Files: ExampleAssignment4B VA ICD Database.doc (153 KB) ExampleAssignment4B_AnalCytologyStudyDatabase.doc (39 KB) ExampleAssignment4B_CoronaryCTAngiogramInStroke.doc (413 KB) ExampleAssignment4B_ImmediateAim.doc (28 KB)

Dataset Files: ExampleAssignment4A_AnalCytologyStudyDatabase.zip (111 KB) ExampleAssignment4A_CTSyndesmosisDatabase.zip (3656 KB)

Final Exam Due Date: Due 3/09/10, send to ucsfdbclass@yahoo.com
Note: Changed from 2/16/2010

M KohnCB 6702