1. 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.

2. 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.

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

6. Write a statement that will delete book 75.

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

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

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

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

LIVED BKNO TITLE 2 Casebook Of Sherlock Holmes, The 4 Red Badge Of Courage, The 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 1910- 1980 1920- 1975 5 Turn of the Screw 1960 6.50 Dell Chicago, IL James, Henry 1914- 1984 22 Pock, The New York, NY Benet, Stephen 1946 6.25 Pocket Books 19666.50 Dover 1920- 2010 31 1940- Hopalong-Freud & Other Parodies Peterkin Papers, The 64 1963 6.75 Dover Los Angeles, Wallach, Ira ICA Los Angeles, Hale, Lucretia CA Los Angeles, Hale, Lucretia CA New York, NY Vandercook, John 1925- 1985 65 Last Of The Peterkins, The 1965 5.50 Dover 1925- 1985 70 1930- 2005 Black Majesty: Life of Christop Book Of The Dun Cow, The 1952 9.00 Pocket Books 1979 8.50 Pocket Books 75 New York, NY Wangerin, Walter 1950- LIVED BKNO TITLE 2 Casebook Of Sherlock Holmes, The 4 Red Badge Of Courage, The 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 1910- 1980 1920- 1975 5 Turn of the Screw 1960 6.50 Dell Chicago, IL James, Henry 1914- 1984 22 Pock, The New York, NY Benet, Stephen 1946 6.25 Pocket Books 19666.50 Dover 1920- 2010 31 1940- Hopalong-Freud & Other Parodies Peterkin Papers, The 64 1963 6.75 Dover Los Angeles, Wallach, Ira ICA Los Angeles, Hale, Lucretia CA Los Angeles, Hale, Lucretia CA New York, NY Vandercook, John 1925- 1985 65 Last Of The Peterkins, The 1965 5.50 Dover 1925- 1985 70 1930- 2005 Black Majesty: Life of Christop Book Of The Dun Cow, The 1952 9.00 Pocket Books 1979 8.50 Pocket Books 75 New York, NY Wangerin, Walter 1950