Lecture Slides

# Date Topic Slide Note
1 11.27 Ch 1 and Ch 11 Intro. and B+-Tree
[Ch 1]
[Ch 11.1]
2 11.29 Ch 2 and Ch 3 Relational Model and Intro. to SQL
[Ch 2]
[Ch 3]
3 12.4 Ch 3 and Ch 4 SQL
[Ch 3]
[Ch 4]
TA session 12.5 PHP PHP and MySQL
[PHP slides]
4 12.6 Ch 5 SQL
[Ch 5.1]
B+-Tree Project Due
5 12.11 Ch 5 SQL
[Ch 5.2]
[Ch 5.3 (skipped)]
[PLSQL]
[MySQL-SPL]
6 12.13 Ch 6 Relational Calculus
[Ch 6]
[Ch 6]
Functional Specification Due
7 12.18 Ch 7 ER Diagram [Ch 7]
12.20 Cancelled SQL Homework Due
8 12.27 Ch 8 Relational Database Design
[Ch 7]
[Ch 8]
9 1.3 Midterm
- 1.5 Make-up class at 2pm
[Ch 8]
TA session 1.5 (4pm) Android and SQLite
[SQLite]
10 1.8 Ch 10 Storage and File Structure
[Ch 10.1]
[Ch 10.2]
11 1.10 Ch 11 Indexing and Hashing
[Ch 11]
12 1.15 Ch 12 Query Processing
[Ch 12.1]
Design Specification Due
13 1.17 Ch 13 Query Optimization
[Ch 12.2]
[Ch 13.1]
14 1.22 Ch 14 Transactions [Ch 14]
Extendible Hashing Due
15 1.24 Ch 15 Concurrency Control [Ch 15.1]
16 1.25 7pm
(Make up)
Ch 15 and 16 Concurrency Control and Recovery Systems
[Ch 15.2]
[Ch 16.1]
- 1.29 Class Cancelled
18 1.31 Ch 16 Recovery Systems and Multi-dimensional Indexing
[Ch 16.2]
[RTree]
2.1 Project Demonstration
Schedule
Please come to Windows Lab for demonstration
Final Report Due
2.5 : 4pm Final Exam (T201)





Link :