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