Schedule Spring 2016

 [Week] Day Chapter Topic Class Exercise Assignment Info
[1] Tue, Jan 12 or Wed, Jan 13 Introduction Assignment 1 – Querying Large Files
[1] Thu, Jan 14 or Fri, Jan 15 VIDEO Ch. 1
Quiz 1: 1/13-1/18
Worlds of Database Systems [Module] Exercise 1
[2] Tue, Jan 19 or Wed, Jan 20 VIDEO Ch. 2
Quiz 2: 1/18-1/23
The relational model of data [Module] Exercise 2
[2] Thu, Jan 21 or Fri, Jan 22 VIDEO Ch. 5
Quiz 3: 1/20-1/25
Algebraic and logical query languages [Module] Exercise 3 Use MySQL with PhpMyAdmin in cPanel instead of Oracle. Use this data to populate your tables.
[3] Tue, Jan 26 or Wed, Jan 27 Ch. 5
Quiz 4: 1/25-1/30
Algebraic and logical query languages [Module] Exercise 4 Assignment 2 – SQL Queries (PCE)
• Click for Instructional Video
Alternative 2 – SQL Queries (WPC)
• Click for Instructional Video
Use can use PhpMyAdmin in cPanel instead of Oracle if you want
[3] Thu, Jan 28 or Fri, Jan 29 VIDEO Assignment 1 and How to hand in class exercises
[4] Tue, Feb 2 or Wed, Feb 3 VIDEO Ch. 5
Quiz 5: 2/1-2/6
SQL [Module] Exercise 5
[4] Thu, Feb 4 or Fri, Feb 5 VIDEO Ch. 6
Quiz 6: 2/3-2/8
SQL [Module] Exercise 6 Assignment 1 Due
[5] Tue, Feb 9 or Wed, Feb 10 Ch. 6
Quiz 7: 2/8-2/13
SQL [Module] Exercise 7
[5] Thu, Feb 11 or Fri, Feb 12 VIDEO Ch. 9
Quiz 8: 2/10-2/15
SQL in a server environment [Module] Exercise 8
[6] Tue, Feb 16 or Wed, Feb 17 VIDEO Ch. 9
Quiz 9: 2/15-2/20
SQL in a server environment [Module] Exercise 9 Assignment 3 – Web Application
Use can use your web server and implement all in PHP or PHP with JavaScript/AJAX.
[7] Thu, Feb 18 or Fri, Feb 19 VIDEO Assignment 2 Due
[8] Tue, Feb 23 or Wed, Feb 24 VIDEO Ch. 9
Quiz 10: 2/22-2/27
SQL in a server environment [Module] Final Project
[6] Thu, Feb 25 or Fri, Feb 26 VIDEO Ch. 1, 2, 5, 6 Midterm Review Midterm Notes
[7] Tue, Mar 1 or Wed, Mar 2 Midterm Open book, open notes, no computers or cellphones
[8] Thu, Mar 3 or Fri, Mar 4 Ch. 4
Quiz 11: 3/2-3/7
High-level database models [Module] Exercise 10 Alternative Slides
[9] Tue, Mar 8 or Wed, Mar 9 Ch. 3
Quiz 12: 3/7-3/12
Design theory for relational databases [Module] Exercise 11 Alternative Slides: 1 and 2. Normal Forms Summary.
[9] Thu, Mar 10 or Fri, Mar 11 Ch. 3
Quiz 13: 3/9-3/14
Design theory for relational databases [Module] Exercise 12 Assignment 4 – Entity Relationship Diagrams
[10] Tue, Mar 15 or Wed, Mar 16 VIDEO Ch. 3
Quiz 14: 3/14-3/19
Design theory for relational databases [Module] Exercise 13
[10] Thu, Mar 17 or Fri, Mar 18 Ch. 7, 8
Quiz 15: 3/16-3/21
Constraints, triggers, view, indexes [Module] Exercise 14 MySQL Procedures, Triggers, Events video.
[] Tue, Mar 22 or Wed, Mar 23 Spring Break
[] Thu, Mar 24 or Fri, Mar 25 Spring Break
[11] Tue, Mar 29 or Wed, Mar 30 Ch. 17.1, 18.0-2
Quiz 16: 3/28-4/2
Transaction processing [Module] Exercise 15
[11] Thu, Mar 31 or Fri, Apr 1 Ch. 17.1, 18.0-2
Quiz 17: 3/30-4/4
Transaction processing [Module] Exercise 15 Assignment 3 Due
[12] Tue, Apr 5 or Wed, Apr 6 Ch. 17.1, 18.0-2 Transaction processing [Module] Exercise 16
[12] Thu, Apr 7 or Fri, Apr 8 Ch. 13.0-2, 14.0-2
Quiz 18: 4/6-4/11
Storage and indexing [Module] Exercise 17
[13] Tue, Apr 12 or Wed, Apr 13 Ch. 13.0-2, 14.0-2
Quiz 19: 4/11-4/16
Storage and indexing [Module] Exercise 18
[13] Thu, Apr 14 or Fri, Apr 15 Ch. 16.1, 15.0-3
Quiz 20: 4/13-4/18
Query processing [Module] Exercise 19
[14] Tue, Apr 19 or Wed, Apr 20 VIDEO Ch. 11, 12
Quiz 21: 4/18-4/23
Semi-structured data and XML [Module] Exercise 20 Demonstrated how to create Triggers in MySQL using PhpMyAdmin.
[14] Thu, Apr 21 or Fri, Apr 22 VIDEO Demonstrated how to create Stored Procedures and Transactions in MySQL using PhpMyAdmin.
[15] Tue, Apr 26 or Wed, Apr 27 Final Exam Review Assignment 4 Due
[15] Thu, Apr 28 or Fri, Apr 29
[16] Tue, May 3 or Wed, May 4 Project Fun idea for a project.

  1. Make this.
  2. Make a check-in game out of it.