Use the database structure and sample data in Figure 5.10 to: a. Combine the tables to...

Use the database structure and sample data in Figure 5.10 to:

a. Combine the tables to obtain a complete record of orders and shipments. Obtain a printout of the algorithm(s) used to combine the tables and a printout of the list of these records.

b. Write a query that selects the inventory items for which there is no order. Obtain printouts of the algorithm(s) you used and a list of the selected records.

c. Select those orders that have not yet been shipped (i.e., open orders). Obtain printouts of the algorithm(s) you used and a list of the selected records.

d. Calculate the total value (price) of the inventory items that are on hand. Sort the items in descending order of value. Obtain printouts of the algorithm(s) you used and a list of the selected records.