Tentative Calendar
| Week | Topic |
Homework Assignments
|
Reading |
| Jan 8 | Administrivia; Unix Accounts; Intoduction to Databases; File-Based System; DBMS Functions and Architecture; Relational Databases |
1.1-1.3, 2.4, 2.6, 3.2 |
|
| Jan 15 |
RELATIONAL DBs: Foreign Key; Relational Integrity; SQL: Simple Queries, DISTINCT, Calculated Fields, WHERE clause |
3.2, 3.3, 5.3.1 |
|
| Jan 22 |
SQL: Sorting Results, SQL Aggregate Functions, Grouping Results Lab Session |
1st assignment out |
5.3.2, 5.3.3, 5.3.4 |
| Jan 29 | SQL: Multi-table Queries (Inner Join, Outer Join) |
Comments on the 1st assignment Update the database |
5.3.7 |
| Feb 5 |
SQL: Subqueries | 1st assignment due How to submit the assignment |
5.3.5, 5.3.6 |
| Feb 12 |
SQL: Subqueries (EXISTS, NOT EXISTS), Division SQL: Combining Result Tables |
2nd assignment out |
5.3.8, 5.3.9 |
| Feb 19 |
SQL: Database Updates, Review - More examples |
Review questions |
5.3.10 |
| Feb 26 |
SQL: Data Definition - Create&Alter Tables |
2nd assignment due (before the class) The output of the solution to the 2nd assignment |
6 |
| Mar 4 |
Spring Brake: No class |
||
| Mar 11 |
Midterm Exam |
1st Assignment Solutions 2nd assignment solutions |
Open book; Open notes |
| Mar 18 |
SQL: Data Definition - Create&Alter Tables |
DreamHome2.sql |
6 |
| Mar 25 |
Entity-Relationship modeling |
11 |
|
| Apr 1 |
Entity-Relationship modeling |
3rd assignment out |
11 |
| Apr 8 |
TBA |
||
| Apr 15 |
Biological DataBases |
3rd assignment due 3rd assignment solutions |
|
| Apr 22 |
Final Exam |
Open book; Open notes |