Labs


Slides and other material for CS460 labs.


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