MCS-243 Lab 2: Advanced SQL (January 2000)
Due: January 13, 2000, 9:00 am
This lab has the same general form as lab 1, and my expectations for
what you turn in are the same. Note that I have broken the problems
down by the reading that they correspond to. For example, the first
batch of problems, marked 1/10, should be possible without any
material from the readings for 1/11 or 1/12.
Do exercise 3.1 parts (h)-(j)
and (p). This exercise is on page 192, but you'll also need to refer
to exercise 2.5 on page 85.
Do exercise 3.5 from page 194. Note that the subselect can be a
different one than in the problem statement.
Do exercise 3.8 part (f) from page 196.
Produce a table of movies with two columns: the title of the movie,
and the number of actors who appeared in that movie.
You will receive full credit even if you omit the movies with 0
actors. However, you will get some extra credit if you find a way
to also include those movies.
Do exercise 3.8 part (l) from page 196.
- 1/12: Do exercise 3.8 parts (h) and (j) from page 196.
In part (j), you should show the table after it has been updated.
Instructor: Max Hailperin