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.

1. List the names of the members of 'The Beatles'
2. 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.