The University of Texas

CS 327e

Fall 2001

Lab 3

Due: 2001-11-05 Monday 8.30 a.m. by email to TA.

Purpose:

a) Get familiar with translating English to SQL.

b) Use ANSI standard INNER JOIN syntax.

For this lab, develop the SQL queries in the attached lab3.mdb file:

a) Chapter 3 Problem 5

b) Chapter 3 Problem 6

c) Chapter 3 Problem 7

d) Chapter 3 Problem 8

e) Chapter 3 Problem 12

Bonus Question (20 points)
f) Chapter 3 Problem 14

As an example of the INNER JOIN syntax, the query for “Chapter 3 Problem 4” is developed in the attached lab3.mdb file.

NOTE: Using this INNER JOIN syntax is NOT a requirement. If you can write alternative SQL, that would be fine too.

Submit:

a) Rename the attached file to lab3xxxx.mdb, where “xxxx” is the last 4 digits of your SSN. After storing the queries, compress the database + zip it up, and send it as an attachment in an email to the TA.

lab3 Solution

Home Page