Please Note:
- Classes in bold black are the core database classes; classes in purple are programming classes; classes in green are in-class discussions.
- Lab with * denotes this lab is required.
- All homework/reports are due at midnight (11:59PM). All lab assignments are due before or in the lab.
- Schedule is subject to change.
Week | Date | Lecture | Notes | Assignments | Project |
1 | 8/24/2015 | Course Intro &Intro to Database (Ch. 1) | 2015-fall-W1C1classintro W1C1-1-introDB |
W1C1-Assignment-1 | |
8/26/2015 | HTML basics (P1) | W1C2-p1-html |
W1C2-Assign-P1-html | ||
2 | 8/31/2015 | Relational Model I (Ch.2) | W2C1-2-relationalModel-1 | Assignment 1 Due | |
9/2/2015 | Relational Model II (Ch.2) | W2C2-2-relationalModel-2 | Assignment-2 Assignment-1-P1: html due |
||
3 | 9/9/2015 | PHP basics (P2) | W3C2-p2-php-basics | ||
4 | 9/14/2015 | IF/ELSE and LOOP (P3) | W4C1-p3-if-loop | Homework Assign 2 Due
Assign P2 |
|
9/16/2015 | Project idea and group forming | Group project-updated v2 | |||
5 | 9/21/2015 | SQL I (Ch. 3) | Homework Assign 3-1 | W5C1-3-sql-1 | |
9/23/2015 | SQL II (Ch. 3) | W5C2-3-sql-2 | Report 1 Due | ||
6 | 9/28/2015 | SQL III (Ch. 3) | W6C1-3-sql-3 Homework Assign 3-2Assignment-3-2Assignment-3-2-SQL-scriptsand Homework Assign 3-1 due |
||
9/30/2015 | Practice Session: P1-P3 and Assign P1&P2 | Assign P2 due | |||
7 | 10/05/2015 | Midterm Review and Project Report 1 Discussion | W7C1-MidtermReview | ||
10/07/2015 | Midterm: in class | ||||
8 | 10/12/2015 | ER Diagram 1 | W8C1-4-ER-1 | ||
10/14/2015 | ER Diagram 2 | W8C2-4-ER-2 | Assignment-4 | Report 2: E-R Model | |
9 | 10/19/2015 | Project Report 2 Discussion: E-R Model | |||
10/21/2015 | PHP array, HTML table (P4) and HTML form (P5) | W9C2-p4-array-table | Assignment 4 due | Project Report 2 due | |
10 | 10/26/2015 | Database Design I (Ch.5) | W10C1-5-database-1 | ||
10/28/2015 | Database Design II (Ch.5) | W10C2-5-database-2 | W10C2-Assignment-5
|
Report 3: Database Design | |
11 | 11/02/2015 | Project Report 3 Discussion and HTML form (P5) | W11C1-p5-form | Assign P4 (Extra Credit) | |
11/04/2015 | PHP and SQL Server: Connect(P6) | W11C2-p6-connect |
Assign P3 due |
||
12 | 11/09/2015 | PHP and SQL Query (P7) | cases.zip | Homework Assign 5 Due
Assign P4 due (Extra Credit) |
Report 3 Due |
11/11/2015 | Project Report 4 Discussion | Report 5 | |||
13 | 11/16/2015 | Project Time | W13C1-p8-accessControl | Report 4 Due | |
11/18/2015 | Project Report 5 Discussion | ||||
14 | 11/23/2015 | Thanks Giving: No class | |||
11/25/2015 | Thanks Giving: No class | Report 5 Due 11/29/2015 The Sunday night | |||
15 | 11/30/2015 | Project Time | W15C1 | ||
12/02/2015 | Project Presentation | ||||
16 | 12/07/2015 | Best Team Announce and Final Exam Review | W16C1-FinalReview | Final Report Due
Video upload |
|
12/09/2015 | Final Q&A | ||||
17 | 12/18/2015 | Final Exam 8:00AM Friday in final week |
Recent Comments