HW4: SQL
|
|
Assignment 4: SQL - 20 points Due: April, 17 2014 @1:30 pm
Objective
In this assignment you will use an online interactive SQL tutorial, called SQLZOO.net. SQLZOO.net provides a number of tutorials on various aspects of SQL – take time to explore the site before answering the homework questions, as this will be helpful to you.
In this homework, you will test your knowledge of SQL by answering a number of multiple choice questions
Tasks: To complete the tasks, first navigate to the following url: http://www.sqlzoo.net/wiki/Tutorial_Quizzes. Type, or copy and paste, your answers in Word or PDF document.
1. Click on 1. SELECT Quiz: http://www.sqlzoo.net/wiki/SELECT_Quiz
Answer the following questions: 2, 3, 5, 6 and 7
2. Go to the Nested SELECT Quiz: http://www.sqlzoo.net/wiki/Nested_SELECT_Quiz
Answer the following questions: 4 and 7
3. Go to the SUM and COUNT Quiz: http://www.sqlzoo.net/wiki/SUM_and_COUNT_Quiz
Answer the following questions: 1, 2, 3, 4, and 5
4. Go to the JOIN quiz: http://www.sqlzoo.net/wiki/JOIN_Quiz
Answer the following questions: 1, 2, 3, 4, and 5
5. Go to the SELF JOIN quiz: http://www.sqlzoo.net/wiki/Self_join_Quiz
Answer the following questions: 1, 2, and 3
Homework Submission: Post your solution file to our Blackboard Page by 1:30 p.m. on the due date under the Assignments link for HW 4. As always, submissions received 5 days after the due/date and time will receive a grade of zero.