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-secondas fast as possible.

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* How many bands are called Nirvana?
* When did Pete Best leave The Beatles?
* Names of artists that died at age 27 between 1965 and 1995?

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.

Paper Exercises: coming very soon!¶

¶

¶