Class Notes

Notes: 1. please visit this page frequently, as it will be updated constantly during the term
2. Items under Textbook and under Slides / Additional Material are considered mandatory reading and will be tested in the exams.
3. Links to O'Reilly's Safari Online Bookshelf are only available within pitt.edu or from outside pitt.edu using the University's VPN service (https://sremote.pitt.edu). Please remember to sign out once you finished reading -- the University has a very limited number of concurrent user licenses.

Shortcuts:

11: Database Normalization (April 14 and 16, 2014)
Textbook
Chapter 15
Slides / Additional Material
DB Normalization slides (pdf)
Note: ONLY up to slide 31 (including) will be considered in the Final Exam (i.e., material covered until Monday, April 14)
Online Resources
Reference Books

10: Database Design (April 7 and 9, 2014)
Textbook
Chapter 7 and Chapter 8
Slides / Additional Material
DB Design slides (pdf)
Online Resources
Reference Books

09: Transaction Recovery (April 2, 2014)
Textbook
Chapter 23
Slides / Additional Material
Transaction Recovery slides (pdf)
Online Resources
Reference Books

08: Indexing (Mar 24 and 26, 2014)
Textbook
Chapter 18
Slides / Additional Material
Indexing slides (pdf)
Online Resources
Reference Books

07: Data & File Storage (Mar 19, 24, 2014)
Textbook
Chapter 17
Slides / Additional Material
Data Storage slides (pdf)
Record Placement slides (pdf) File Organization slides (pdf)
Online Resources
Reference Books

06: Concurrency Control (Mar 5 and 17, 2014)
Textbook
Chapter 21 (except for 2.14) and Section 22.1
Slides / Additional Material
Concurrency Control slides (pdf)
Online Resources
Reference Books

05: DB Programming (Feb 19 and Mar 3, 2014)
Textbook
Chapter 13
Slides / Additional Material
Database Programming slides (pdf)
Online Resources
Reference Books

04: Views, Access Control, Integrity Contraints, Transactions (Feb 12, 17, 2014)
Textbook
Chapters 5.2 - 5.5
Slides / Additional Material
View slides (pdf)
Access control slides (pdf)
Integrity constraints/Triggers slides (pdf)
Online Resources
Reference Books

03: SQL DDL and DML (Jan 29, Feb 3, 5, and 10, 2014)
Textbook
Chapter 4.1 - 4.6 and 5.1
Slides / Additional Material
DDL slides (pdf)
DML slides (pdf)
Online Resources
Reference Books

02: Relational Model and Relational Algebra (Jan 13, 15, 22, and 27, 2014) -- EXCLUDED from Final Exam
Textbook
Chapters 3, 6.1 - 6.5
Slides / Additional Material
slides (pdf)
Online Resources
Reference Books

01: Introduction to Database Management (Jan 6, 2014) -- EXCLUDED from Final Exam
Textbook
Chapters 1 and 2
Slides / Additional Material
slides (pdf)
Online Resources
Reference Books