Section outline

  • Lecture: More on normalized relational databases

    Faculty:  Michael Kohn

    • Lecture Slides:

    • Lecture 5 File

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

    • Lecture 5 Segment 1 -- Front End vs Back End, Splitting (22:21) Media Resource
      Not available unless: You belong to Registered Students Only
    • Lecture 5 Segment 2 -- Advice About Final Project (10:00) Media Resource
      Not available unless: You belong to Registered Students Only
    • Lecture 5 Segment 3 -- Relational Model, Normalization (10:32) Media Resource
      Not available unless: You belong to Registered Students Only
    • Lecture 5 -- REDCap Data Entry Audits (3:11) Media Resource
      Not available unless: You belong to Registered Students Only

    • Resources:

    • Assignment:

    • Assignment 5 Instructions (slightly revised 8/24/20) File
    • InfantJaundiceStudyLab5.accdb File

      8/30/2020 -- Compacted to make it slightly smaller.  Some of the (fictional) names changed to eliminate duplicates.  No changes will affect answers to Assignment 5.

    • Baby2012-13.xlsx File
      8/30/2020 -- Updates some of the fictional names and addresses.  No affect on answers to Assignment 5.
    • Assignment 5 Quiz

    • Assignment Due Date:  By 11:59pm on 9/3/20.

    • Datasets: