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.
- 1/10
-
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.
- 1/11
-
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