CS 1555/2055 : Recitation Notes

CS 1555/2055 : Database Management Systems

Recitation Notes

CS1555 Recitation Handouts

DATES	SUBJECT	HANDOUT	SOLUTION	Related Material
31 Aug 2018	Introduction to Oracle Server	Recitation 1	Recitation 1 Solution	Intro to CSD's Oracle 12c Server & Oracle SQL Developer Guide
7 Sept 2018	Relational Model and SQL DDL	Recitation 2	Recitation 2 Solution
14 Sept 2018	SQL DDL (Schema Evolution)	Recitation 3	Recitation 3 Solution
21 Sept 2018	Normalization	Recitation 4	Recitation 4 Solution
28 Sept 2018	ER-Diagram	Recitation 5	Recitation 5 Solution
5 Oct 2018	Relational Algebra	Recitation 6	Recitation 6 Solution
12 Oct 2018	Relational Algebra and SQL DML	Recitation 7	Recitation 7 Solution
19 Oct 2018	Midterm Review	Recitation 8		HW3 Solution & RA Slides Set 1 & RA Slides Set 2
26 Oct 2018	More SQL DML	Recitation 9	Recitation 9 Solution	studentdb.sql
2 Nov 2018	Triggers	Recitation 10	Recitation 10 Solution	bankdb.sql
9 Nov 2018	Transaction, Procedure, Function	Recitation 11	Recitation 11 Solution
16 Nov 2018	Concurrency Control, Deadlock, View	Recitation 12	Recitation 12 Solution	TranDemo1.java & TranDemo2.java
30 Nov 2018	Recovery, Static Hashing, Extendibale Hashing	Recitation 13	Recitation 13 Solution	Devices & Files Slides
6 Dec 2018	B+ Tree, Concurrency Control, Linear Hashing	Recitation 14	Recitation 14 Solution