Database System Concepts
Monday/Wednesday/Friday 10:30am - 11:20am Room 127 Nichols Hall
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
Page created: 19 Jan 2008
Last updated: 02 Apr 2008
William H. Hsu, CIS 560 instructor