Lecture Notes and Handouts

Lecture notes are placed in here for your reference AFTER the class.  Some interesting Web resources are placed in the reference page.

Lecture Notes

• Lecture00: Course information (00CourseInfo.pdf)
• Lecture01: Introduction (01Introduction.pdf)
• Lecture02: Models and architectures (02ModelsAndArchitectures.pdf)
• Lecture03: Relational model (03RelationalModel.pdf)
• Lecture04: Relational algebra and calculus (04RelationalAlgebraCalculus.pdf)
• Lecture05: Basic SQL (05BasicSQL.pdf)
• Lecture06: More SQL (06MoreSQL.pdf)
• Lecture07: Entity-Relationship(ER) Model (07ERmodel.pdf)
• Lecture08: Enhanced Entity-Relationship(EER) Model (08EERmodel.pdf)
• Lecture09: ER/EER to Relational Mapping (09ERtoRelational.pdf)
• Lecture10: Relational database design I (10RDBdesign1.pdf)
• Lecture11: Relational database design II (11RDBdesign2.pdf)
• Lecture12: Transactions (12Transactions.pdf)

Past Exams and Solutions

• 2020Fall Midterm and Solutions (DB2020midtermSol.pdf)