Spring 2018 (18-2 or 2184)
CS 1555/2055 : Database Management Systems
Department of Computer Science
University of Pittsburgh
Home
Syllabus
Policies & Grading
»
Recording/Copyright
»
Piazza
Class Schedule
Notes & Readings
Recitations
Assignments
»
Submit
»
Project Info
»
System Docs
FAQ
Links
Recitation Notes
(
Note:
please visit this page frequently as it will be updated constantly during the term)
CS1555 Recitation Handouts
DATES
SUBJECT
HANDOUT
SOLUTION
Related Material
12 Jan 2018
Introduction to Relational Model
Recitation 1
Solution of Recitation 1
19 Jan 2018
SQL DDL
Recitation 2
Solution of Recitation 2
Intro to CSD's Oracle 12c Server
26 Jan 2018
DB Design - Normalization
Recitation 3
Solution of Recitation 3
2 Feb 2018
DB Design - ER Model
Recitation 4
Solution of Recitation 4
ER-2-Relational
9 Feb 2018
Relational Algebra
Recitation 5
Solution of Recitation 5
16 Feb 2018
More of Relational Algebra
Recitation 6
Solution of Recitation 6
23 Feb 2018
Serializability graph, deadlocks and transaction recovery
Recitation 7
Solution of Recitation 7
2 Mar 2018
JDBC, Transactions, Concurrency Control & Deadlocks
Recitation 8
Solution of Recitation 8
TranDemo1.java
TranDemo2.java
rec8db.sql
16 Mar 2018
Advanced SQL
Recitation 9
Solution of Recitation 9
23 Mar 2018
Triggers
Recitation 10
Solution of Recitation 10
30 Mar 2018
Functions, Procedures, and Views
Recitation 11
Solution of Recitation 11
6 Apr 2018
Understand hashing and practice creating dynamic hash structures
Recitation 12
Solution of Recitation 12
13 Apr 2018
Extensible Hash and B+ Trees
Recitation 13
Solution of Recitation 13
20 Apr 2018
Deferrable and Recovery
Recitation 14
Solution of Recitation 14
Copyright
Panos K. Chrysanthis
&
Alexandros Labrinidis
© 2018
Last updated on April 22, 2018 at 22:02:48 EST