A114/I111 Intro to Databases (1.5 cr.)

Fall Semester 2004

Due date

Wednesday September 15 (IN LAB)

Late policy

Try to turn everything on time, although late submissions (or re-submissions) will still be accepted.

Work policy

Working in groups is encouraged but please turn in your own version of the assignment.

Also, please make sure you read, understand, and comply with

the Computer Science Department's Statement on Academic Integrity

before turning in your assignment.

Task

Solve the Premiere Products and Henry Books Case exercises (pp. 63-66) in the yellow book.

For the QBE exercises turn in two databases (one for each) containing the queries, in OnCourse.

For the Relational Algebra exercises (p. 64) turn your answers clearly written on a piece of paper, in lab, to your instructor.

Grading

Feedback will be provided within a week, grades will be posted on-line.

Help Getting Started

Queries like the ones you need to create for Problem One and Three have been made available on Tue Sep 7.

Thus, database one and database two shown and used in class are good examples of what's needed.

(The queries presented with these two databases are those for Homework One).

For the Relational Algebra part I give an example:

List the order number, order date, customer number, and customer name for each order placed by any customer represented by the sales rep whose last name is Kaiser.

Solution to this problem (no. 4 in the Relational Algebra problem) is:

JOIN Customer, Orders, Rep
WHERE Customer.CustomerNum = Orders.CustomerNum AND
      Customer.RepNum = Rep.RepNum
GIVING One

SELECT One
WHERE LastName = 'Kaiser'
GIVING Two

PROJECT Two
OVER (OrderNum, OrderDate, CustomerNum, CustomerName)
GIVING Three

What is obtained as Three is the answer.