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. Display the data in the view. 2. 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. Display the data in the view. 3. Create a view named Book Inventory. It consists of the book code and the total number of units of the book on hand at any branch. Display the data in the view. 4. Create the following indexes. If it is necessary to name the index in your DB