SE305 Database System Technology

Course Summary

This course is a first course in database systems for undergraduates at SJTU/CS. It covers the fundamantal concepts of modern database management including database design, database languages and database system implementation. It assumes only familiarity with basic data structures, computer organization and a high level programming language such as Java or C. The concepts and algorithm presented in this course are based on commercial or experimental database systems. The idea is not to tie these concepts to a particular database system but to present it in a general setting. Most of the assignments and projects are done using Java/C and the open source MySQL which is widely available. Topics covered in this course include: relational databases, database design, data storage and querying processing, transactions, system architecture, data mining and information retrieval, and optionally, XML and a case study on a particular database system.

Latest News

Administrative Information

Lectures: Tue 10 - 11:40 and Thu 14:00-15:40, Dong Zhong Yuan, Room 1-109

Instructor: Kenny Zhu - SEIEE 03-541 Phone: 3420-4592 Email:
Office hours: by appointment via email or ask after class

Teaching Assistant: Yizhu Liu - SEIEE 03-341, Phone: 182 2141 8016 Email:
Office hours: Friday 4 PM

Textbooks: Database System Concepts (5th ed.) By Abraham Silberschatz, Henry F. Korth and S. Sudarshan. (Available at the University Textbook Center).

Other References:

  1. Database Systems: The Complete Book (2nd Edition) by Hector Garcia-Molina, Jeffrey D. Ullman and Jennifer Widom(Jun 15, 2008).
  2. Advanced Database Systems (The Morgan Kaufmann Series in Data Management Systems) by Carlo Zaniolo, Stefano Ceri, Christos Faloutsos and Richard T. Snodgrass(May 15, 1997).
  3. Data Mining: Concepts and Techniques, Third Edition (The Morgan Kaufmann Series in Data Management Systems) by Jiawei Han, Micheline Kamber and Jian Pei(Jul 6, 2011).

Hands-on Setup: Comprehensive Reference Manual for MySQL 5.7.

Peer Review Form: Click here.


  1. Quizzes and Assignments: 40%
  2. Lab Projects: 30% (Project Description here)
  3. Final Exam: 30%


LectureDateTopic SlidesResourcesHomework
109/13/2017 Introduction to Databases[pdf] Textbook Ch.1
209/16/2017 Relational Model[pdf] Textbook Ch.2 Assignment 1
309/19/2017 Extended Relational Algebra and Introduction to SQL (I)[pdf] Textbook Ch.3
409/21/2017 Introduction to SQL (II)[pdf] Textbook Ch.3 Assignment 2
509/26/2017 Introduction to SQL (III)[pdf] Textbook Ch.4
609/28/2017 E-R Model (I)[pdf] Textbook Ch.5 Assignment 3
709/30/2017 E-R Model (II)[pdf] Textbook Ch.5
810/10/2017 Relational Database Design (I) [pdf] Textbook Ch.6
910/12/2017 Relational Database Design (II) [pdf] Textbook Ch.6 [Assignment 4]
1010/17/2017 Storage and File Structure[pdf] Textbook Ch.11
1110/19/2017 Indexing[pdf] Textbook Ch.12 [Assignment 5]
1210/24/2017 Indexing (II), Query Processing[pdf] Textbook Ch.12
1310/26/2017 Query Processing and Optimization[pdf] Textbook Ch.12 [Assignment 6]
1410/31/2017 Transactions[pdf] Textbook Ch.15
Copyright (c) Kenny Q. Zhu, 2013-2017.