Costa > Courses > cs1555 > Labs

Labs »

Week Date Description
Material
W02 01/18/2019 Recitation 01
Objective: To practice the relational model and SQL DDL
- Working with PostgreSQL using DataGrip
W03 01/25/2019 Recitation 02
Objective: To practice ER diagrams and transforming them to relational schemas.
W04 02/01/2019 Recitation 03
Objective: To practice normalization, canonical forms, decomposing relations into BCNF and checking for lossless decompositions.
W05 02/08/2019 Recitation 04
Objective: To practice relational algebra.
W06 02/15/2019 Recitation 05
Objective: 1. To practice more relational algebra, especially aggregations, joins, and division.
2. To practice SQL queries.
W07 02/22/2019 Recitation 06
Objective: To practice more SQL queries on Postgres.
W08 03/14/2019 Recitation 07
Objectives:
1. To get started with JDBC and demonstrate transaction concurrency control on PostgreSQL
2. To practice Views
W09 03/21/2019 Recitation 08
Objectives:
1. To understand how triggers work in PostgreSQL and to practice writing triggers
W10 03/29/2019 Recitation 09
Objectives:
1. Constraint Evaluation Modes and Transactions
W11 04/05/2019 Recitation 10
Objectives:
1. Practice operations on static hashing, extendible hashing and B+-tree
W12 04/12/2019 Recitation 11
Objectives:
1. Practice Concurrency Control, Recovery