Section outline

  • Lecture: Tables and relationships, normalization, data types, and data dictionaries.

    Going from data collection forms to data tables in which rows correspond to records/entities and columns correspond to fields/attributes. The concept of a data dictionary or so-called "meta-data". Multi-table relational database and data normalization. Primary and foreign keys. One-to-Many, Many-to-Many, and One-to-One relationships.

    IMPORTANT: The course labs require a Department of Epidemiology and Biostatistics (DEB) Terminal Server account and a UCSF REDCap account. See the "Prospectus" memo below.

    Faculty:  Michael Kohn

    Location:      China Basin 6702

    • Prospectus:

    • Welcome to Epi 218 File
    • Lecture 1 Powerpoint File

    • Session Audio/Video Recording (Access restricted to registered students):

    • Required Reading:

      Chapter 16 -- "Data Management" in Designing Clinical Research (Hulley et al), 4th Edition

    • Assignment:

      Work through the Chapter 16 ("Data Management") Exercises starting on page 301 of Designing Clinical Research (Hulley et al), 4th Edition.

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

       

    • Final Project Due Date:  Early Warning - EPI 218 Final Project is due by midnight on 9/17/2014.

       

    • Final Project File