Recitation #2

*** Partial Specification ***

This recitation will be part paper problems from chapters 13 -- 16.

It will also be part system exercise.

Students must be able to individually answer the book problems and may work in groups at most 4 students on the system part. The system part will require you to install postgresql on your laptops and then tune brainz to make query answering sub-second.

get 'em here!

I will list several queries that you must be able to answer. But let us start out with a couple as a warm up.

* List the names of the members of 'The Beatles'
* List the albums of 'The Beatles'
Please pose your queries over the views defined in

If you are unable to have super-user access to a lap-top, let me know and I will try to arrange something. Whatever you do, DO NOT run this system exercise on the school's database server. You will certainly cause a lot of unintended consequences if you (even try to) do so.