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