Announcement

  1. B+ Tree Assignment Due: Apr. 4

Lecture Hours

  • Mon, Wed 13:00 - 14:15
  • Office Hours: Thu 2:00 - 4:00

Textbook

  • Database System Concepts (A. Silbershatz)

Grading

  • Midterm and Final exams - 30% / 40%
  • Assignments - 30%
  • Class Attendance: If you miss classes more than 8 times, you will get F.

Assignments

  • B+ Tree
    Description
    Due Date: Mar. 28, 8pm
  • Term Project
    Description
    1st Phase Report Due: Apr. 2
    2nd Phase Report Due: May. 7
    Final Phase Report Due: Jun. 4
    Project Presentation: Jun. 9 (1pm)
  • Extendible Hashing
    Description
    Due Date: May. 28, 8pm

Lecture Slides

# Date Topic Slide Note
1 3.3 Introduction to Database Lecture01 - Ch.1
2 3.4 B+ tree Lecture02 - Ch.11
3 3.10 Relational Model and Intro. to SQL Lecture03 - Ch.2
Lecture03 - Ch.3
4 3.12 Introduction to SQL Lecture04 - Ch.3
5 3.17 Introduction to SQL Lecture 04 slides
6 3.18 Intermediate SQL Lecture06 - Ch.4
7 3.24 Formal Relational Query Language Lecture07 - Ch.6
8 3.26 Formal Relational Query Language Lecture08 - Ch.6
9 3.31 Entity Relationship Model Lecture09 - Ch.7
10 4.2 PHP
11 4.7 JDBC/ODBC Lecture11 - Ch.5
12 4.9 Normal Forms Lecture12 - Ch.8
13 4.14 Normal Forms Slides from the previous lecture
14 4.16 Storage Lecture14 - Ch.10
15 4.28 Storage Slides from previous lecture
16 4.30 Indexing Lecture16 - Ch.11
17 5.7 Indexing Lecture Slides from Previous Lecture
18 5.12 Indexing Lecture Slides from Previous Lecture
19 5.14 Query Optimization Lecture19 - Ch.12
20 5.19 Query Optimization Lecture20 - Ch.13
21 5.21 Query Optimization Same slides from previous lecture
22 5.26 Concurrency Control Lecture22 - Ch.14
23 6.2 Concurrency Control Lecture23 - Ch.15
24 6.4 Concurrency Control Same slides from previous lecture
25 6.9 Project Demo
26 6.11 Recovery Lecture26 - Ch.16
6.13 (7pm) Final Exam (T206)



Link :