Question: In your myPHPAdmin database: Use the correct SQL code to create a backup copy of the Products table and name it Products Backup Use
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.
Step by Step Solution
3.47 Rating (163 Votes )
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
