Based on the three tables and the attributes below, answer the question for Requirement A and write SQL commands for Requirements B to E to retrieve the data from the database.

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.

Inventory Salesltems Sales InventoryID Name BeverageType Caffeinated Flavored PurchasePrice InvoicelD InventoryID Quantity UnitPrice InvoiceID InvoiceDate OrderDate CustomerID EmployeeID CustomerPO OO Inventory Salesltems Sales InventoryID Name BeverageType Caffeinated Flavored PurchasePrice InvoicelD InventoryID Quantity UnitPrice InvoiceID InvoiceDate OrderDate CustomerID EmployeeID CustomerPO OO