In your myPHPAdmin database: Use the correct SQL code to create a backup copy of the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
In your myPHPAdmin database: Use the correct SQL code to create a backup copy of the Products table and name it Products Backup • Use the correct SQL code to create a new table called CatSubCat. • Add new columns to the CatSubCat table called Cat_SubCat, Category, SubCategory • If Products.Category = "Furniture" and Products.SubCateory "Bookcases" then Cat_SubCat= "FB1" o Repeat the same logic for the remaining values • Once the new column has been completely populated, drop the Category and SubCategory columns from the Products table • Alter the Products table and create a new relationship between the Products table and CatSubCat tables based upon the Cat_SubCat column. In your myPHPAdmin database: Use the correct SQL code to create a backup copy of the Products table and name it Products Backup • Use the correct SQL code to create a new table called CatSubCat. • Add new columns to the CatSubCat table called Cat_SubCat, Category, SubCategory • If Products.Category = "Furniture" and Products.SubCateory "Bookcases" then Cat_SubCat= "FB1" o Repeat the same logic for the remaining values • Once the new column has been completely populated, drop the Category and SubCategory columns from the Products table • Alter the Products table and create a new relationship between the Products table and CatSubCat tables based upon the Cat_SubCat column.
Expert 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
-
What is the premise of an integrated framework to approaches to management?
-
For the conceptual schemata of the database, establish an environment for the execution of simple and advanced queries in Oracle. The global schemata is as below EMP (ENUM, NAME, SAL, TAX, MGR, DNUM)...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Dakota Company had net sales ( at retail ) of $ 1 4 4 , 0 0 0 . \ table [ [ , At Cost,At Retail ] , [ Beginning inventory,$ 3 3 , 3 0 0 , $ 6 5 , 6 0 0 es Dakota Company had net sales (at retail) of...
-
Two particles are created in a high-energy accelerator and move off in opposite directions. The speed of one particle, as measured in the laboratory, is 0.650c, and the speed of each particle...
-
A control break field __________. a. Always is output prior to any group of records on a control break report b. Always is output after any group of records on a control break report c. Never is...
-
Find the solution to Stokes flow past a sphere where the far-field velocity satisfies the elongational flow defined as \(v_{x}=\dot{\gamma} x, v_{y}=\) \(\dot{\gamma} y\), and \(v_{z}=-2 \dot{\gamma}...
-
According to the National Association of Colleges and Employers, the average starting salary for new college graduates in health sciences is $51,541. The average starting salary for new college...
-
Question 8 YOLF Corporation Balance Sheet - Current Year YOLF Corporation Balance Sheet (in $Millions) Assets Liabilities Current Year Current Year Current Assets Current Liabilities Cash $124...
-
Because Natalie has had such a successful first few months, she is considering other opportunities to develop her business. One opportunity is the sale of fine European juicing machines. The owner of...
-
(10%) A new package has been designed for a food material by laminating two different plastics A and B. The oxygen permeability and thickness of each plastic are PmA, 1A and Pm, B, respectively....
-
The p1,000 face value of Ayala Company bond has a coupon of 10% (paid semi-annually), matures in 4 years, and has a current price of p1,140. What is the bond's yield to maturity.
-
A company estimates 16,500 units of a new product could be sold annually over the next 8 years at a price of $23,500 each. Variable cost per unit is $19,700 and fixed costs total $31 million per...
-
The company has the following asset accounts: Book Value Fair Value Accounts receivable Inventory Land and buildings Equipment $ 70,000 $ 50,000 104,000 601,000 50,000 77,000 610,000 40,000 The...
-
The income from operations and the amount of invested assets in each division of Beck Industries are as follows: Income from Invested Assets Retail Division Commercial Division Internet Division...
-
A company has an outstanding one-year bank loan of $500,000 at a stated interest rate of 8.2 percent. The company is required to maintain a 21 percent compensating balance in its checking account....
-
Discrete mathematics -Determine the truth value of each of these statements if the domain consists of all real numbers. a) x(x3 = -1) b) 3x(x4 < x2) c) Vx((-x)2 = x2) d) Vx(2x > x) -Suppose that the...
-
On the basis of the details of the following fixed asset account, indicate the items to be reported on the statement of cashflows: ACCOUNT Land ACCOUNT NO. Balance Date Item Debit Credit Debit Credit...
-
Define the term user view as it applies to database design.
-
Under what circumstances would you not need to break down an overall design into a consideration of individual user views?
-
What is a form?
-
Kinney A.. had the following assets and liabilities on the dates indicated. Kinney began business on January 1, 2024, with an investment of 100,000. Instructions From an analysis of the change in...
-
Two items are omitted from each of the following summaries of statement of financial position and income statement data for two proprietorships for the year 2025, Greenes Goods and Solar Enterprises....
-
Listed below are some items found in the financial statements of Min-Seo Promotions. Indicate in which financial statement(s) the following items would appear. a. Service revenue. b. Equipment. c....
Study smarter with the SolutionInn App