Tentative Weekly Schedule
Schedule subject to change
Links are in blue.
Normally, I will not highlight assignments. It is up to you to be notified if an assignment is added and to monitor the class calendar. Expect homework of some kind for each class period.
Reading assignments are due before the corresponding class and will be out
of the Ullman book unless otherwise specified.
|
Week
|
Weekly Theme | Tuesday | Thursday | Reading references |
1 Jan-8 |
Beginning terminology, what is a database, history | Introduction to the class |
History of databases and the relational model | Tu: Chapter 1
|
|
2
Jan-15 |
Modelling-The relational model | The Relational Model Introduction to ER Diagramming
|
E/R Diagrams / Diagramming Tools (Lab: ER Diagramming) Meet in the lab |
Tu: Chapter 2.1, 2.2 & Chapter 4.1 - 4.2 Th: Chapter 4.2- 4.6 |
|
3 Jan-22 |
Relational algebra |
Weak entity sets Relational algebra |
Intro to the PROJECT (Lab: Web front ends-intro to HTML and php) |
Tu: Chapter 2.4-2.5 |
|
4 Jan-29 |
Intro to SQL | What's a Bag? | Intro to SQL (Lab: Intro to SQL) | Tu: Chapter 5.1-5.2 Chapter 6.1--6.4 Th: Chapter 7.1--7.2 |
|
5
Feb-5 |
More SQL | Constraints (Lab: SQL-DDL)
|
|
Tu: Chapter 6.5-6.6 |
|
6 Feb-12 |
Database design |
 Assessment Day, no class |
|
Th: Chapter 3.1-3.2 Supplemental reading |
|
7
Feb-19 |
Database programming | Database design continued | Functional dependency Decomposition (1NF, 2NF, 3NF) |
Tu: Chapter 3.3-3.6 Th: Chapter 9.1-9.3, 9.6 |
|
8
Feb-26 |
Making the connection | Making the connection(Lab: php) | Exam 1 (Lab) | Tu: Chapter 9.7 |
|
Mar 4-8
|
SPRING BREAK!!!
|
|||
|
9
Mar-12
|
Review and design | Go over Exam 1 - detailed | BCNF;, 4NF, and beyond | Th: Chapter 3.4, 3.6, 3.7 |
|
10
Mar-19 |
Database programming |
Making the connection 2(Lab: java) |
||
|
11
Mar-26 |
Views and Indexes |
|
Triggers processing (Lab) |
|
|
12
Apr-2 |
Why Indexes | Three tiered architecture Views & Indexes |
Lab Indexes and Big Data Revisit triggers |
Tu: Chapter9.1-9.3 8.1-8.2 Th: Chapter 8.3-8.5 |
|
13 Apr-9
|
Database Security | Database Security | Big data lab |
Tu: Chapter 10.1 Th: 10.2, 9.4 |
|
14 Apr-16
|
TBD | Other DBMS | Other DBMS (Lab) | |
|
15
Apr-23 |
Project presentations | Project Presentations (A) | Project Presentations (B) | |
|
Finals
May 3 |
Final Exam In the Lab Thursday, May 2, 1:00-3pm |
|||
Updated 01/02/2013 - NLH