Using table definition below write SQL statement(s) to record in the database selling product number Dw11...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using table definition below write SQL statement(s) to record in the database selling product number Dw11 to customer number 148. (4) Table: customer CNUM Table: ORDERS ORDER NUM Table: orderline Table: part PART NUM AT94 21608 21610 21613 BV06 DL71 DR93 DW11 FD21 148 282 356 Ferguson's 842 All Season KV29 CNAME Al's Appliance and Sport Brookings Direct ORDER NUM PART NUM 21608 AT94 21610 DR93 ORDER_DATE 20/10/2007 20/10/2007 21/10/2007 DESCRIPTION Iron Home Gym Cordless Drill Gas Range Washer Stand Mixer Treadmill CNUM NUM ORDERED 11 1 148 356 408 CSTREET 2837 Greenway 3827 Devon 382 Wildwood 28 Lakeview QUOTED PRICE ON HAND 21.95 495 CLASS 50 HW 45 SG 21 HW 8 AP 12 AP 22 HW 9 SG CCITY Toronto ON Toronto ON Brampton ON Oakville ON CPROV PRICE 24.95 794.95 129.95 495 399.99 159.95 1390 CPCODE 33336 33321 33146 1111 Using table definition below write SQL statement(s) to record in the database selling product number Dw11 to customer number 148. (4) Table: customer CNUM Table: ORDERS ORDER NUM Table: orderline Table: part PART NUM AT94 21608 21610 21613 BV06 DL71 DR93 DW11 FD21 148 282 356 Ferguson's 842 All Season KV29 CNAME Al's Appliance and Sport Brookings Direct ORDER NUM PART NUM 21608 AT94 21610 DR93 ORDER_DATE 20/10/2007 20/10/2007 21/10/2007 DESCRIPTION Iron Home Gym Cordless Drill Gas Range Washer Stand Mixer Treadmill CNUM NUM ORDERED 11 1 148 356 408 CSTREET 2837 Greenway 3827 Devon 382 Wildwood 28 Lakeview QUOTED PRICE ON HAND 21.95 495 CLASS 50 HW 45 SG 21 HW 8 AP 12 AP 22 HW 9 SG CCITY Toronto ON Toronto ON Brampton ON Oakville ON CPROV PRICE 24.95 794.95 129.95 495 399.99 159.95 1390 CPCODE 33336 33321 33146 1111
Expert Answer:
Answer rating: 100% (QA)
Unfortunately there isnt enough context in your message to understand the question fully as it seems ... View the full answer
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these databases questions
-
(a) (b) Discuss the grounds under which a chief executive shall ipso facto cease to hold office of the chief executive. On 26 October 2022, the board of directors of Axis Cement Limited (ACL)...
-
BAYTARGE Ltd. ti. Manufactures XI and X2 type lamps. .Net profits of XI and X2 type lamps are 10 TL and 4 TL, respectively. Daily use of XI and X2 products as a result of market research It has been...
-
Given an economy with four goods: Eggs, Cotton Cloth, Yachts (fancy boats) and Apples with price elasticities of demand of -0.3, -2.5, -2.8 and -0.2 respectively, where Eggs and cotton cloth...
-
import java.util.ArrayList; import java.util.Map; import java.util.Set; import java.util.TreeMap; /* * * This class contains a map of string keys, representing professors, to an array list of...
-
The vertical displacement of a wave on a string is described by the equation y(x, t) = A sin1Bx - Ct), in which A, B, and C are positive constants. (a) Does this wave propagate in the positive or...
-
What information is provided on the Internet in addition to the stocks latest price?
-
Complete the following: Information is data which are
-
Lansing Companys 2013 income statement and selected balance sheet data at December 31, 2012 and 2013 follow. Required Prepare the cash flows from operating activities section only of the companys...
-
Please study the following capital budgeting project and then provide explanations for the questions outlined below: You have been hired as a consultant for Pristine Urban-Tech Zither, Inc. (PUTZ),...
-
As Lush UK implemented the change, how could it measure the effects of leaving and then returning to social media on the achievement of its marketing goals? Lush Fresh Handmade Cosmetics UK sells...
-
Exprese cada fecha en espaol. este ao, el ao pasado y el prximo opens in a dialog ao el ao de su nacimiento opens in a dialog 1821, el ao de la independencia de Guatemala y Honduras (de Espaa) 1776,...
-
Tan-O-Rama is a local tanning salon. Its regression output is as follows: Intercept X Variable 1 Coefficients 4,621.07 2.87 Suppose that the company charges $7.00 per tanning session. Required: 1....
-
Home has 1200 units of L and Foreign has 3600 of units of L available. Both countries can produce coffee and cloth. The unit labour requirements for coffee and cloth in Home is 4 and 2 respectively....
-
Problem 9 - 2 1 ( Algo ) Performance Report for a Nonprofit Organization [ LO 9 - 1 , LO 9 - 2 , LO 9 - 3 , LO 9 - 4 ] The Saint Lucia Blood Bank, a private charity partly supported by government...
-
After watching the video, please answer the below question. https://www.youtube.com/watch?v=RWRJLynQWnU&feature=youtu.be Are the rental scams on sites like Airbnb.com Links to an external site. or...
-
41. Sort these lists using the selection sort. a) 3, 5, 4, 1, 2 c) 1, 2, 3, 4, 5 b) 5,4, 3, 2, 1
-
What technological change did Oprah Winfrey introduce into her programming in the 2 1 st century that would not have been possible when she first went on television? What audience was she targeting...
-
A fast-food restaurant averages 150 customers per hour. The average processing time per customer is 90 seconds. a. Determine how many cash registers the restaurant should have if it wishes to...
-
In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1. (If you use a computer to complete these exercises, use a copy of the TAL Distributors database...
-
What does it mean when a data warehouse is nonvolatile?
-
What are triggers? What purpose do they serve? How do you gain the functionality of a trigger using Access 2013?
-
List the three parts which normally comprise a code of professional conduct, and state the purpose of each.
-
Explain the need for a code of professional ethics for public accountants. In which ways should the public accoun tants' code of ethics be similar to and different from that of other professional...
-
What are the four facets of independence discussed in the chapter? Explain why each is a necessary component of a public accountant's independence.
Study smarter with the SolutionInn App