Help: Instructor Mirela Damian, Mendel 167A. Office hours are on T(2:30pm - 4:00pm) and W(3:30pm - 5:30pm).
Teaching Assistants are available to help you with programming and basic system issues. Check out their schedule.
       
Assignment Link Posted Due Date
       
A #1: Database Article Aug. 26
A #2: Relationships with Attributes Sep. 5
A #3: Case Study: Mountain View Community Hospital Sep. 10
A #4: A Closer look at MVCH Sep. 17
A #5: Creating a Database in SQL Oct. 22
A #6: SQL Queries (handout) Oct. 29
       
       
Project Link Posted Due Date
       
Phase #1: Project Description (instructions, sample deliverable) Sep. 16
Phase #2: E-R Model (instructions, sample deliverable) Sep. 16
Phase #3: Relational Model (instructions, sample deliverable) Oct 18
Phase #4: DDL Schema and DML Population (instructions, sample deliverable) Oct 18
Phase #5: DML Queries (instructions, sample deliverable) Nov. 11
Phase #6: Web-Enabled Dynamic Queries (instructions) Dec. 3
       
 
Student Team #1: Andrew and Kamel. Online Movie Rentals Poster #1
Projects Team #2: Anthony and Ryan Coote. QVC Poster #2
  Team #3: Caroline, John and Kelly Gremban. Animal Shelter
  Team #4: Guillaume. Turcotte Hockey School
  Team #5: Harrison and Steve. McafeeGrills.com
  Team #6: Jill and Kristin. NYC Bakery Poster #6
  Team #7: Joe Weber and Kofi. Schedulr++
  Team #8: Josh, Logan and Tom Nova Pick Up Poster #8
  Team #9: Ken. Ken's Library Poster #9
  Team #10: Nick Mazzeo and Ryan March. DataBEASTS Poster #10
  Team #11: Ryan Kang. Dizzyland
  Team #12: Nick Maffatone and Samantha. Grow Flower Farm Poster #12
  Team #13: Joe Quadrino. Reddit Comment Analyzer Poster #13
  Team #14: Kyle. Pal Che Tang Soo Do
 
 
ASP.NET (Optional)
 
Tutorial #1 pdf tutorial, download Sep. 3
Tutorial #2 pdf tutorial, download Sep. 16