Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Write the following SQL statements in Microsoft Access by using the Books databa

ID: 3549504 • Letter: W

Question

Write the following SQL statements in Microsoft Access by using the Books database. Once complete, copy and paste the SQL statements in a Microsoft Word document:

Write SQL statements:



ISBN Title Author PubDate Cost Retail Category PubID 1234567890 A Good Book John Jeffries 10/11/2005 13.5 15.00 Non-Fiction 7 2314569874 Trains for Everyone Cory Berkey 12/15/2011 10.25 25.25 Children 8 1598745682 Eating In Susan Smythe 09/09/2012 20.00 30.50 Cooking 6 99954123654 Another Vampire Story Ann Oats 09/05/2010 11.23 13.52 Fiction 4 1025874159 Databases are Fun! Tony Stevens 01/01/2013 4.12 5.23 Information Systems 9

Explanation / Answer