Due September 28, 2017
Sections 3.1, 3.2, 3.3
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:
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.
- The number of pc's made by each maker
- The maximum screen size of a laptop made by E
- The average price of products made by each maker (but only if that
average price is at least 200), in descending order of price
Graduate students only -- do Exercises 3.2.3(a,b), 3.2.10(b,d), 3.3.1(a,c).