Table 1 D. Normalize the data in Table 1 attached-show the EER diagram for your final results 6. Use SQL code to create the tables you identified in the EER diagram 7. Use SQL code to show that each of the tables has been created 8. Use SQL code to enter the information displayed in Table 1 into the tables you created 9. Use SQL code to show that the information has been entered into the appropriate tables 10. Run the following queries: a. For each author name, show the book title. Your output should include author name and book title. Order the output by author name in descending order b. For each publisher, show the books they have published. Your output should include publisher name and book title. Order the output by publisher name in ascending order. c. For each author, show the publisher who has published his work. Your output should include the author's name and the publisher's name. Order the output by author's name in ascending order. d. List the title of all the books which Salinger has written. e. List the title of all the books published by publisher Vintage f. List the title of all the books and the publisher's name for all books published by Vintage, LB Books or Plume (use IN) g. List the title of the books and the publisher name for all books published by Scribner or Plume (use OR)***NOTE: you should only have four lines of output h. List the title of the book and the publisher name for all books published by Penguin and written byMorrison (use AND)