neu - ldavolio2

HI G220 - "Database Design, Access, Modeling, & Security"

Not an official Northeastern University website.

News

3/30/08 - Final Project Part 2 (Inserts & Queries) Posted Below

Both scenarios are in the same document. Download and follow the instructions. Due dates - April 15th by 6pm. Submit electronically.

Assignments

HI G220 Assignment 1 "Accessing the CCS CGI Server's MySQL using SSH." To be completed prior to Class 2. Value: 10 pts.

HI G220 Assignment 2 "Creating a simple relational DB." To be completed prior to Class 3. Value: 10 pts.

HI G220 Assignment 3 "Single table queries." To be completed prior to Class 4. Value: 10 pts.

HI G220 Assignment4 "Joins & SQL Review." To be completed prior to Class 5. Value: 20 pts.

HW4-ScreenShots.pdf (for complex problems)

HI G220 Assignment5 "Using an ERD Tool." To be completed prior to Class 6. Value: 10 pts.

Class Materials

Class 2:

Class 3:

Query Browser reacts differently to word docs versus pdfs, depending on whether you're on a Mac or PC. If you are using a Windows machine, download and use the .doc syntax for your assignment. For Mac, use the pdf.

Class 4:

TeachingGuide-Class4.doc

Class 5:

Class 6:

Class 7:

Class 8:

TeachingGuideClass8.doc

Final Project Part 1 - ER Models

Class 10:

Class 11:

Final Project Part 2 - Inserts & Queries. Both scenarios are listed in the document below.

FinalProjectPart2-InsertsAndQueries-.doc

Supplemental Reading Downloads
Week 1:

IOM's To Err is Human, Executive Summary ToErrIsHuman-ExecSummary.pdf

Week 10:

Murphy et al., Visual interface for clinical data warehouse AVisualQueryInterfaceForCohortIdenti.pdf

Ewen et al., Building the case for a clinical data warehouse (sorry for the quality of the doc, but if you can struggle through it, the material is still extremely relevant) BuildingTheCaseForClinicalDataWareho.pdf

Week 12: