Fall 2022 (23-2 or 2231) 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 » Project Info FAQ Links		Recitation Handouts (Note: please visit this page frequently as it will be updated constantly during the term) Dates Subject Handout & Scripts Solution 2 Sep 2022 Introduction to DB Server and GUI PostgreSQL & DataGrip Setup Interfaces Quick Guide Sample Queries N/A 9 Sep 2022 ER Diagrams Recitation 2 Recitation 2 Solution 16 Sep 2022 Relational Model & SQL DDL Recitation 3 SQL script Recitation 3 Solution 23 Sep 2022 Relational Algebra Recitation 4 Recitation 4 Solution Extra Query Solution 30 Sep 2022 SQL DDL & Relational Algebra Recitation 5 Recitation 5 SQL DDL Recitation 5 Solution 7 Oct 2022 SQL DML & Advanced SQL DML Recitation 6 SQL script Recitation 6 Solution 14 Oct 2022 Fall Break (No Reciation) 21 Oct 2022 Normalization Recitation 7 Recitation 7 Solution 28 Oct 2022 Relational Algebra, Normalization, Views Recitation 8 Recitation 8 SQL scipt Recitation 8 Solution 4 Nov 2022 Temp Tables & Triggers Recitation 9 Recitation 9 SQL scipt Recitation 9 Solution 11 Nov 2022 JDBC Demo & Modes of Evaluation & Functions & Procedures student db SQL script JDBC guide JDBC Code Examples Recitation 10 bank db SQL script Recitation 10 Solution 18 Nov 2022 JDBC & Cursors Rec11 SQL script JDBC Code Examples Recitation 11 Recitation 11 Solution 25 Nov 2022 TG Break (No Reciation) 2 Dec 2022 Concurrency Control & Hashing Recitation 12 Recitation 12 Solution Extendible Hashing Solution 9 Dec 2022 B+tree Recitation 13 Recitation 13 Solution
Copyright Panos K. Chrysanthis © 2022 Last updated on December 12, 2022 at 17:00:38 EST