(Turn in word document, including SQL commands and Screen shots from mySQL)

(Turn in word document, including SQL commands and Screen shots from mySQL)

• (Turn in word document, including SQL commands and Screen shots from mySQL)

Write SQL queries for the books database  that perform each ofthe following tasks:

a) Select all authors from the Authors table with the columns in the order lastName,

firstName and authorID.

b) Select a specific author and list all books for that author. Include the title, year and

ISBN number. Order the information alphabetically by title.

c) Add a new author to the Authors table.

d) Add a new title for an author (remember that the book must have an entry in the

AuthorISBN table).

Some suggestions on installing Apache and setting up database file in mySQL are attached.

"96% of our customers have reported a 90% and above score. You might want to place an order with us."