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 "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 MyResearch and REDCap account from UCSF Academic Research Systems (ARS).  We will submit the initial account request for all registered students in EPI 218. You should receive an email from ARS asking you to fill out an online attestation form in order to activate your MyResearch and REDCap account.  See the "Prospectus" memo below.

    Faculty:  Michael Kohn

    Location:      Mission Hall 1400

    • Prospectus:

    • Welcome to Database Management for Clinical Research 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/16/2015.

       

    • Final Project File