Using the Henry Books database,update the paperback field for the book titled Black Houseto Y.You will insert 2 snips for this question.Insert a snip of the construct used to update the table: Insert your screen shot of the Books table here (be certain Black Housedisplays): Using the Henry Books database,add a new row to the AUTHORS table. The new author’s name is John Grisham.You will insert 2 snip s for this question. Insert a snip of the construct used to update the table: Insert your snip of the Authors table here showing the update: Using the Henry Books database,create a view named Paperback. It consists of the book code, book title, publisher name, and book price for every book that is available in paperback. You will insert 2 snips for this question. Insert a snip of the construct used to create this view: Run a query using this view and insert a snip of the resultset: Using the Henry Books database,write a stored procedure that will change the price of a book with a given book code. How would you call this stored procedure/function to change the price of book 0189 to $8.49?You will insert 2 snips for this question.What code did you write for this view? Insert the snip of the contents of the view SQL code here: How would you call the procedure/function:

“Since you have posted a question with multiple sub parts, we will provide the solution only to the…

Answered: Using the Henry Books database,update…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

Using the Henry Books database,update the paperback field for the book titled Black Houseto Y.

You will insert 2 snips for this question.

Insert your screen shot of the Books table here (be certain Black Housedisplays):

Using the Henry Books database,add a new row to the AUTHORS table. The new author’s name is John Grisham.

You will insert 2 snip s for this question.

Using the Henry Books database,create a view named Paperback. It consists of the book code, book title, publisher name, and book price for every book that is available in paperback.

You will insert 2 snips for this question.

Using the Henry Books database,write a stored procedure that will change the price of a book with a given book code. How would you call this stored procedure/function to change the price of book 0189 to $8.49?

You will insert 2 snips for this question.