COMPLETE THE FOLLOWING:

3. Write statements to create a table for each new entity/table that was designed in Part I. Choose the appropriate data type for each column. Use auto number columns (AUTO_INCREMENT) for any surrogate keys. Create the tables in the database named after your username.

4. Create INSERT INTO statements to create at least two rows for each table you created in #3 above. Use the data from the Book List above.

5. Write a statement that will increase all of the book prices by 10%

6. Write a statement that will delete book 75.

7. Write statements to display the structure of all your tables.

8. Write statements to display all the records of all of your tables.

9. Write statements to delete all the records from your tables.

10. Write statements to completely remove all the tables you have created in step#3.

BKNO TITLE Casebook Of Sherlock Holmes, The Red Badge Of Courage, The Turn of the Screw Book List YEAR PRICE PUBLISHER LOCATION AUTHOR 1950 4.25 Pocket New York, NY Doyle, Sir Arthur Books Conan 1966 5.75 Dell Chicago, IL Crane, Stephen LIVED 1910- 1980 1920- 1975 1914- 1984 1920- 2010 1940- 1960 6.50 Dell Chicago, IL James, Henry 22 Pock, The New York, NY Benet, Stephen 1946 6.25 Pocket Books 1966 6.50 Dover 31 Hopalong-Freud & Other Parodies Peterkin Papers, The 64 1963 6.75 Dover Los Angeles, Wallach, Ira CA Los Angeles, Hale, Lucretia [CA Los Angeles, Hale, Lucretia CA New York, NY Vandercook, John 65 Last Of The Peterkins, The 1965 5.50 Dover 1925- 1985 1925- 1985 1930- 2005 1950- 70 Black Majesty: Life Of Christop Book Of The Dun Cow, The 1952 9.00 Pocket Books 1979 8.50 Pocket 75 New York, NY Wangerin, Walter Books BKNO TITLE Casebook Of Sherlock Holmes, The Red Badge Of Courage, The Turn of the Screw Book List YEAR PRICE PUBLISHER LOCATION AUTHOR 1950 4.25 Pocket New York, NY Doyle, Sir Arthur Books Conan 1966 5.75 Dell Chicago, IL Crane, Stephen LIVED 1910- 1980 1920- 1975 1914- 1984 1920- 2010 1940- 1960 6.50 Dell Chicago, IL James, Henry 22 Pock, The New York, NY Benet, Stephen 1946 6.25 Pocket Books 1966 6.50 Dover 31 Hopalong-Freud & Other Parodies Peterkin Papers, The 64 1963 6.75 Dover Los Angeles, Wallach, Ira CA Los Angeles, Hale, Lucretia [CA Los Angeles, Hale, Lucretia CA New York, NY Vandercook, John 65 Last Of The Peterkins, The 1965 5.50 Dover 1925- 1985 1925- 1985 1930- 2005 1950- 70 Black Majesty: Life Of Christop Book Of The Dun Cow, The 1952 9.00 Pocket Books 1979 8.50 Pocket 75 New York, NY Wangerin, Walter Books