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: Concepts and Architecture (02ConceptsAndArchitecture.pdf)
• Lecture03: Relational Model (03RelationalModel.pdf)
• Lecture04: Basic SQL (04BasicSQL.pdf)
• Lecture05: Relational Algebra and Calculus (05RelationalAlgebraCalculus.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)
• Lecture13: Concurrency Control (13ConcurrencyControl.pdf)
• Lecture14: NoSQL and Big Data (14NoSQL.pdf)