PLAGIARISM FREE “A” WORK

he Relational Model: Advance Topics

In the following exercises use the data in the TAL Distributors database shown in Figure 2-1 (ATTACHED)

  1. Find the order number and order date for every order that contains part number XX34
  2. Find the order number and order date from every order that includes an item located in storehouse number 2.
  3. SAME AS #2 but use nested queries.
  4. Use INTERSECT. List customer number, customer name for every customer who is either represented by sales rep number 15 or who currently has orders on file (CustomerNUM in ORDERS).
  5. Use MINUS. List customer number, customer name for every customer who is either represented by sales rep number 15 or who does not have orders currently on file.