2. Insert into the NONGAME table the item number, description, number of units on hand, category,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2. Insert into the NONGAME table the item number, description, number of units on hand, category, and unit price from the ITEM table for each item that is not in category GME. 3. In the NONGAME table, change the description of item number DL51 to "Classic Train Set." 4. In the NONGAME table, increase the price of each item in category TOY by two percent. (Hint: Multiply each price by 1.02.) 5. Add the following item to the NONGAME table: item number: TL92; description: Dump Truck; number of units on hand: 10; category: TOY; and price: 59.95. NONGAME Column Туре Length Decimal Places Nulls Allowed? Description ITEM_NUM CHAR 4 No Item number (primary key) DESCRIPTION CHAR 30 Item description ON_HAND DECIMAL 4 Number of units on hand CATEGORY CHAR 3 Item category PRICE DECIMAL 6. Unit price 2. Insert into the NONGAME table the item number, description, number of units on hand, category, and unit price from the ITEM table for each item that is not in category GME. 3. In the NONGAME table, change the description of item number DL51 to "Classic Train Set." 4. In the NONGAME table, increase the price of each item in category TOY by two percent. (Hint: Multiply each price by 1.02.) 5. Add the following item to the NONGAME table: item number: TL92; description: Dump Truck; number of units on hand: 10; category: TOY; and price: 59.95. NONGAME Column Туре Length Decimal Places Nulls Allowed? Description ITEM_NUM CHAR 4 No Item number (primary key) DESCRIPTION CHAR 30 Item description ON_HAND DECIMAL 4 Number of units on hand CATEGORY CHAR 3 Item category PRICE DECIMAL 6. Unit price
Expert Answer:
Answer rating: 100% (QA)
Solution 2 INSERT INTO NONGAME item numberdescriptioncategoryprice SELE... View the full answer
Related Book For
College Algebra
ISBN: 978-0134697024
12th edition
Authors: Margaret L. Lial, John Hornsby, David I. Schneider, Callie Daniels
Posted Date:
Students also viewed these accounting questions
-
For each function that is one-to-one, (a) write an equation for the inverse function, (b) graph and -1 on the same axes, and (c) give the domain and range of both f and -1 . If the function is not...
-
For each function that is one-to-one, (a) write an equation for the inverse function, (b) graph and -1 on the same axes, and (c) give the domain and range of both f and -1 . If the function is not...
-
For each function that is one-to-one, (a) write an equation for the inverse function, (b) graph and -1 on the same axes, and (c) give the domain and range of both f and -1 . If the function is not...
-
Sparkle is one firm of many in the market for toothpaste, which is in long-run equilibrium. a. Draw a diagram showing Sparkles demand curve, marginal-revenue curve, average total- cost curve, and...
-
8, 2, 6, 6, 8, 3, 9, 6, 2, 3 Find the mean, median, and mode of the data.
-
Maximum temperature in a lubricant, oil is acting as a lubricant for a pair of cylindrical surfaces such as those shown in Fig. 10.4-1. The angular velocity of the outer cylinder is 7908 rpm. The...
-
Determine the shearing stress for an incompressible Newtonian fluid with a velocity distribution of \(\mathbf{V}=\left(3 x y^{2}-4 x^{3} ight) \mathbf{i}+\) \(\left(12 x^{2} y-y^{3} ight)...
-
One of Super Giants grocery stores in Pennsylvania sells, on average, 1,120 cases of Pepsi products a week with a standard deviation of 146 cases. Josh Nelson, who is the Pepsi account manager for...
-
Can you comment to these two posts of my classmates its discussion questions and i need to comment in two of them? To me, what makes someone beautiful changes in stages. My first initial perception...
-
For the data from Speciatronics, Ltd. (Prob04-09 in Ch04Data.xlsx on the Student Companion Site), the upper specification limit was USL = 5.25, and the lower specification limit was LSL = 1.75....
-
Answer the following questions. 1. You measure an angle to be 0 = 33.1 0.4. What is sin 0 dsin? (Hint: Convert to radians first.) 2. You want to create a resistance of approximately 9002 using three...
-
ou ( the learner ) to manage budget and financial plans Ms . Jones runs a private school. She intends to open a new branch in Springvale. The school is going to constitute 5 0 classrooms and couple...
-
Six-sevenths of Jesse Black's inventory was destroyed by fire. He sold the remaining part, which was slightly damaged, for nine-elevenths of its value and received $2400. (a) What was the value of...
-
Find out the degree of freedom of the following mechanisms. d
-
Suppose a, b, and c are int variables and a = 5 and b = 6. What value is assigned to each variable after each statement executes? If a variable is undefined at a particular statement, report UND...
-
In a class of 25 students, 15 were math majors, 17 were computer science majors, and 9 were dual majors in math and computer science. Part: 0 / 4 Part 1 of 4 Use the Venn Diagram tool to illustrate...
-
Vinh Thai, CEO of Dilmah Ltd, has an older brother, Rai Thai, who currently lease his property to Dilmah Ltd at a price lower than market rate. The rent on the Dilmah's premise is currently $6,000...
-
The following items were displayed in the statement of affairs for Lubbock Company: Fully secured liabilities ......... $90,000 Partially secured liabilities ....... 12,000 Unsecured liabilities...
-
For the pair of functions defined, find ( + g) (x), ( - g) (x), (g) (x), and (f/g) (x). Give the domain of each. (x) = 5x - 4, g(x) = -1/x
-
For each line described, write an equation in (a) slope-intercept form, if possible, and (b) standard form. Through (-2, 4) and (1, 3)
-
Fill in the blank(s) to correctly complete the sentence. For the following sum to be true, we must have w = ______, x = ______, y = _______, and z = _______. 5 | 1 Z. -3 10 4. || 2.
-
A circular loop of diameter \(150 \mathrm{~mm}\) is placed on a wooden table that makes angle of \(24.5^{\circ}\) with a uniform magnetic field. What must be the magnitude of the magnetic field if...
-
A square loop of side length \(1 \mathrm{~m}\) is placed on a wooden table in a uniform magnetic field of magnitude \(0.5 \mathrm{~T}\). The greatest magnetic flux through the loop is measured when...
-
An electron is moving at speed \(7.0 \times 10^{10} \mathrm{~m} / \mathrm{s}\) perpendicular to a uniform magnetic field of magnitude \(0.80 \mathrm{~T}\). (a) What is the diameter of the circular...
Study smarter with the SolutionInn App