Fall 2017 (18-1 or 2181)
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
8 Sept 2017
Introduction to Relational Model
Recitation 1
Solution of Recitation 1
15 Sept 2017
Relational Algebra
Recitation 2
Solution of Recitation 2
22 Sept 2017
SQL
Recitation 3
Solution of Recitation 3
Intro to CSD's Oracle 12c Server
28 Sept 2017
SQL
Recitation 4
Solution of Recitation 4
5 Oct 2017
SQL
Recitation 5
Solution of Recitation 5
12 Oct 2017
SQL triggers and views
Recitation 6
Solution of Recitation 6
19 Oct 2017
Stored procedures/functions and mid-term review
Recitation 7
Solution of Recitation 7
26 Oct 2017
Transactions, Concurrency Control & Deadlocks in Oracle
Recitation 8
Solution of Recitation 8
TranDemo1.java
TranDemo2.java
recitation-db.sql
2 Nov 2017
Normalization
Recitation 9
Solution of Recitation 9
9 Nov 2017
ER Design
Recitation 10
Solution of Recitation 10
ER-2-Relational
16 Nov 2017
Hashing
Recitation 11
Solution of Recitation 11
30 Nov 2017
B+ Trees & Serializability
Recitation 12
Solution of Recitation 12
7 Dec 2017
Recovery and Final Exam Review
Recitation 13
Solution of Recitation 13
Copyright
Panos K. Chrysanthis
© 2017
Last updated on December 9, 2017 at 14:33:37 EST