Based on the three tables and the attributes below, answer the question for Requirement A and...

      

Transcribed Image Text:

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. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoiceID Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) InvoicelD InvoiceDate OrderDate CustomerID EmployeelD CustomerPO Required A Required B Required C Required D Required E How many sales transactions were made in March, 2017? SELECT COUNT InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY 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. Salesltems Sales Inventory V InventoryID V InvoicelD 8 InventoryID 8 InvoiceID Name InvoiceDate OrderDate Quantity UnitPrice BeverageType Caffeinated CustomerID Flavored EmployeelD PurchasePrice 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. 81 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required B What are the foreign keys in the Sales table? (Indicate your answers by selecting an "X" next to the applicable amounts.) InvoicelD InvoiceDate OrderDate CustomerID EmployeelD CustomerPO Required A Required B Required C Required D Required E How many sales transactions were made in March, 2017? SELECT COUNT InvoicelD FROM Sales WHERE InvoiceDate BETWEEN #3/1/2017# AND #3/31/2017# Required A Required B Required C Required D Required E Which sales transactions were made by the employee whose ID is 'S203 SELECT FROM Sales WHERE EmployeelD 'S2038' Required A Required B Required C Required D Required E List the inventory items with purchase price larger than $6,500. SELECT InvoicelD InvoiceDate FROM Sales WHERE PurchasePrice > 6500 Required A Required B Required C Required D Required E Write a query to find out the dollar amount of each sales transaction. SELECT SUM ([Quantity] * ]) AS Amount FROM WHERE Sales GROUP BY

Answer rating: 100% (QA)

a As per the given tables the table for sales lacks any key The table for sales ha... View the full answer