Lecture Notes  (Last updated 04 Dec 2006)

• Lecture 00 (Monday, 21 Aug 2006) - Course Overview: Database System Concepts
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 01 (Wednesday, 23 Aug 2006) - Introduction to Relational Databases
  Database Architecture: Client-Server Models, Relational DB Definitions
  Discussion: Problem Set Guidelines
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 02 (Friday, 25 Aug 2006) - Relational Databases
  Discussion: Problem Set 1, Course Syllabus
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 03 (Monday, 28 Aug 2006) - Relational Algebra: Select, Project, and Other Operators
  Discussion: Set Differences and Intersection, Natural Join
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 04 (Wednesday, 30 Aug 2006) - Relational Algebra: Equality and Outer Join, Division
  Discussion: Division Examples, Unix join (equijoin)
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture to be re-recorded
• Lecture 05 (Friday, 01 Sep 2006) - SQL Query Syntax
  Discussion: Outer vs. Inner Join
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 06 (Wednesday, 06 Sep 2006) - Modern SQL: Cursors and Views
  Discussion: DELETE, INSERT, UPDATE, DROP TABLE, ALTER TABLE (ADD, DROP)
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture-marked
• Lecture 07 (Friday, 08 Sep 2006) - Embedded SQL and Dynamic SQL
  Discussion: Assertions, Authorization, Cursors, Machine Problem 2
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 08 (Monday, 11 Sep 2006) - Database Connectivity: ODBC and JDBC
  Discussion: Problem Set 1 solutions
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 09 (Wednesday, 13 Sep 2006) - Tuple Relational Calculus
  Discussion: Machine Problem 2 guidelines, remedial/refresher set theory, relational algebra vs. calculus examples
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 10 (Friday, 15 Sep 2006) - Domain Relational Calculus and Datalog
  Discussion: Relational algebra vs. relational calculus example, set theory background
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 11 (Monday, 18 Sep 2006) - Graphical Query by Example
  Discussion: Relational Calculi, PS3
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 12 (Wednesday, 20 Sep 2006) - Database Design Overview
  Discussion: Relational Calculi, PS3
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 13 (Friday, 22 Sep 2006) - Entity-Relational Data Modeling
  Discussion: PS3 Notes, E-R Applications (Projects)
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 14 (Monday, 25 Sep 2006) - E-R Diagrams and UML
  Discussion: Problem Set 3, E-R Modeling in Projects
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 15 (Wednesday, 27 Sep 2006) - Normal Forms
  Discussion: Notes: E-R and Exam 1 Review
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 16 (Friday, 29 Sep 2006) - Database Normalization
  Notes: Rationale for Normalization
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 17 (Wednesday, 04 Oct 2006) - 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 (Friday, 06 Oct 2006) - Review Session, Hour Exam 1
  
• Lecture 19 (Monday, 09 Oct 2006) - Post-Exam Review, Hour Exam 1
  
• Lecture 20 (Wednesday, 11 Oct 2006) - Intro to Web Databases
  Discussion: Online DBs
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 21 (Friday, 13 Oct 2006) - Intro to Web Databases
  Discussion: Online DBs
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 22 (Monday, 16 Oct 2006) - Servlets and JSP
  Discussion: Online DBs
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 23 (Wednesday, 18 Oct 2006) - Extensible Markup Language (XML)
  Discussion: Semistructured Data
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 24 (Friday, 20 Oct 2006) - XML Structure and Document Schemas
  Discussion: Indexing
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 25 (Monday, 23 Oct 2006) - XML Structure and Document Schemas
  Discussion: Indexing
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 26 (Wednesday, 25 Oct 2006) - Indexing and Hashing
  Discussion: B+ Trees
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 27 (Friday, 27 Oct 2006) - Hashing
  Discussion: Problem Set 5
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 28 (Monday, 30 Oct 2006) - Query Processing: Select Methods
  Discussion: MP6 and PS7
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 29 (Wednesday, 1 Nov 2006) - Query Processing: Fast Joins
  Discussion: Hour Exam 2 review, MP6 and PS7
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 31 (Monday, 06 Nov 2006) - Fast Joins (Continued)
  Discussion: DB Implementation, Normalization Review
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 32 (Wednesday, 08 Nov 2006) - MySQL Primer 1 of 2, Fast Joins Concluded
  Discussion: DB Norm., Practical DBs
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 33 (Friday, 10 Nov 2006) - MySQL Primer 2 of 2, Practical DBs
  Discussion: Homeworks 6-10
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 34 (Monday, 13 Nov 2006) - Oracle Survey 1 of 2
  Discussion: Homeworks 7-8, Oracle Terms
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 35 (Wdendesday, 15 Nov 2006) - Transactions: ACID Properties
  Discussion: ACID Definitions, MP6-7
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 36 (Friday, 17 Nov 2006) - Class Discussion
  Nothing to show
  
• Lecture 37 (Monday, 20 Nov 2006) - Concurrency
  Discussion: Term Projects
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 38 (Monday, 27 Nov 2006) - Class Discussion
  Nothing to show
  
• Lecture 39 (Wednesday, 29 Nov 2006) - Online Analytical Processing (OLAP)
  Discussion: Data Cubes
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture
• Lecture 40 (Friday, 01 Dec 2006) - Online Analytical Processing (OLAP)
  Discussion: Data Cubes
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture <
• Lecture 41 (Monday, 04 Dec 2006) - Information Retrieval (IR)
  Discussion: Information Extraction (IE)
  MS PowerPoint format-original marked
  Acrobat PDF format (2-up)-original marked
  Tegrity lecture

Back to the CIS560 main page