Weekly Schedule
Schedule subject to change
Links are in blue.
Weekly preparation activities will be found on Canvas assignments along with any other reading assignments.
Lab and homework links are found in Canvas. Unless otherwise specified, all reading is from Ullman. Online readings will be linked to the schedule.
Lab: All lab classes will meet in ISAT/CS 143. All other classes will be held in our classroom, ISAT/CS 243
PD: Refers to project deliverables. See more detailed writeup in Canvas.
Quizzes: Open book, open note. Found on Canvas.
| Week |
Weekly theme |
|
Class topic |
Reading support - due before class |
Assignment Due |
Wk 1
Jan 14 |
Introduction to databases and DBMS |
T |
Introduction to databases and this class:
|
Chapter 1 (read after the fact) |
Incoming survey |
| Th |
History of databases and DBMS
|
9.1, 9.2 |
|
Wk 2
Jan 21 |
Relational database models |
T |
Snow Day - No class |
|
Quiz 1: 8am
|
| Th-Lab |
Introducing the teams
Individual - Team
An introduction to the Relational Model and PostgreSQL (And the SQL language)
Lab 1: A brief introduction to SQL(SELECT, INSERT, UPDATE, DELETE) |
2.3.1, 2.3.2, 2.3.3
6.1, 6.5 |
PD 1: Jan 27 (Monday) midnight |
Wk 3
Jan 29 |
Modelling continued |
T |
Relational model
ER Modelling
|
2.1.1-2.1.3, 2.2, 2.3
4.1-4.4 |
HW1: 8am
|
| Th-LAB |
Lab 2: Modelling tools - Visual Paradigm |
4.7 |
|
Wk 4
Feb 4 |
Relational alebra |
T-Lab |
Peer review
|
4.5, 4.8 |
Lab 2: 8am
Quiz 3: 8am
|
| Th |
Relational algebra
|
2.4-2.5
|
Updated proposal: Feb 6, 11:59pm
|
Wk 5
Feb 11 |
Aggregation |
T |
Assessment day, no class |
|
Lab 3: 8am (as homework-see Canvas)
Quiz 4: 8am |
| Th |
Snow day, no class :-( |
|
|
Wk 6
Feb 18 |
The normalization process |
T |
Bags and aggregation
Introduction to Subversion
notes
Lab 4: Joins and subqueries in SQL |
5.1-5.3
6.1, 6.2, 6.3 |
Quiz 5: 8am cancelled
|
| Th |
Functional dependency |
3.1, 3.2, 3.3 |
PD2: Feb 25 midnight |
Wk 7
Feb 25 |
Normalization continued |
T |
Normalization - Lecture |
3.4, 3.5, 3.6, 3.7 (supplemental - in Canvas)
|
Quiz 5: 8am
HW-4 due 8am |
| Th |
Lab 5: Maintaining integrity - Constraints in SQL |
7.1, 7.2, 7.3 |
|
Wk 8
Mar 4 |
Midterm 1 |
T |
Snow day, no class. |
|
Lab 5: 8am
Quiz 7: 8am |
| Th |
Midterm 1 |
See materials in Canvas |
|
| Spring Break - Enjoy the time off! |
Wk 9
Mar 18 |
JDBC - The application side (JSP) |
T |
Individual meetings with the instructor.
|
9.6, (supplemental - in Canvas) |
Quiz 8:8am
PD3 - March 19 midnight |
| Th |
Return exams
Team evaluations |
|
|
Wk 10
Mar 25 |
SQL Advanced |
T |
Indexes, views, functions (procedures) |
8.1-8.5
9.2,9.3 |
Qhiz 9 8am |
| Th |
Lab 6: Making the connection
Web application architecture |
|
|
Wk 11
Apr 1 |
Indexes and Security |
T |
Security |
|
Lab 6: 8amQuiz 11: 8am
|
| Th |
Lab 8: Security |
|
|
Wk 12
Apr 8 |
Advanced topics |
T |
Transactions |
|
Quiz 10: 8am |
| Th |
plpgsql
Recursion, User defined types |
9.3, 9.4,10.2, 10.4 |
PD4: April 1, 11:59pm
Lab 8: 8am
|
Wk 13
Apr 15 |
Other DBMS |
T |
MySQL/SQL Lite
xml |
10.2, 10.4 |
Quiz 11: 8am |
| Th |
Prototype demos |
supplemental - in Canvas |
PD 5: Prototype demos |
wk 14
Apr 22 |
Full text search |
T |
SQL Server and Oracle |
supplemental - in Canvas |
Quiz 12: 8am |
| Th |
Finalize project |
|
|
Wk 15
Apr 29 |
Project demos |
T |
Project demo |
|
PD6: In class - demo
Quiz 13: 8am |
| Th |
Final presentations |
|
|
Finals Week
May 5 |
Section 3: Tuesday - 5/6 - 8am - 10am |
|
|
|
|
|
Updated 01/10/2014 - NLH
