Lecture Notes  (Last updated 02 Apr 2008)

• Lecture 00 (Friday, 18 Jan 2008) - Database System Concepts:
  Discussion: Course Organization and Survey
  MS PowerPoint format-original marked
  Acrobat PDF format Microsoft Word format
  Tegrity lecture
• Lecture 01 (Wednesday, 23 Jan 2008) - Database Architecture:
  Discussion: Client-Server Models, Relational DB Definitions
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 02 (Friday, 25 Jan 2008) - Relational Databases
  Discussion: Problem Set 1
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 03 (Monday, 28 Jan 2008) - Relational Databases
  Discussion: Problem Set 1
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 04 (Wednesday, 30 Jan 2008) - Relational Joins
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 06 (Monday, 04 Feb 2008) - Modern SQL: Cursors and Views
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 07 (Wed, 06 Feb 2008) - Embedded SQL and Dynamic SQL
  Notes: Assertions, Authorization, Cursors
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 09 (Fri, 11 Feb 2008) - Introduction to Relational Calculi
  Notes: MP2, Datalog Preview
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 10 (Wed, 13 Feb 2008) - Datalog
  Notes: MP2, Review of Relational Calculi
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 12 (Mon, 18 Feb 2008) - Query by Example (GQBE), E-R Intro
  Notes: Relational Calculi, PS3
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 13 (Wed, 20 Feb 2008) - Database Design Overview
  Notes: Relational Calculi, PS3
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 14 (Fri, 22 Feb 2008) - E-R Diagrams, UML
  Notes: PS3 Notes, E-R Design
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 15 (Mon, 25 Feb 2008) - Normal Forms
  Notes: E-R and Exam 1 Review
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 16 (Wed, 27 Feb 2008) - Database Normalization
  Notes: Rationale for Normalization
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 18 (Wed, 5 Mar 2008) - More Normal Forms
  Notes: 3NF vs. BCNF vs. 4NF; MP4, Exam 1
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 19 (Fri, 7 Mar 2008) -
  Notes: Intro to Web Databases
  Discussion: Online DBs
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 21 (Wed, 12 Mar 2008) - More on Online Databases
  Discussion: Server-Side Programming in JSP
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 25 (Wed, 12 Mar 2008) - Indexing and Hashing
  Discussion: B+ Trees
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 27 (Mon, 02 Apr 2008) - Query Processing: Fast Joins
  Discussion: Hour Exam 2 Review
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture

Back to the CIS560 main page