Use the data from the table 2-1 to create a database called Premiere Products. In each question, indicate how to use relational algebra to obtain the desired results. See image.

You have to use the program WinRDBI.

  • List the number and name of all sales rep.
  • List all information from the Part table for part number FD21
  • 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 10/20/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.
Academic Honesty!
It is not our intention to break the school's academic policy. Projects posted are only used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly fill out the form. Please provide a valid email address and we'll get back to you in less than 24 hours. We will be sending an invoice through PayPal upon confirmation. We are a non profit organization however we need an amount to keep this organization running, and to be able to complete our research and development.