Create a view named NONPAPERBACK. It consists of the book code, title, publisher

Question

Create 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?

Explanation / Answer

A) Create view Nonpaperback As Select bookcode,title,publisherName,price from NonPublisher B) Select bookcode,title,publisherName,price from Nonpaperback where price

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.