CS 1555/2055 : Recitation Notes

CS 1555/2055 : Database Management Systems

Recitation Notes

CS1555 Recitation Handouts

Dates	Subject	Handout & Scripts	Solution	Required Material
22 Jan 2021	Introduction to DB Server and GUI	PostgreSQL & DataGrip		N/A
29 Jan 2021	SQL DDL	Recitation 2 (1 slide per page) Recitation 2 (4 slides per page) PostgreSQL Quick Guide
5 Feb 2021	Relational Model & SQL DDL	Recitation 3	Recitation 3 Solution
12 Feb 2021	Relational Algebra	Recitation 4	Recitation 4 Solution
19 Feb 2021	Relational Algebra -2-	Recitation 5	Recitation 5 Solution
26 Feb 2021	Basic SQL DML	Recitation 6 Recitation 6 SQL Script	Recitation 6 Solution
5 Mar 2021	Advanced SQL DML and Views	Recitation 7 Recitation 7 SQL Script	Solution of Recitation 7
12 Mar 2021	Midterm Review	Recitation 8a Reviewed Slides (4 slides per page)
19 Mar 2021	Transactions, Procedures, Functions, and Triggers	Recitation 8 bank_db.sql	Solution of Recitation 8
26 Mar 2021	Triggers and Cursors	Recitation 9	Solution of Recitation 9
2 Apr 2021	Normalization & JDBC	Recitation 10 jdbc_examples.zip	Solution of Recitation 10
9 Apr 2021	Normalization	Recitation 11	Solution of Recitation 11
16 Apr 2021	E-R Diagrams	Recitation 12 ER-to-Relational (1 slide per page) ER-to-Relational (4 slides per page)	Solution of Recitation 12
23 Apr 2021	B+Tree & Concurrency Control	Recitation 13	Solution of Recitation 13 Recitation 13 Supplementary