Given the following tables: AUTHOR (AID, FIRST_NAME, LAST_NA…
Given the following tables: AUTHOR (AID, FIRST_NAME, LAST_NAME, A_ADDRESS) BOOK (ISBN, TITLE, PUBDATE, BOOKTYPE, PRICE, AWARD, PID, AID) PUBLISHER (PID, P_NAME, P_ADDRESS, NO_BOOK_PUBLISHED) BOOK_AUTHOR(ISBN, AID, AUTHORSHIP_POSITION) Paragraph 1: You have been asked to help the marketing department sales analyst to perform data analysis. One of their key operations is to retrieve author’s first and last names, publisher’s name, author’s position in authorship, ISBN, book title, publication date, and type of book. (1) Write a SQL statement to create a database object that will allow them to not having to conduct any joins when they perform any searches on these four tables. (2) Then, use this object that you created to write a select statement that will perform the search as described in the first paragraph above. (Use the correct column names)