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]

• [10pt] List all books in the categories Fiction, Mystery, Science-Fiction, and Horror.
• [10pt] List all authors who have written no mystery novels.
• [10pt] List all authors who have published books with both Random House and Fawcett Books.
• [10pt] List the titles of all books that are available at the Downtown location, but at no other location.

2. [Company]

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

• [10pt] List all employees who have both a son and a daughter.
• [10pt] List supervisors who are not managers of a department.

3. [Extra Credit]

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

Marcus Schaefer
Last updated: October 6th, 2010.