Database Systems and Applications

   

    Instructor                        
    Peiquan Jin(金培权)
    Email: jpq@ustc.edu.cn

    Teaching Assistants
    张洲(博士生), zzwolf@mail.ustc.edu.cn  
    王义(硕士生), wykde@mail.ustc.edu.cn 
    罗永平(硕士生), ypluo@mail.ustc.edu.cn 
    吕晏齐(硕士生), lvyanqi@mail.ustc.edu.cn 
    戚林莉(硕士生), 18788825601@163.com 
    梁嘉玲(硕士生), ljl24@mail.ustc.edu.cn  

    Lectures
    Time: Monday (1, 2) & Wednesday (1, 2)
    Classroom:  3C102

    Textbook
    [T0] 金培权. 《数据库系统及应用》(draft). 科学出版社. 2020
    [T1] C. J. Date. An Introduction to Database System (Eighth Edition). China Machine Press, 2003 (中文版,孟小峰 等译. )
    [T2] Abraham Silberschatz Henry F. Korth S. Sudarshan, Database System Concepts (Sixth Edition),  China Machine Press, 2012 (中文版,杨冬青 等译)

    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 (中文版: 岳丽华, 金培权 等, 数据库系统基础教程, 机械工业出版社)

    Assignments
    Some homework assignments, which will be announced in each class. POLICY: all assignments should be completed and submitted with one week, i.e., before the next Wednesday class. Late submissions will be penalized 20% points. 

    Grading
    Homework: 20%
    Lab: 20% [Lab 01][Lab 02][Lab 03]
    Random Test: 10%
    Final Test: 50%

    Schedule and Course Notes

    Week

    Date

    Class

    Contents

    Chapters to read

    Homework

    1 2.17 Monday Introduction T1: Chp. 1  
    2.19 Wednesday Database Architecture  T1: Chp. 2  
    2 2.24 Monday Relational Data Model T1: Chps. 3, 5, & 6 HW#1
    2.26 Wednesday Relational Data Model T1: Chps. 3, 5, & 6
    C3: Chp. 2
     
    3 3.2 Monday Relational Data Model  T1: Chps. 3, 5, & 6
    C3: Chp. 2
     
    3.4 Wednesday SQL T2: Chps. 3 & 4
    C3: Chp. 3
    HW#2
    4 3.9 Monday SQL T2: Chps. 3 & 4
    C3: Chp. 3
     
    3.11 Wednesday SQL T2: Chps. 3 & 4
    C3: Chp. 3
     
    5 3.16 Monday SQL T2: Chps. 3 & 4
    C3: Chp. 3
    HW#3
    3.18 Wednesday Procedural SQL T2: Chp. 5
    C3: Chp. 8
     
    6 3.23 Monday Procedural SQL T2: Chp. 5
    C3: Chp. 8
     
    3.25 Wednesday Schema Design T1: Chps. 10 & 11
    T2: Chp. 8
     
    7 3.30 Monday Schema Design T1: Chps. 10 & 11
    T2: Chp. 8
     
    4.1 Wednesday Schema Design T1: Chps. 10 & 11
    T2: Chp. 8
     
    8 4.6 Monday No Class    
    4.8 Wednesday Database Design T1: Chp. 13
    T2: Chp. 7
    C3: Chp. 7
     
    9 4.13 Monday Database Design T1: Chp. 13
    T2: Chp. 7
    C3: Chp. 7
     
    4.15 Wednesday Database Design T1: Chp. 13
    T2: Chp. 7
    C3: Chp. 7
     
    10 4.20 Monday Developing Database Applications T2: Chp. 9  
    4.22 Wednesday Developing Database Applications  
    11 4.27 Monday Transaction Management: Introduction T2: Chp. 14  
    4.29 Wednesday Log & Recovery T1: Chp. 14
    T2: Chp. 16
    C3: Chp. 10
     
    12 5.4 Monday Log & Recovery T1: Chp. 14
    T2: Chp. 16
    C3: Chp. 10
    HW#7
    5.6 Wednesday Concurrency Control T1: Chp. 15
    T2: Chp. 15
     
    13 5.11 Monday Concurrency Control T1: Chp. 15
    T2: Chp. 15
    HW#8
    5.13 Wednesday Concurrency Control T1: Chp. 15
    T2: Chp. 15
    14 5.18 Monday Database Security T1: Chp. 16
    T2: Chp. 9.7 & 9.8
    C3: Chp. 4
    5.20 Wednesday Database Integrity T1: Chp. 8
    C3: Chp. 5
     
    15 5.25 Monday Advanced Topics    
    5.27 Wednesday Review    
      TBD   Final Exam