Syllabus

CS3010301 Database Systems

Spring 2026
Department of Computer Science and Information Engineering
National Taiwan University of Science and Technology

Lectures:

Tuesday 15:30 - 17:20 and Friday 09:10 - 10:00 (TR-313)

Instructor:

Yi-Leh Wu (吳怡樂)
e-mail: ywu_at_csie.ntust.edu.tw
Office: RB-503-1
Office Hours: TR 11:00-12:00, or by appointment.

TAs:

Mr. Liu (劉家成) Email: M11415017_at_mail.ntust.edu.tw  Office: RB-306-3 (Office hours: TBA or by appointment) (O) 27333141 ext. 7322

Course Description:

This course is about relational theory, databases’ logical and physical design, and database performance optimization. In the first part of the course, we will cover various data models and query languages, mainly focusing on the relational model and languages. In the second part of the course, we will discuss some advanced features of SQL and the issues and techniques related to improving database performance. Database systems technology is considered one of the most important core technologies in Industry 4.0.

Textbook:

Fundamentals of Database Systems (7th edition, ISBN-10: 1-292-09761-2), by Ramez Elmasri and Shamkant B. Navathe

Software Tools:

Required: e-mail
Optional (for access to online lecture notes): Adobe Reader

Grading Policy:

Homework and/or Projects 40%
Midterm 30%
Final 30%

Schedule:

Week	Topics	Chapters
1	Administrative issues Introduction to database systems	1
2	Database System Concepts and Architecture	2
3	ER Model	7
4	Relational Model	3,8
5	Relational Algebra  and Relational Calculus (I)	6
6	Relational Algebra  and Relational Calculus (II)	6
7	MIDTERM
8	SQL (I)	4
9	SQL (II)	5
10	Functional Dependencies and Normalization	14
11	Transactions/	20
12	Concurrency Control	21
13	Recovery	22
14	Query Processing and Optimization	18
15	Database Indexing	17
16	FINAL

Online Resources:

Class home page - http://faculty.csie.ntust.edu.tw/~ywu/cs3010301/index.html

Academic Integrity:

Cheating will not be tolerated. Cheating on any assignment or exam will be taken seriously.  All parties involved will receive a grade of F for the course and be reported to the corresponding authorities.