Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is an SQL problem BKNO TITLE Casebook Of Sherlock Holmes, The Red Badge Of Courage, The Turn of the Screw Book List YEAR PRICE

This is an SQL problem

image text in transcribed

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 5 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 Los Angeles, Wallach, Ira 1940- Hopalong-Freud & Other Parodies Peterkin Papers, The CA 64 1963 6.75 Dover Los Angeles, Hale, Lucretia 65 Last Of The Peterkins, The 1965 5.50 Dover Los Angeles, Hale, Lucretia CA 1925- 1985 1925- 1985 1930- 2005 1950- 70 New York, NY Vandercook, John Black Majesty: Life of Christop Book Of The Dun Cow, 1952 9.00 Pocket Books 1979 8.50 Pocket Books 75 New York, NY Wangerin, Walter The 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions