Recitation #2

*** Partial Specification ***

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

get 'em here!

I will list several queries that you must be able to answer. 

1. List the names of the members of 'The Beatles'
2. List the albums of 'The Beatles'
3. How many bands are called Nirvana?
4. When did Pete Best leave The Beatles?
5. 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!