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 Architecture (02ModelsAndArchitecture.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)
• Midterm exam with solutions (DB2020midtermSol.pdf)