CS 347 -- Assignment #1

SQL

Do the following problems from the Schaum SQL book. Note that SQL scripts for the Schaum book are available at http://www.cs.jmu.edu/sqldata/

1. Create an SQL script to:

solve the following problems: 1.3, 1.7, 1.10, 1.14, 1.17, 1.20
submit this script (SCRIPT1) and the SQLDeveloper output of this script as OUTPUT1.

2. Create an SQL script to:

solve the following problems: 2.1, 2.2, 2.6, 2.9, 2.16
submit this script (SCRIPT2) and the SQLDeveloper output of this script as OUTPUT2.

3. Create an SQL script to:

solve the following problems: 3.1, 3.4, 3.7, 3.9, 3.13, 3.16, 3.18, 3.22
submit this script (SCRIPT3) and the SQLDeveloper output of this script as OUTPUT3.

4. Turn in all 3 scripts and outputs, clearly labeled.

A PDF copy of the relevant pages from the Schaum SQL book is here (1.8MB).

Very brief tutorials on SQL are here and here. I will post other tutorials as I find them.