CSCE 520
Homework 4
Due September 28, 2017


Sections 3.1, 3.2, 3.3

To Submit

Undergrads and graduate students -- do Exercises 3.1.1, 3.2.1, 3.2.2(ii), 3.2.4, 3.2.10(a,c), 3.3.1(b,d), 3.3.4. Also do the following SQL exercise: Recall the database schema of Exercise 2.4.1. Write SQL queries for the following things:

  1. The number of pc's made by each maker
  2. The maximum screen size of a laptop made by E
  3. The average price of products made by each maker (but only if that average price is at least 200), in descending order of price
In each case, give your column headings reasonably descriptive names. Your queries must be correct in general, that is, they must work for any instance of the DB, not just the one presented in the book. Test your queries in Oracle SQL. Hand in to Dropbox (in a zip file) a text file with your queries and a log (spool) of your Oracle session.

Graduate students only -- do Exercises 3.2.3(a,b), 3.2.10(b,d), 3.3.1(a,c).