Lectures and Assignments

The following schedule will be updated as we progress. The lecture slides and assigned readings will be posted after each lecture. The homeworks will be posted as they are assigned and sample homework solutions will be posted after they are graded.

Week # Date Lectures Notes and Sample Programs Readings Assignments
Week 1 08/25 Introduction and course logistics Ch 1
Week 2 08/30 Database design concepts Ch 2
09/01 Entity-Relationship Model (Liyue Fan) Ch 7 Hw1 Solution
Week 3 09/06 Relational Model Ch 3
09/08 Mapping from ER to Relational Model Ch 9 Hw2 Solution
Week 4 09/13 Relational Algebra 1 Ch 6
09/15 Relational Algebra 2 Ch 6 Hw3 Solution
Week 5 09/20 SQL 1, Oracle Tutorial, SQL scripts for Company DB Ch 4
09/22 SQL 2, SQL queries for Company DB Ch 4, 5 Lab1, Oracle Tutorial
Week 6 09/27 SQL 3, SQL queries for Company DB Ch 4, 5 Hw4 Solution
09/29 SQL 4, SQL queries for Company DB Ch 4, 5
Week 7 10/04 Java/SQL programming, JDBC programs Ch 13
10/06 PHP/SQL Programming, sample PHP programs, sample PHP source code Ch 14 Project
Week 8 10/11 Fall break!
10/13 Midterm, Solution
Week 9 10/18 Relational Database design theory 1 Ch 15 Lab2, MySQL/PHP Tutorial
10/20 Relational Database design theory 2 Ch 16 Hw5 Solution
Week 10 10/25 Data Storage Ch 17
10/27 Indexing 1 Ch 18 Hw6 Solution
Week 11 11/01 Indexing 2 Ch 18
11/03 Query Execution and Optimization 1 Ch 19 Hw7 Solution
Week 12 11/08 Query Execution and Optimization 2 Ch 19
11/10 Transaction Management and Recovery Ch 21, 23
Week 13 11/15 Concurrency Control Ch 21, 22.1 Hw8 Solution
11/17 Data security and privacy Ch 24
Week 14 11/22 Distributed Databases Ch 25
11/24 Thanksgiving break!
Week 15 11/29 Data warehouse and data mining Ch 28, 29
12/1 Text data and information retrieval Ch 27
Week 16 12/6 Project workshop
12/13 8:30-11am Final Exam