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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!