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').
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
____ 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
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
What is a cost-benefit analysis (CBA) and how can it be calculated?
What will be an ideal response?