Problem 4-18 [LO 4-3] Based on the three tables and the attributes below, write SQL commands for each question to retrieve the data from the database. Inventory InventoryID Name BeverageType Caffeinated Flavored Purchase Price Required A InvoiceID InvoiceDate OrderDate CustomerlD EmployeeID CustomerPO SalesItems Required B InvoiceID InventoryID Quantity UnitPrice No Yes Yes Yes 00 Required: a. What are the foreign keys in the Sales table? b. How many sales transactions were made in March, 2017? c. Which sales transactions were made by the employee whose ID is 'S2038' in the system? d. List the inventory items with purchase price larger than $6,500. e. Write a query to find out the dollar amount of each sales transaction. Complete this question by entering your answers in the tabs below. 1 Sales Required C Required D Required E What are the foreign keys in the Sales table? (Select "Yes" if the attribute is a foreign key in the Sales table, and "No" if it is not a foreign key.) InvoiceID InvoiceDate OrderDate CustomerlD EmployeelD CustomerPO A

Based on the three tables and the attributes below, write SQL. commands for each question to retrieve the data from the databast Required: a. What are the foreign keys in the Sales table? b. How many sales transactions were made in March, 2017? c. Which sales transactions were made by the employee whose ID is ' 52038 ' in the system? d. List the inventory items with purchase price larger than $6,500. - Write a query to find out the dollar amount of each sales transaction. Complete this question by entering your answers in the tabs below. What are the foreign keys in the Sales table? (Select "Yes" If the attribute is a foreign key in the Salas table, and "No" if it is not a foreign key.)