Home
Syllabus
Policies & Grading
» Recording/Copyright
» Piazza
Class Schedule
Office Hours
Notes Videos & Readings
» Section I
» Section II
Recitations
Assignments
» Submit
» Project Info
FAQ
Links
Recitation Notes
(Note: please visit this page frequently as it will be updated constantly during the term)

Recitation Zoom Details

CS1555 Recitation Handouts

Dates
Subject
Handout & Scripts
Solution
Required Material
21 Aug 2020
 Introduction to DB Server and GUI PostgreSQL & DataGrip
28 Aug 2020
 SQL DDL Recitation 2 (1 slide per page)
Recitation 2 (4 slides per page)
4 Sep 2020
 Relational Model & SQL DDL Recitation 3 Solution of Recitation 3
11 Sep 2020
 Relational Algebra & SQL DDL Recitation 4
Recitation 4 SQL 		Solution of Recitation 4
18 Sep 2020
 Relational Algebra -2- Recitation 5 video
Recitation 5 class		 Solution of Recitation 5 video
Solution of Recitation 5 class
25 Sep 2020
 Basic SQL DML Recitation 6 Solution of Recitation 6
2 Oct 2020
 Advanced SQL DML and Views Recitation 7 Solution of Recitation 7
9 Oct 2020
Midterm Review Reviewed Slides (1 slide per page)
Reviewed Slides (4 slides per page)
16 Oct 2020
 Transactions, Procedures, and Functions Recitation 8
bank_db.sql		 Solution of Recitation 8
23 Oct 2020
 Triggers Recitation 9
bank_db.sql		 Solution of Recitation 9
30 Oct 2020
 Normalization & JDBC Recitation 10
jdbc_example.zip		 Solution of Recitation 10
Recitation 10 (JDBC)
6 Nov 2020
 Normalization & E-R Diagrams Recitation 11
ER-to-Relational Mapping Algorithm		 Solution of Recitation 11
13 Nov 2020
 E-R Diagrams Recitation 12 Solution of Recitation 12
20 Nov 2020
 Static and Dynamic Hashing & B+Tree Recitation 13 single slide
Recitation 13 single 4 slides		 N/A

Copyright Panos K. Chrysanthis & Constantinos Costa © 2020 Last updated on January 18, 2021 at 21:41:11 EST