Question: I need example code in MYSQL: 1. Define a view named SCRIBNER. It consists of the book code, title, type, and price for every book

I need example code in MYSQL:

1. Define a view named SCRIBNER. It consists of the book code, title, type, and price for every book published by the publisher whose code is SC.

a. Write and execute the CREATE VIEW command to create the SCRIBNER view.

b. Write and execute the command to retrieve the book code, title, and price for every book with a price of less than $15.

c. Write and execute the query that the DBMS actually executes. d. Does updating the database through this view create any problems? If so,

what are they? If not, why not?

2. Define a view named NONPAPERBACK. It consists of the book code, title, publisher name, and price for every book that is not available in paperback.

a. Write and execute the CREATE VIEW command to create the NONPAPERBACK view.

b. Write and execute the command to retrieve the book title, publisher name, and price for every book in the NONPAPERBACK view with a price of less than $20.

c. Write and execute the query that the DBMS actually executes. d. Does updating the database through this view create any problems? If so,

what are they? If not, why not?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

I need example code in MYSQL: 1. Define a view named BOOK_INVENTORY. It consists of the branch number and the total number of books on hand for each branch. Use UNITS as the name for the count of...

Create the Henry Books Database and write queries to produce the following reports. Turn in SQL commands and related output for each query. These reports refer to the Henry Books database. 1. List...

SQL code 1. Create a view named PenguinBooks. It consists of the book code, book title, book type, and book price for every book published by Penguin USA. Display the data in the view. 2. Create a...

This is to be written in SQL for MS Access. Questions) 1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12 I keep getting syntax errors and I cannot figure out why. 1. Create a view named PenguinBooks. It consists of...

1. Create a view named PenguinBooks. It consists of the book code, book title, book type, and book price for every book published by Penguin USA. Display the data in the view. 2. Create a view named...

1. Define a view named Pocket. This view should contain the book code, book title, book type, and book price for every book published by Pocket Books (code = PB) you should have 11 ecords. Using the...

3. Define a view named BOOK_INVENTORY. It consists of the branch number and number of books on hand for each branch. Use UNITS on hand. Group and order the rows by branch number. a. Write and execute...

Henry Books Case II 1. Create a view named Penguin Books. It consists of the book code, book title, book type, and book price for every book published by Penguin USA. Display the data in the view. 2....

3,4,5,6,7,8,9,10,11 name. Henry Books Case 11 1. Create a view named Penguin Books. It consists of the book code, book title, book type, and book price for every book published by Penguin USA....

question 3,4,5,6,7 please the one posted ok chegg isnt working please answr new one Henry Books Case II 1. Create a view named Penguin Books. It consists of the book code, book title, book type, and...

Jordan Company produces womens clothing. During 2010, the company incurred the following costs: Factory rent .............$425,000 Direct labor .............. 325,000 UtilitiesFactory .............

Upper structure Cab Boom Undercarriage Arm Cylinder Boom Cylinder Tracks Arm Bucket Cylinder Bucket Front Attachment The diagram shown above shows an exactor hydraulic system It is desired to design...

if the company is willing to spend 2001000 on the turbine, how much in after-tax cost savings would the company need to generate to have a NPV of zero

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

If the tax rate is 40 percent, compute the beforetax real interest rate and the after-tax real interest rate in each of the following cases. a. The nominal interest rate is 10 percent and the...

Assume that the reserve requirement is 20%. Also assume that banks do not hold excess reserves and there is no cash held by the public. The Federal Reserve decides that it wants to expand the money...

It is often suggested that the Federal Reserve try to achieve zero inflation. If we assume that velocity is constant, does this zero-inflation goal require that the rate of money growth equal zero?...