Examine the following schema.

AUTHORS (SSN, LastName, FirstName, Address, City, State)
PUBLISHERS (PubName, Address, City, State)
SALES (StoreName, TitleID, Qty)
TITLEAUTHOR (SSN, TitleID, RoyaltyPercent)
TITLES (TitleID, Title, Type, PubName, Price, PubDate)
STORES (StoreName, Address, City, State)

Answer the following questions:

Question 1. 

Write relational algebra expressions for each of the following:
a. The first and last name of all authors.
b. The names of all publishers.
c. The names of all publishers in Chicago.
d. The title and price of business titles published by Prentice-Hall.
e. The names of stores that have not sold books.
f. The titles of all books sold by Borders bookstore.


Question 2. 

Write SQL queries in each of the following cases:
a. List all authors in Illinois. 
b. List the titles of all books.
c. New releases are books published in the current calendar year 
   (assume 2001). Write a SQL query to list new releases.
d. List Biochemistry books published by Addison-Wesley. 
e. Produce a count of stores.
f. List the titles of all books that contain the word SQL in the title.