Lecture Notes  (Last updated 05 Dec 2008)

• Lecture 00 (Monday, 20 Aug 2008) - Database System Concepts: Course Organization and Survey
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 01 (Wednesday, 22 Aug 2008) - Database Architecture: Client-Server Models, Relational DB Definitions
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 2 (Friday, 24 Aug 2008) - Relational Database
  Discussion: Problem Set 1
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 3 (Monday, 27 Aug 2008) - Relational Database
  Discussion: Problem Set 1
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 4 (Wednesday, 29 Aug 2008) - Relational Joins
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 5 (Friday, 03 Sep 2008)
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 6 (Wednesday, 05 Sep 2008) -Modern SQL: Cursors and Views
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 8 (Monday, 10 Sep 2008)
  Notes: PS1 Solutions, MP2
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 9 (Wednesday, 12 Sep 2008) Introduction to Relational Calculi
  Notes: MP2, Datalog Preview
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 10 (Friday, 14 Sep 2008) Datalog
  Notes: MP2, Review of Relational Calculi
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 11 (Monday, 17 Sep 2008) Graphical Query by Example (GQBE)
  Notes: Relational Calculi, PS3
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 12 (Wednesday, 19 Sep 2008) Database Design Overview
  Notes: Relational Calculi, PS3
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 13 (Friday, 21 Sep 2008) Entity-Relational Data Modeling
  Notes: PS3 Notes, E-R Applications (Projects)
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 14 (Monday, 24 Sep 2008) E-R Diagrams, UML
  Notes: PS3 Notes, E-R Design
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 15 (Wednesday, 26 Sep 2008)Normal Forms
  Notes: E-R and Exam 1 Review
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 16 (Wednesday, 26 Sep 2008)
  Notes: E-R and Exam 1 Review
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 17 (Wednesday, 03 Oct 2008)Database Normalization
  Notes: Rationale for Normalization
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 18 (Friday, 05 Oct 2008)More Normal Forms
  Notes: JSP, MP4; Applications of Normalization
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 20 (Wednesday, 10 Oct 2008)Intro to Web Databases
  Discussion: Online DBs
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 21 (Friday, 12 Oct 2008)More on Online Databases
  Discussion: Server-Side Programming in JSP
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 22 (Monday, 15 Oct 2008)Authentication and Intro to XML
  Discussion: DB Security
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 23 (Wednesday, 17 Oct 2008)Extensible Markup Language (XML)
  Discussion: Semistructured Data
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 24(Wednesday, 17 Oct 2008)
  Discussion: Semistructured Data
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 25 (Monday, 22 Oct 2008) XML Structure and Document Schemas
  Discussion: Indexing
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 26 (Wednesday, 24 Oct 2008)Indexing and Hashing
  Discussion: B+ Trees
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 27 (Friday, 26 Oct 2008)Hashing
  Discussion: Problem Set 7
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 28 (Monday, 29 Oct 2008)Query Processing: Fast Joins
  Discussion: MP6 and PS7
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 29 (Wednesday, 31 Oct 2008)Query Processing: Fast Joins
  Discussion: Exam 2 Review
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 30 (Friday, 02 Nov 2008)Fast Joins (Continued)
  Discussion: DB Impl., Normalization Review
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture
• Lecture 31 (Monday, 05 Nov 2008)Fast Joins (Continued)
  Discussion: DB Impl., Normalization Review
  MS PowerPoint format-original marked
  Acrobat PDF format-original marked
  Tegrity lecture

Back to the CIS560 main page