CSC 3170 at CUHKSZ
Database System
Lectures: Mon 18:00-19:20 p.m./Tus 8:30-9:50 a.m. ChengDao Bldg 103
Motivation: This is an introductory course in database systems. Topics discussed include database schemas and architectures, relational database, SQL, E-R-model, database design and normalization, indexing and hashing, transaction management, analytic processing, data warehouse and data mining.
-
-
-
TA ZHANG, Qihang
119010434@link.cuhk.edu.cn
Office Hours: Wednesday 16:00pm - 18:00pm Daoyuan Underground 102
-
USTF TONG, Zhen
120090694@link.cuhk.edu.cn
Office Hours: Online OH whenever you need me(email me first!)
-
USTF HU, Wenhan
120090565@link.cuhk.edu.cn
Office Hours:
Homeworks
See Syllabus for more information.
Lecture Slides & Notes
See Syllabus for more information.
-
Lecture 1: Introduction and Course Overview
Note 1: Introduction -
Lecture 2: Relational Model
Note 2: relational model -
Lecture 3: Entity Relationship Model
Note 3: Entity-Relationship Model - Lecture 4: Extended Entity-Relationship Features Note 4: Notes
-
Lecture 5 (Find on BB)
Note 5: Notes Relational Database Design and Normalization - Lecture 6: Notes: Functional Dependency Theory
- Note 7: File Organization
- Note 8: B-Trees
- Note 9: Hashing
Optional Labs
The optional labs is not grading. It can enhances your project ability! It is a good preparation for your final project! Plus, because I implement it by myself, I beg you to have a look🎈