Question: Need help In the following exercise, you will use the Access Files located in the Files section of your Canvas shell. For this assignment I
Need help
In the following exercise, you will use the Access Files located in the Files section of your Canvas shell. For this assignment I do not want a MS Access file but rather a snapshot of the QBE. Also, show the result of the query after it is executed.
-Complete the Relational Algebra design for TAL Distributors exercises 1, 3, 4, 5 and 7 on page 66.
1-list the number and name of all reps.
2-list all information from the item table for item FH24.
3-list the order number, order date, customer number, and customer name for each.
4-list the number, order date, customer number, and customer name for each placed by any customer represented by the rep whose last names is campos
5- list the number and date of all orders that were placed on 10/15/2015 or that were placed by a customer whose rep number is 30.
7-list the number and date of all orders that were placed on 10/15/2015 but not by a customer whose rep number is 45.
link
https://unioncc.instructure.com/files/1309745/download?download_frd=1
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
