Spring 2013 (13-2 or 2134)
CS 1555/2055 : Database Management Systems
Department of Computer Science
University of Pittsburgh
Home
Syllabus
Policies & Grading
Class Schedule
Notes & Readings
Recitations
Assignments
»
Submit
»
Project Info
System Docs
FAQ
DB@PittCS
Recitation Notes
(
Note:
please visit this page frequently as it will be updated constantly during the term)
DATES
SUBJECT
HANDOUT
SOLUTION
Related Material
11 Jan 2013
Introduction to Relational Model
Recitation 1
Solution of Recitation 1
18 Jan 2013
Relational Algebra
Recitation 2
Solution of Recitation 2
25 Jan 2013
Relational Algebra
Recitation 3
Solution of Recitation 3
1 Feb 2013
SQL
Recitation 4
Solution of Recitation 4
Intro to ADMT's Oracle 11g Server
8 Feb 2013
SQL
Recitation 5
Solution of Recitation 5
15 Feb 2013
SQL Triggers and Stored Procedures
Recitation 6
Solution of Recitation 6
22 Feb 2013
SQL Views, Stored Procedures and Functions
Recitation 7
Solution of Recitation 7
1 Mar 2013
Transaction Concurrency Control & Deadlocks
Recitation 8
Solution of Recitation 8
TranDemo1.java
TranDemo2.java
rec8db.sql
8 March 2013
Serializability theory and Transaction processing
Recitation 9
Solution of Recitation 9
22 Mar 2013
No Recitations: CS Day!
29 March 2013
Dynamic Hashing
Recitation 10
Solution of Recitation 10
5 Apr 2013
B+ Tree
Recitation 11
Solution of Recitation 11
12 April 2013
Normalization
Recitation 12
Solution of Recitation 12
19 Apr 2013
ER Design
Recitation 13
Solution of Recitation 13
ER-2-Relational
Copyright
Panos K. Chrysanthis
© 2013
Last updated on April 22, 2013 at 08:13:27 EST