sql statements 3 2
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
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!
Use Discount Code “Newclient”for a 15% Discount!”
The post sql statements 3 2 appeared first on Student Homeworks.
#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper
#Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational
