Lab 1
In the first lab we introduced the first part of the 1st Programming Assignment.
Readings
PA1 part 1
Lab 2
In our second lab we discussed about the ER model.
Readings
Tap to view slides
Tap to view exercise
Tap to view solution
Lab 3
In the third lab we discussed about Relational Algebra.
Readings
Slides
Exercises
Lab 4
In the fourth lab we practiced in some SQL queries in an online Database.
Readings
Exercise
Lab 5
In the fifth lab we discussed about the storage layer and B+ trees.
Readings
Exercises & Solutions
Lab 6
In the sixth lab we discussed about hashing. You can find the solution in the corresponding lab recording.
Readings
Exercises
Lab 7
In the seventh lab we discussed about the evaluation of relational operators.
Readings
Exercises & Solutions
Lab 8
In the eighth lab we discussed about PA2.
Lab 9
Lab 9 was a hacking session for PA1.3.
Lab 10
In Lab 10 we discussed about functional dependencies and Normal Forms.
Lab 11
In Lab 11 we discussed about Transaction Management.
Readings
Exercise & Solution
Lab 12
Lab 12 was a hacking session for PA2
Lab 13
In Lab 13 we discussed about the ARIES recovery algorithm.
Readings
Exercises & Solutions