Lecture Notes  (Last updated 6 May 2007)

• Lecture 00 (Thursday, 11 Jan 2007) - Database System Concepts:
  Discussion: Course Organization and Survey
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 01 (Tuesday, 16 Jan 2007) - Database Architecture:
  Discussion: Client-Server Models, Relational DB Definitions
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 03 (Thursday, 18 Jan 2007) - Introduction (Chapter 1) and Relational
  Discussion: Algebra Intro (Sections 2.1-2.2)
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 04 (Tuesday, 23 Jan 2007) - Relational Joins
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 05 (Tuesday, 23 Jan 2007) - Relational Queries, Division, and SQL Preliminaries
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 06 (Thursday, 25 Jan 2007) - Updates and SQL Intro
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 07 (Tuesday, 30 Jan 2007) - SQL Operations and Outer Join
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 08 (Tuesday, 30 Jan 2007) - Lab Practice
  
• Lecture 09 (Thursday, 01 Feb 2007) - Advanced SQL
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 10 (Tuesday, 06 Feb 2007) - Advanced SQL and Relational Calculus Preliminaries
  Notes: Notes: MP2 Questions
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 11 (Thursday, 08 Feb 2007) - Notes: MP2, Relational Calculi and GQBE
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 12 (Tuesday, 13 Feb 2007) - Database Design Overview
  Notes: Relational Calculi, PS3
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 13 (Tuesday, 13 Feb 2007) - Entity-Relational Data Modeling
  Notes: PS3 Notes, E-R Applications (Projects)
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 14 (Thursday, 15 Feb 2007) - 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 (Tuesday, 20 Feb 2007) - Entity-Relational Data Modeling
  Notes: E-R, PS3, and Exam 1 Review
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 16 (Tuesday, 20 Feb 2007) - Database Normalization
  Notes: Rationale for Normalization
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 17 (Thursday, 22 Feb 2007) - 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 18 (Tuesday, 27 Feb 2007) - Problem Set (1 & 3) and Hour Exam 1 Review
  Notes: Normal Forms with Examples
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 21 (Tuesday, 06 Mar 2007) - Intro to Web Databases
  Discussion: Online DBs
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 22 (Thursday, 08 Mar 2007) - Intro to Web Databases
  Discussion: Online DBs
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 23 (Tuesday, 13 Mar 2007) - Extensible Markup Language (XML)
  Discussion: Semistructured Data
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 24 (Tursday, 15 Mar 2007) - XML-based Query Languages:
  Discussion: XMLSchema, XPath, XQuery, XSLT
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 25 (Tuesday, 27 Mar 2007) - XML Structure and Document Schemas
  Discussion: Indexing
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 26 (Tuesday, 27 Mar 2007) - Indexing and Hashing
  Discussion: B+ trees
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 28 (Thursday, 29 Mar 2007) - Query Processing: Fast Joins
  Discussion: PS5, MP6 and PS7
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 29 (Tuesday, 03 Apr 2007) - Query Processing: Fast Joins
  Discussion: Exam 2 Review
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 31 (Thursday, 05 Apr 2007) - Fast Joins (Continued)
  Discussion: DB Impl., Normalization Review
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 34 (Tuesday, 17 Apr 2007) - Exam2 Review
  Discussion: DB Impl., Normalization Review
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 37 (Thursday, 19 Apr 2007) - Fast Joins (Continued)
  Discussion: DB Impl., Normalization Review
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 38 (Tuesday, 24 Apr 2007) - Transactions: ACID Properties
  Discussion: ACID Definitions, MP6-7
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 40 (Thursday, 26 Apr 2007) - Concurrency
  Discussion: Term Projects
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 41 (Tuesday, 1 May 2007) - Data Mining, Information Retrieval and OLAP
  Discussion: Term Projects
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 42 (Thursday, 6 May 2007) - Data Mining, Information Retrieval and OLAP
  Discussion: Term Projects
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture

Back to the CIS560 main page