Write the following SQL statements in Microsoft Access by using the Books database from Week 2 Assignment 2. Once complete, copy and paste the SQL statements in a Microsoft Word document:
Write SQL statements:
- To update the publisher name from READ WITH US to READ FOR US
- To verify the updated name field for the publisher with ID 6
- To make the following updates to the Publisher table (be careful with WHERE):
- Make Contact=”John Travolta” for publisher with ID number 4
- Make Phone=888-999-7777 for TEXT AND MORE
- To list the customer numbers and names of all individuals who have purchased books in the information systems category
- To identify the book written by an author with the last name Cain. Perform the search by using the author name
- To produce a list of all the customers who live in the state of Indiana and have ordered books on information systems
- To display a list of all the books in the Books table. If a customer has ordered a book, list the corresponding order number and the state in which the customer resides
- To identify the authors of the books ordered by Sheila Smith. Perform the search by using the customer name
- To list the customer numbers and names of all the individuals who have purchased books in the children category
- To add the following items to the Books table:
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 |
Corey 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 |
- To delete the last record added
- To update the name Susan Smythe to Susan Smythe-Brown
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!
NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.