COP4710 Database Systems (Spring 2025)

Lecture Schedule

This page provides the schedule of lecture topics, reading materials, and important milestones/deadlines. Please note: as a plan, the schedule is subject to changes and adjustment (Reference: University academic calendar);

Reading refers to the textbook chapter or sections. See the table of contents;

Week	Topics	Reading	Assignment	Project
1 (01/07, 01/09)	Introduction	Chapter 1 Chapter 4
2 (01/14, 01/16)	-- Introduction -- ER Model	Chapter 4
3 (01/21, 01/23)	-- ER Model -- Project Overview	Chapter 2
4 (01/28, 01/30)	Relational Model	Chapter 2	Assignment 1	Stage 1 due
5 (02/04, 02/06)	--Relational Model -- Relational Algebra	Chapter 5
6 (02/11, 02/13)	Relational Algebra	Chapter 3	Assignment 1 due
7 (02/18, 02/20)	Relational Design	Chapter 6	Assignment 2	Stage 2 due
8 (02/25, 02/27)	Relational Design	Chapter 6	Assignment 2 due
9 (03/04, 03/06)	-- Midterm exam (Tuesday 3/4) -- Relational Design	Chapter 6
10 (~~03/11, 03/13~~) Spring Break No Class
11 (03/18, 03/20)	SQL-basics	Chapter 9		Stage 3 due
12 (03/25, 03/27)	SQL-basics	Chapter 9	Assignment 3	SQL Code
13 (04/01, 04/03)	-- SQL-modifications and views -- Indexing	Chapter 14
14 (04/08, 04/10)	Indexing	Chapter 17	Assignment 3 due
15 (04/15, 04/17)	Crash Recovery	Chapter 17	Assignment 4
16 (04/22, 04/24)	-- Crash Recovery -- Final Review	Chapter 17	Assignment 4 due	Stage 4 (04/22, 04/23, Full days) Report due Wedensday
17	Final Exam (Thursday 05/01, 12:30pm-2:30pm)