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 HW#5 
    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