Even complicated and confusing topics will be easily developed and covered if you request our help writing an essay. Place an order today!

Query and update databases using SQLValue: 15%Due date: 20-Jan-2016Return date: 17-Feb-2016Submission method optionsAlternative submission methodTaskNOTESThis assignment encourages you to use SQLite to complete the tasks listed below.The instructions listed below relate to SQLite.For guidance on how to install SQLite, watch this short YouTube video: https://www.youtube.com/watch?v=YZQuQ6jael8For guidance on how to create tables using SQLite, watch this short YouTube video: https://www.youtube.com/watch?v=Ev2JnjavvmEYou are welcome to use MySQL. The instructions for using MySQL will be placed in the Students Resources Folder.To use other packages, please seek the approval of your subject coordinator.Typing the SQL statements or the results is NOT acceptable.InstructionsFrom Resources under Main Menu in Interact 2 go to Students Resources FolderCopy sqlite3.exe and cmd.exe files from the Students Resources Folder into a folder in your machine Copy a5.txt from the Students Resources Folder into the folder in your machine where your SQLite file is located Open a5.txt in Notepad Replace yourstudentid in line .output yourstudentid.txt in a5.txt with your actual studentid i.e. for example 45446667.txt From the Command Prompt type sqlite3.exe yourstudentid.db Note: From the Command Prompt call the folder in your machine where your SQLite file is located before you type sqlite3.exe yourstudentid.db At the SQLite Command Line type .read a5.txt [to create the tables you will use to answer this assignments questions] At the SQLite Command Line type .quit Using WordPad open yourstudentid.txt [to check the tables you created exist] From the Command Prompt type sqlite3 At the SQLite Command Line type .open yourstudentid.db At the SQLite Command Line type .headers on At the SQLite Command Line type .mode column Write and run SQL statements to complete the following tasks Show all the details of the products by v_code 21344Locate the record in the vendor table that does not have a value for the attribute V_STATEFind the customers whose balance is greater than 200 but less than 300.What is the max balance?Show the names of the customers for whom we have invoices.Show the CUS_CODE of the customers for whom we DO NOT have invoices.Show the names of the customers for whom we DO NOT have invoices.Find out how many times a customer generated an invoice.List the names of the customers and how many times a customer generated an invoice.Add a new attribute (field) credithistory varchar(6) to the customer table.Update credithistory for customer '10011' to 'Bad'.Delete the employee Leighla Genkazi from the EMP table. You are required to submit: 1. The SQL statements for each query, which should be copied from your SQLite3 Command Line and pasted into your submission file2. The screenshots of the results of the SQL statements which are to be copied from your SQLite3 Command Line and pasted into your submission file immediately after you execute the SQL query. If you used an output file please submit only the output file RationaleThis assignment will assess your knowledge and ability to use SQL to query database tables and update them. It will also test your ability to write both simple and complex queries and run those queries to return the requested data.

testimonials icon
Read the section from pages 314 to 317. 1. Create a chart like the one on page 314/317 that shows important events...
testimonials icon
Program Evaluation Model 7 DQ 1 Provide an overview of the program evaluation model and health promotion theory yo...
testimonials icon
write 750 word paper in which you define right of privacy  Examine how each of these terms may apply to the following Stop...
testimonials icon
Social Responsibility of BusinessResearch the term “corporate social responsibility;” define the term and discuss its role in bus...
testimonials icon
Needed by 9pm CST TONIGHT.350 word discussion response: What have you l...
testimonials icon
 Assignment 1: Controlling or Not Controlling Your BrandTim Leberecht, the Chief Marketing Officer at NBBJ, is a co...
testimonials icon
Martin Luther was a German theologian who started protestant reformation through his publications. He promoted theology that supported the gracio...
testimonials icon
 Select a publicly traded corporation for which you would like to work or are currently working. Research the corporation on its own W...
testimonials icon
   Please reply to the following number 1,2,3 This is the question Doctoral learners commonly exert...
testimonials icon
After your monthly review of your unit’s operational budget, you find you are over your budget for medical supplies. What steps would you take to...
testimonials icon
The “disease versus non-disease” model of alcoholism continues to be an ongoing, controversial debate. In the Criminal Justice field, the que...

Other samples, services and questions:

Calculate Price

When you use PaperHelp, you save one valuable — TIME

You can spend it for more important things than paper writing.

Approx. price
$65
Order a paper. Study better. Sleep tight. Calculate Price!
Created with Sketch.
Calculate Price
Approx. price
$65