Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

Query 1 Inventory Sale SalesInventory Item# Delivery 9 Invoice# Description Invoice# DO Date Quantity on Hand Item# Employee# Delivery# QuantitySold Customer# Date Delivered Selling Price

image text in transcribed
image text in transcribed
Query 1 Inventory Sale SalesInventory Item# Delivery 9 Invoice# Description Invoice# DO Date Quantity on Hand Item# Employee# Delivery# QuantitySold Customer# Date Delivered Selling Price Amount Time star Time of sale Time end Delivery# Employee# Field: Item# Description able: Inventory Inventory Sort Show 0 0 0 Criteria: or: The EM Supermarket offers both in-store shopping and order delivery services. An employee of the supermarket created the above query to see 'a list of the items that can be offered in the supermarket". Required: (a) What is wrong with this query design? (b) What results does the screenshot query actually produce? (c) Write a query using SQL to display "a list of the items that quantity on hand is less than 10". Note: you just need to use one sentence to answer each question; detailed explanations are not required

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Audit Process Principles Practice And Cases

Authors: Iain Gray, Louise Crawford, Stuart Manson

7th Edition

9781473760189

More Books

Students also viewed these Accounting questions