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 HW#2: [T1: P92, Ex.5]
    3.27 Thursday Procedural SQL  
    6 4.1 Tuesday Procedural SQL  
    4.3 Thursday Schema Design Lab 01
    7 4.8 Tuesday Schema Design  
    4.10 Thursday Schema Design HW#3
    8 4.15 Tuesday Database Design  
    4.17 Thursday Database Design  
    9 4.22 Tuesday Database Design Lab 02
    4.24 Thursday Database Indices  
    10 4.29 Tuesday Database Indices  
    5.1 Thursday No Class  
    11 5.6 Tuesday Development of Database Applications HW#4
    5.8 Thursday Development of Database Applications Lab 03
    12 5.13 Tuesday Transaction & Recovery   
    5.15 Thursday Transaction & Recovery   
    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