Based on the three tables and the attributes below, answer the question for Requirement A and write SOL commands for Requirements B to E to retrieve the data from the database. Inventory Inventon Name BeverageType Caffeinated Flavored Purchase Price Salesitems InvoicelD InventoryID Quantity Unit Price Sales Invoice InvoiceDate Order Date Customer Employeeld CustomerPO 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. Required A Required B Required C Required D Required E What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) Invoicel InvoiceDate Order Date lumarin Based on the three tables and the attributes below, answer the question for Requirement A and write SOL commands for Requirements B to E to retrieve the data from the database. Inventory Inventon Name BeverageType Caffeinated Flavored Purchase Price Salesitems InvoicelD InventoryID Quantity Unit Price Sales Invoice InvoiceDate Order Date Customer Employeeld CustomerPO 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. Required A Required B Required C Required D Required E What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) Invoicel InvoiceDate Order Date lumarin