Turn in word document, including sql
(Turn in word document, including SQL commands and Screen shots from mySQL)
Don't use plagiarized sources. Get Your Custom Essay on
Need an answer from similar question? You have just landed to the most confidential, trustful essay writing service to order the paper from.
Just from $11/Page
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.
