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

• the Computer Science Department's Statement on Academic Integrity

before turning in your assignment.

Turn your answers clearly written on a piece of paper, in lab, to your instructor.

For example:

• List the name of each customer that placed an order for two different parts in the same order.

A possible good answer could be:

• Orders placed are listed in the Orders table.

  That table contains the CustomerNum information for each order. But the question asks about the contents of the order so this table only would not be enough. We also need to take into account the information contained in the OrderLine table. So we first look at the OrderLine table and count how many items have been been purchased for each order. We see only orders 21610 and 21617 with two items. Checking in Orders we find that these orders had been placed by customers 356 and 608. Looking these numbers up in the Customer table we find out that the customers are Johnson's Department Store and Ferguson's and that's the answer to the query.

If you want to describe the queries using Relational Algebra (as explained in Chapter 2) that would also be acceptable, so it's up to you.