MCS-274 Homework (Spring 2005)

Between the first two test - final revisions due by 12:30 on April 5th

Problem 5.12, p. 189
Problem 5.13, p. 189
Problem 5.10 part (d), version (ii) only, p. 189
Problem 5.x1: Write an SQL query to find the earliest, average, and latest year any movie in our database was made, and the total number of movies.
Problem 5.x2: Find the average number of actors per movie for the movies in our database that have at least one actor. This is already moderately challenging, but if you want further challenge, you can instead find the average over all movies, even those with zero actors.
Problem 6.1, p. 246
Problem 6.8, p. 246
Problem 6.20, p. 247
Problem 7.3, p. 265