SQL Statements

Please turn in via Blackboard "Assignments" Section

This week the readings include the SQL Tutorial at the W3 Schools Site. The URL for that tutorial is: http://www.w3schools.com/sql/default.asp. Please go through the tutorial through the "SQL Summary.'

This Assignment has THREE PARTS:

Part 1:

1. Take the SQL Quiz, which can be found at: http://www.w3schools.com/sql/sql_quiz.asp.
2. Take a screenshot of your "grade" on the quiz.
3. DELIVERABLE = Screenshot

Part 2:

1. On page: http://www.w3schools.com/sql/sql_tryit.asp, there is a "try it" demonstration of SQL
2. Translate the SQL statements on that page into natural language. For example, the first statement would be something like: "return all of the records from the "customers" table."
3. DELIVERABLE = document with the 4 natural language statements

Part 3:

1. Complete the following tasks using the W3 Schools SQL demo at http://www.w3schools.com/sql/sql_tryit.asp.
   1. List all of the companies located in Germany (there is a "country" field).
   2. List the companies whose contacts' names begin with the letter "P".
   3. List all of the companies in the table and the names of their contacts. Order the list by company name, alphabetically. (n.b., I only want to see the company name and the name of the contact - no other information)
   4. List all of the information for companies that have the word "de" in their address. Order the list by company name, reverse alphabetically.
2. When you give your answer, please include your SQL statement, and the output from the server. Cut and paste the returned data into an excel spreadsheet.
3. DELIVERABLE = document with the SQL statements, and data output (lists).
   

Deliverables

Probably the easiest thing for students to do will be to have an excel spreadsheet, consisting of three "worksheets," one worksheet for each part of the assignment

Grading

• 1 point each for the tasks in part 3 (4 points)
• 1 point each for the naturalized statement from part 2 (4 points)
• 2 points for scoring over 80% on the quiz; 1 point for scoring between 70 and 80% on the quiz; and 0 points for scoring lower than 70% (you may take the quiz as many times as you want)