Assignment 2 (due 14 Feb 2012)

Workshop Exercises from Oracle SQL by Example

You should have a turnin account by now. Please submit the answers to the following questions by 11 p.m. on Tuesday (14 Feb 2012). Use the turnin system to submit your homework electronically. The problems are taken from Oracle SQL by Example.

Chapter 6, P. 283: Workshop 2 - 7
Chapter 7, P. 321: Workshop 1 - 6

You will be running your SQL queries in SQL Developer against the database that you created. The link Populating Your Database with Data gives you the necessary steps to create the tables that you need.

For the best learning experience, look at the problem statement in the book and then run your query in SQL Developer. If it does not work, try several times. When you have finished the questions save your work in a .sql file. You may later edit the file and remove the wrong answers.

We want your answers in a .sql. A .sql file is basically a text file with a .sql extension. You can save whatever you type in a worksheet in the SQL Developer in a .sql file. You can write comments in two ways:

For multi-line comments use C-style comments /* ... */
For single-line comments use two hyphens --

Your .sql file must have a header of the form:

/*
  File: Assignment2.sql

  Student's Name:

  Student's UT EID:
	 
  Course Name: CS 327E

  Unique Number: 52885

  Date Created:

  Date Last Modified:

*/

You should give the question number as a comment, followed by the SQL statement. There should be at least two blank lines between answers.

-- Chapter 6 Workshop, Ques 2:
SELECT 
FROM
WHERE