Database Systems and Applications
Instructor
Peiquan Jin（金培权）
Email:
jpq@ustc.edu.cn
Teaching Assistants
汪红韬（博）,
wht0613@mail.ustc.edu.cn
李超凡（硕）,
lichaofan@mail.ustc.edu.cn
辛梦晴（硕）, xinmq@mail.ustc.edu.cn
易 杰（硕）, 3064325896@qq.com
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 class assignments, required to be completed on-site. POLICY:
Late submissions will
not be accepted.
Grading
Homework: 20%
Lab: 20% [Lab01] [Lab02]
Final Test: 60%
Schedule and Course Notes
|
Week |
Date |
Class |
Notes |
Excercises |
| 1 | 3.3 | Tuesday | Introduction | |
| 3.5 | Thursday | Database System Architecture | ||
| 2 | 3.10 | Tuesday | Relational Data Model | |
| 3.12 | Thursday | Relational Data Model | ||
| 3 | 3.17 | Tuesday | Relational Data Model |
Exercise #1
answer |
| 3.19 | Thursday | SQL - Part1 | ||
| 4 | 3.24 | Tuesday | SQL - Part2 |
Exercise #2
answer |
| 3.26 | Thursday | SQL - Part2 | ||
| 5 | 3.31 | Tuesday | SQL - Part3 | |
| 4.2 | Thursday | Procedural SQL | ||
| 6 | 4.7 | Tuesday | Procedural SQL | |
| 4.9 | Thursday | Procedural SQL | [Lab01] | |
| 7 | 4.14 | Tuesday | Schema Design - Part 1 | |
| 4.16 | Thursday | Schema Design - Part 2 | ||
| 8 | 4.21 | Tuesday | Schema Design - Part 3 | |
| 4.23 | Thursday | Database Design - Part 1 |
Exercise #3 [Lab02]
answer |
|
| 9 | 4.28 | Tuesday | No Class | |
| 4.30 | Thursday | Database Design - Part 2 | ||
| 10 | 5.5 | Tuesday | No Class | |
| 5.7 | Thursday | Database Design - Part 2 | ||
| 11 | 5.12 | Tuesday | Database Indices - Part 1 | |
| 5.14 | Thursday | Database Indices - Part 2 | ||
| 12 | 5.19 | Tuesday | Development of Database Applications | |
| 5.21 | Thursday | Transaction & Recovery | ||
| 13 | 5.26 | Tuesday | Transaction & Recovery | |
| 5.28 | Thursday | Concurrency Control | ||
| 14 | 6.2 | Tuesday | Concurrency Control | |
| 6.4 | Thursday | Concurrency Control | ||
| 15 | 6.9 | Tuesday | Database Security & Integrity | |
| 6.10 | Thursday | Advanced Topics | ||
| Review | ||||
| 18 | Final Exam |