Announcement

Lecture Hours

  • Mon, Wed 17:30 - 18:45
  • Office Hours: Thu 3pm - 4pm
  • TA office Hours: Tue 8pm - 9pm

Textbook

  • Database System Concepts (A. Silbershatz)

Grading

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

Assignments

  • Term Project
    Description
    1st Phase Report Due: Apr. 2
    2nd Phase Report Due: May. 7
    Final Phase Report Due: Jun. 7
    Project Presentation: Jun. 9 Tue. (8pm-10pm, LinuxLab)
  • B+-tree Project for CSE 1st major
    Description
    Due: Jun. 7
  • Extendable Hashing Project for CSE 2nd major
    Description
    Due: Jun. 7

Lecture Slides

# Date Topic Slide Note
1 3.2 Introduction to Database Chap 1.
2 3.4 Relational Model and Intro. to SQL Chap 2.
3 3.9 Introduction to MySQL and SQL Chap 3.
4 3.11 Introduction to SQL
5 3.16 Intermediate SQL Chap 4.
6 3.18 Formal Relational Query Language Chap 6.
7 3.23 Formal Relational Query Language Chap 6.
8 3.25 Entity Relationship Model Chap 7.
9 3.30 Normal Forms Chap 8.
10 4.1 Normal Forms
11 4.6 Storage and File Organization Chap 10.
12 4.8 Storage and File Organization
13 4.13 Indexing Chap 11.
14 4.15 Indexing Chap 11.
4.22 5:30pm Midterm Exam Midterm Exam
15 4.27 Query Processing Chap 12.
PHP 4.28 PHP Lecture PHP
16 4.29 Query Processing
17 5.4 Query Optimization Chap 13.
18 5.6 Transaction Chap 14.
19 5.11 Concurrency Control Chap 15.
20 5.13 Concurrency Control
21 5.18 Concurrency Control
22 5.20 Concurrency Control
23 5.25 Chap 16.
24 5.27
25 6.1
26 6.3 Big Data
27 6.3
28 6.3
6.15 Final Exam 1pm Class room: E204 Sample Final Exam. [PDF]



Link :