Spring 2022 (22-2 or 2224)
CS 1555/2055 : Database Management Systems
Department of Computer Science
University of Pittsburgh
Home
Syllabus
Policies & Grading
»
Recording/Copyright
»
Campuswire
Class Schedule
Office Hours
Notes & Readings
Recitations
Assignments
»
Submit
»
Project Info
FAQ
Links
Recitation Handouts
(
Note:
please visit this page frequently as it will be updated constantly during the term)
Recitation Zoom Details
Dates
Subject
Handout & Scripts
Solution
14 Jan 2022
Introduction to DB Server and GUI
PostgreSQL & DataGrip Setup
Interfaces Quick Guide
N/A
21 Jan 2022
ER Diagrams
Recitation 2
Recitation 2 Solution
28 Jan 2022
Relational Model & SQL DDL
Recitation 3
SQL script
Recitation 3 Solution
4 Feb 2022
SQL DDL & Relational Algebra
Recitation 4
Recitation 4 SQL DDL
Recitation 4 Solution
11 Feb 2022
Relational Algebra
Recitation 5
Recitation 5 Solution
18 Feb 2022
Relational Algebra & SQL DML
Recitation 6
SQL script
Recitation 6 Solution
25 Feb 2022
Advanced SQL DML
Recitation 7
SQL script
Recitation 7 Solution
4 Mar 2022
Rank queries & MT review
Recitation 8
Recitation 8 SQL scipt
Recitation 8 Solution
18 Mar 2022
Normalization (finding minimal cover)
Recitation 9
Recitation 9 Solution
25 Mar 2022
Normalization
Recitation 10
Recitation 10 Solution
1 Apr 2022
Views, Temp Tables, Triggers & Modes of Evaluation
Recitation 11
Recitation 11 SQL scipt
Recitation 11 Solution
8 Apr 2022
Cursors & JDBC
JDBC guide
JDBC code Examples
N/A
15 Apr 2022
Functions, Procedures, and Cursors
Recitation 13
Recitation 13 SQL scipt
JAVA example calling a function
JAVA example calling a procedure
Recitation 13 Solution
22 Apr 2022
B+tree & Hashing
Recitation 14
Recitation 14 Supplementary
Recitation 14 Solution
Copyright
Panos K. Chrysanthis
&
Constantinos Costa
© 2021
Last updated on April 22, 2022 at 19:54:02 EST