1. Normalize the data in table 1 attached – show the EER diagram for your final results
2. For each of the following steps, include screen shots of your code and results
3. Use SQL code to create the tables
4. Use SQL code to show that each of the tables has been created
5. Use SQL code to enter the information displayed in table 1 into the tables you have created
6. Use SQL code to show that the information has been entered into the appropriate tables
7. Run the following queries:
   1. 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
   2. 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.
   3. 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.
   4. List the title of all the books which Salinger has written.
   5. List the title of all the books published by publisher Vintage
   6. List the title of all the books and the publisher’s name for all books published by Vintage, LB Books or Plume (use IN)
   7. 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
   8. List the title of the book and the publisher name for all books published by Penguin and written by Morrison (use AND)

      Book_Code	Book_Title	Publisher	Author
      22	Stranger	Vintage	Camus
      13	Dreamcatcher	Scribner	King
      18	Beloved	Plume	Morrison
      37	Nine	LB Books	Salinger
      57	Catch 22	Scribner	Heller
      61	Jazz	Plume	Morrison
      69	Franny	LB Books	Salinger
      75	Fall	Vintage	Camus
      96	Grapes	Penguin	Morrison
      98	Catcher	LB Books	Salinger

Answer rating: 100% (QA)

1 CREATE TABLE authors authorname VARCHAR255 booktitle VARCHAR255 2 CREATE TABLE publishers publishe... View the full answer