Premiere Products Exercises: Relational Algebra

In the following exercises, you will use the data in the Premiere Products database shown in Figure $2-1.$ In each step, indicate how to use relational algebra to obtain the desired results.

List the number and name of all sales reps.

List all information from the Part table for part FD$21.$

List the order number, order date, customer number, and customer name for each order.

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.

List the number and date of all orders that were placed on $\frac{10}{20}\frac{?}{2013}$ or that were placed by a customer whose rep number is $20.$

List the number and date of all orders that were placed on $10/20/2013$ by a customer whose rep number is $20.$

List the number and date of all orders that were placed on $10/20/2013$ but not by a customer whose rep number is $20.$