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

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.


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').

Computer Science & Information Technology

You might also like to view...

One way to increase processing speed is to move program instructions and data from memory to the processor more quickly. To help accomplish this objective, many computers contain a block of high-speed __________.

a. ROM b. RAM c. registers d. cache memory

Computer Science & Information Technology

____ are used when a choice must be made between two or more courses of action, based on evaluation of a condition.

A. Sequence structures B. Repetition structures C. Selection structures D. Modules and functions

Computer Science & Information Technology

The option to display a value as a percentage of the whole rather than a raw calculation is found on the ________ tab of the Value Field Settings dialog box

Fill in the blank(s) with correct word

Computer Science & Information Technology

What is a cost-benefit analysis (CBA) and how can it be calculated?

What will be an ideal response?

Computer Science & Information Technology