Course: Database Management System (Dbms) Please solve it correctly.

Given the two relations: Book (ISBN, title, page count, pubName FK ref (publisher)) Publishers (pubName, city, state). (a) [03 points] Write the SQL creation statement for a view named Bookcities. It should have the title and publishing city of every book. (b) [03 points] Given the following SELECT statement: SELECT b.ISBN, b.title, b.page count FROM Books b WHERE title 'sZZZZZz'; Which column of Books could be made an index to make this query run faster? Also write SQL query to create that index