Homework 5 (due 10/13)

We talked more about SQL, including set operations and how to implement them using the IN operator. You might want to review some Boolean logic and set theory.

Homework is due by classtime on Wednesday. Submit either a hardcopy (in class, or drop it off at the 4th floor front desk), or email it to me.

If you submit electronically, please submit a single document (word, pdf) and avoid zip-files.

1. [Henry Books]

2. [Company]

Write SQL for the following question in the company database. Run the queries, and submit the queries as well as their output.

3. [Extra Credit]

    List the names of all authors who have published only horror fiction.

Marcus Schaefer
Last updated: October 6th, 2010.