Use SQL to make the following changes to the Henry Books database (Figures 1-4 through 1-7 in Chapter 1). After each change, execute an appropriate query to show that the change was made correctly. If directed to do so by your instructor, use the information provided with the Chapter 3 Exercises to print your output. For any exercises that use commands not supported by your version of SQL, write the command to accomplish the task. Create a view named PLUME. It consists of the book code, title, type, and price for every book published by the publisher whose code is PL. a. Write and execute the CREATE VIEW command to create the PLUME view. b. Write and execute the command to retrieve the book code, title, and price for every book with a price of less than $13. 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?
Use SQL to make the following changes to the Henry Books database (Figures 1-4 through 1-7 in Chapter 1). After each change, execute an appropriate query to show that the change was made correctly. If directed to do so by your instructor, use the information provided with the Chapter 3 Exercises to print your output. For any exercises that use commands not supported by your version of SQL, write the command to accomplish the task.
Create a view named PLUME. It consists of the book code, title, type, and price for every book published by the publisher whose code is PL.
a. Write and execute the CREATE VIEW command to create the PLUME view.
b. Write and execute the command to retrieve the book code, title, and price for every book with a price of less than $13.
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?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
