Database Systems and Applications
Instructor
Peiquan Jin（金培权）
Email:
jpq@ustc.edu.cn
Teaching Assistants
汪洪韬（硕士生）,
wht0613@mail.ustc.edu.cn
孙远林（硕士生）,
syl937859459@mail.ustc.edu.cn
姜子健（硕士生）,
jiangzijian@mail.ustc.edu.cn
张宇昂（本科生）,
zya1412@mail.ustc.edu.cn
Lectures
Time: Tuesday (6, 7) & Thursday (3, 4)
Classroom:
GT-B112
Textbook
[T1]
金培权, 数据库系统及应用, 科学出版社, 2023
References
[C1] Peter Bailis, Joseph M. Hellerstein, Michael Stonebraker,
Readings in Database Systems, 5th Edition
[C2] Raghu Ramakrishnan et al. Database Management Systems (Third Edition), McGraw-Hill & Tsinghua
University Press
[C3] 萨师煊, 王珊, 数据库系统概论(第5版)，高教出版社
[C4] J.
Ullman et al., A First Course to Database Systems (Third Edition).
China Machine Press (中文版: 岳丽华, 金培权 等, 数据库系统基础教程, 机械工业出版社)
[C5] C. J.
Date. An Introduction to Database System (Eighth Edition). China
Machine Press, 2003 (中文版，孟小峰 等译. )
[C6] Abraham Silberschatz Henry F. Korth S. Sudarshan,
Database System Concepts (Sixth Edition), China Machine Press, 2012
（中文版，杨冬青 等译）
Assignments
Some homework assignments, which will be announced after each
chapter. POLICY:
all assignments should be completed and submitted with one week, i.e.,
before the next Thursday's class. Late submissions will be penalized 20% points.
Grading
Homework: 20%
Lab: 20% [Lab 01,
Lab 02,
Lab 03]
Final Test: 60%
Schedule and Course Notes
|
Week |
Date |
Class |
Notes |
Homework |
| 1 | 2.27 | Tuesday | Introduction | |
| 2.29 | Thursday | Database System Architecture | ||
| 2 | 3.5 | Tuesday | Relational Data Model | |
| 3.7 | Thursday | Relational Data Model | ||
| 3 | 3.12 | Tuesday | Relational Data Model | HW#1：[T1: P59, Ex.6 & Ex.10] |
| 3.14 | Thursday | SQL - Part 1 | ||
| 4 | 3.19 | Tuesday | No Class | |
| 3.21 | Thursday | No Class | ||
| 5 | 3.26 | Tuesday | SQL - Part 1 | |
| 3.28 | Thursday | SQL - Part 2 | ||
| 6 | 4.2 | Tuesday |
SQL - Part 3 & Procedural SQL - Part 1 |
HW#2: [T1: P92, Ex.5] |
| 4.4 | Thursday | No Class | ||
| 7 | 4.9 | Tuesday | Procedural SQL - Part 2 | Lab 01 |
| 4.11 | Thursday | Schema Design - Part 1 (3 units) | ||
| 8 | 4.16 | Tuesday | Schema Design - Part 2 | |
| 4.18 | Thursday | Database Design - Part 1 (3 units) | HW#3 Lab 02 | |
| 9 | 4.23 | Tuesday | Database Design - Part 2 | |
| 4.25 | Thursday | Database Design - Part 2 | ||
| 4.28 | Sunday | Database Indices [9:45-12:00] (3 units) | ||
| 10 | 4.30 | Tuesday | Database Indices | |
| 5.1 | Thursday | No Class | ||
| 11 | 5.7 | Tuesday | Development of Database Applications | HW#4 Lab 03 |
| 5.9 | Thursday | Transaction & Recovery - Part 1 (3 units) | ||
| 12 | 5.14 | Tuesday | Transaction & Recovery - Part 2 | |
| 5.16 | Thursday | Concurrency Control - Part 1 | ||
| 13 | 5.21 | Tuesday | Concurrency Control - Part 2 | |
| 5.23 | Thursday | Concurrency Control - Part 3 | ||
| 14 | 5.28 | Tuesday | Database Security | |
| 5.30 | Thursday | Database Integrity | ||
| 15 | 6.4 | Tuesday | Advanced Topics | |
| 6.6 | Thursday | Review | ||
| Final Exam |