Based on the three tables and the attributes below, answer the question for Requirement A and...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
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
Related Book For
Organizational Behavior Key Concepts, Skills & Best Practices
ISBN: 978-0078137204
5th edition
Authors: Angelo Kinicki, Mel Fugate
Posted Date:
Students also viewed these accounting questions
-
Based on the three components underlying attitudes, what is your attitude toward the president of the United States?
-
Choose a U.S.-based company (General Electric) that has subsidiaries in foreign countries. Access the companys most recent Form 10-K. Instructions: Prepare a report based on the following...
-
This exercise is based on the three Presentation Layer ER diagrams that follow. a. Describe what is reflected by the entity types and relationship types in Presentation Layer ER diagram number 1. In...
-
A car is initially travelling at 3 0 m / s , which is above the speed limit . The driver sees a speed limit trap ahead and applies the brakes for 5 seconds, causing the car to slow down by 2 m / s...
-
Some activist groups are calling for fair trade laws by which other countries would be required to meet or approach our environmental standards and provide wage and working conditions approaching...
-
Describe three situations where a combined counting and logical looping statement is needed.
-
Check Internet descriptions about the \(\$ 18\) million McKesson Robbins fraud. Summarize the fraud scheme and describe how it was uncovered.
-
Kozma Companys chart of accounts includes the following selected accounts. 101 Cash ............... 401 Sales Revenue 112 Accounts Receivable ........ 414 Sales Discounts 120 Inventory ................
-
Conduct a value chain analysis for Amazon using the example within The Concept of a Company Value Chain in your text as a guide. What conclusions can you draw from your analysis?
-
Consider the following relations for a mini world of credit). COMPANY. Answer all queries in the language asked for (alternate language gets no EMPLOYEE (FName, LName, SSN, Bdate, Address, Sex,...
-
As is summarized in the frequency table below. Using the table, determine the number of values less than or equal 2 3 Frequency 2
-
The cost of the machine is $12,123. The CCA rate is 27%. After 8 years, the machine is sold for $2,177. If it is the only asset in the asset class and the tax rate is 37%, what is the TRTL? (Assume...
-
Froya Fabrikker A / S of Bergen, Norway, manufactures specialty heavy equipment for use in North Sea oil fields. The company uses a job - order costing system that applies manufacturing overhead cost...
-
For Sheridan Company, the predetermined overhead rate is 130% of direct labor cost. During the month, Sheridan incurred $136,000 of factory labor costs, of which $115,600 is direct labor and $20,400...
-
Brown Company issued $ 1 0 0 million of its 7 % bonds on April 1 , 2 0 2 4 at 8 5 ( $ 8 5 million ) plus accrued interest. The bonds are dated January 1 , 2 0 2 4 and have an effective interest rate...
-
Jurvin Enterprises is a manufacturing company that had no beginning inventories. A subset of the transactions that it recorded during a recent month is shown below. a. $76,600 in raw materials were...
-
4 Roland Company began operations on December 1 and needsassistance in preparing December 31 financial statements, includingits year-end adjustments. The Tableau dashboard is provided toassist in t 2...
-
1. Using the information from Problem 16-4B, prepare a statement of cash flows for Lim Garden Supplies Inc. using the direct method of presenting cash flows from operating activities. 2. How does Lim...
-
Does Capt. Honors's behavior fit your schema for an effective leader? Explain.
-
1. Assume you are the director of a large group of orthopedic surgeons at Geisinger Health System. You thus are responsible for transitioning the group to a team-based approach to patient care....
-
Which barriers do you think are most likely when communicating with Best Buy customers?
-
\(\frac{14}{27} \div \frac{7}{12}\) Perform the indicated operations. Reduce to lowest terms.
-
\(\frac{44}{75} \div \frac{484}{285}\) Perform the indicated operations. Reduce to lowest terms.
-
\(\left(\frac{1}{5} \div\left(\frac{3}{10}+\frac{11}{15} ight) ight) \times\left(\frac{2}{21}+\frac{5}{9} ight)-\left(\frac{8}{15} \div \frac{4}{33} ight)^{2}\) Perform the indicated operations....
Study smarter with the SolutionInn App