3310-spring2014-sql-assignment_4.doc

image1.jpg
ISQA 3310 – Managing the Database Environment

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.