Section outline

  • Wrap-Up of Relational Database Concepts ; Data Management Plan

    Faculty:  Josh Senyak

    • Lecture Slides:

    • Lecture 6 - Wrap-up of Relational Database Concepts File
    • Database management plan File

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

    • Lecture 6 - Part A: Wrap-up of Relational Database Concepts Media Resource
      Not available unless: You belong to Registered Students Only
    • Lecture 6 - Part B: Final Project: Database Management Plan Media Resource
      Not available unless: You belong to Registered Students Only

    • Optional Reading:

    • Newman et al. NEJM. Hyperbili Outcomes File

    • Assignment:

    • Assignment 6 Instructions File
    • IJSDatabaseComplete.accdb File
    • Assignment 6 Quiz

    • Assignment Due Date:  Assignment 6 is due at 23:59 on 9/2/21.  You will need to complete the Assignment 6 quiz.  See the Assignment 6 instructions for details.

    • Optional Assignment 7 Using R:

    • Assignment 7 Instructions (Optional, Extra Credit, Using R) File

      In this optional, extra credit assignment you will run some simple queries and analysis using R, a powerful and flexible statistical analysis package. For the sake of familiarity, we will repeat some of the same analysis that we did in Assignment 6. Have your Assignment 6 answers on hand for comparison.  This assignment includes 2 quiz questions.  The quiz is worth 5 extra credit points (25% of a regular assignment, extra credit).


    • Assignment 7 Quiz (Optional Extra Credit Using R)

      Assignment 7 repeats many of the tasks in Assignment 6 using R instead of Access and Stata.  If you do it, you will learn a bit of R and see that SQL statements can be run from within R.  The Assignment 7 quiz is completely optional and worth up to 5 extra crdit points.