Write SQL queries for the Books database (discussed in Section 17.3) that perform each of the following tasks:

Question

a) Add a new author to the Authors table.
b) Add a new title for an author (remember that the book must have an entry in the AuthorISBN table). Be sure to specify the publisher of the title.
c) Add a new publisher.

Answer 1

a) INSERT INTO Authors (FirstName, LastName)

VALUES ('Sue', 'Fari').
b) First, insert a value into the Titles table by using the following command:
INSERT INTO Titles (ISBN, Title, EditionNumber, Copyright,
PublisherID, ImageFile, Price)
VALUES ('5555555555', 'Technical Editing', '1', 2001,
1, ’tte.png’, 49.99).
Then, insert a value into the AuthorISBN table by using the following command:
INSERT INTO AuthorISBN (ISBN, AuthorID)
VALUES ('5555555555', 8).
c) INSERT INTO Publishers (PublisherID, PublisherName)
VALUES (3, 'Technical Publishing Company').