Database Systems and Applications
Instructor
Peiquan Jin（金培权）
Email:
jpq@ustc.edu.cn
Teaching Assistants
张宇昂（硕）,
zya1412@mail.ustc.edu.cn
楚
颖（硕）,
cy2002@mail.ustc.edu.cn
李奕辰（硕）, 1806219293@qq.com
徐泽宇（硕）,
1040717286@qq.com
黄 鑫（硕）,
hx2002@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.25 | Tuesday | Introduction | |
| 2.27 | Thursday | Database System Architecture | ||
| 2 | 3.4 | Tuesday | Relational Data Model | |
| 3.6 | Thursday | Relational Data Model | ||
| 3 | 3.11 | Tuesday | Relational Data Model | HW#1：[T1: P59, Ex.6 & Ex.10] |
| 3.13 | Thursday | SQL | ||
| 4 | 3.18 | Tuesday | SQL | |
| 3.20 | Thursday | SQL | ||
| 5 | 3.25 | Tuesday | SQL | |
| 3.27 | Thursday | Procedural SQL | ||
| 6 | 4.1 | Tuesday | Procedural SQL | |
| 4.3 | Thursday | Schema Design | ||
| 7 | 4.8 | Tuesday | Schema Design | |
| 4.10 | Thursday | Schema Design | ||
| 8 | 4.15 | Tuesday | Database Design | |
| 4.17 | Thursday | Database Design | ||
| 9 | 4.22 | Tuesday | Database Design | |
| 4.24 | Thursday | Database Indices | ||
| 10 | 4.29 | Tuesday | Database Indices | |
| 5.1 | Thursday | Development of Database Applications | ||
| 11 | 5.6 | Tuesday | Development of Database Applications | |
| 5.8 | Thursday | Transaction & Recovery | ||
| 12 | 5.13 | Tuesday | Transaction & Recovery | |
| 5.15 | Thursday | Concurrency Control | ||
| 13 | 5.20 | Tuesday | Concurrency Control | |
| 5.22 | Thursday | Concurrency Control | ||
| 14 | 5.27 | Tuesday | Database Security | |
| 5.29 | Thursday | Database Integrity | ||
| 15 | 6.3 | Tuesday | Advanced Topics | |
| 6.5 | Thursday | Review | ||
| Final Exam |