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/10 Jan 2020
Introduction to DB Server and GUI Oracle 12c Server & SQL Developer and DataGrip
15/17 Jan 2020
SQL DDL Recitation 2 Solution of Recitation 2
22/25 Jan 2020
SQL DDL -2- Recitation 3 Solution of Recitation 3
29/31 Jan 2020
Relational Algebra Recitation 4 Solution of Recitation 4
5/7 Feb 2020
Relational Algebra -2- Recitation 5 Solution of Recitation 5
12/14 Feb 2020
SQL Recitation 6 Solution of Recitation 6
19/21 Feb 2020
Advanced SQL and Views Recitation 7 Solution of Recitation 7
26/28 Feb 2020
Midterm Review Reviewed Slides
4/6 Mar 2020
Transactions, Procedures, and Functions Recitation 8 Solution of Recitation 8
18/20 Mar 2020
Triggers Recitation 9 Solution of Recitation 9
25/27 Mar 2020
Normalization Recitation 10 Solution of Recitation 10
1/3 Apr 2020
E-R Diagrams Recitation 11 Solution of Recitation 11
8/10 Apr 2020
Static and Dynamic Hashing Recitation 12 Solution of Recitation 12
15/17 Apr 2020
B+Tree Recitation 13 Solution of Recitation 13