[Solved]Cis 111 Chapter 7 Practice Lab Student Name Graded Create One Script File Action Queries L Q37291806
Cis 111 Chapter 7 Practice Lab Student Name: Graded by: You will create one script file for the action queries listed below a name>Chap7Practice.sql. Put a comment above each query Query #1. You will review your answers with to use the GuitarShop_Chap07 database. Each query is worth 1 point. nd save it as <your indicating the problem number such as – me or another student during a class session. You will need Write a Select Into statement three times that will create the following 3 tables: your initials Categories syour initials> Products <your initials Customers Now add three Drop Table statements before the Select Into statements to delete the 3 tables starting with your initials in case you need to recreate your tables Write an INSERT statement that adds this row to the syour in CategoryName:Brass 2. Code the INSERT statement so SQL Server automatically generates the value for the CategoryID column. 3. Write an UPDATE statement that modifies the row you just added to the <your initials> Categories 4. Write a DELETE statement that deletes the row you added to the syour initials> Categories table in 5. Write an INSERT statement that adds this row to the syour initials> Products table: table. This statement should change the CategoryName column to “Woodwinds”, and it should use the CategoryID column to identify the row. exercise 2. This statement should use the CategoryID column to identify the row. ProductID: CategoryID: ProductCode: ProductName Description: ListPrice: DiscountPercent:0 DateAdded The next automatically generated ID dgx 640 Yamaha DGX 640 88-Key Digital Piano Long description to come. 799.99 Today’s date/time. Use a column list for this statement. Write an UPDATE statement that modifies the product you added in exercise 5. This statement should change the Discount ercent columín from 0% to 35%. 6. 01s 111 Chapter 7 Practice Lab Show transcribed image text Cis 111 Chapter 7 Practice Lab Student Name: Graded by: You will create one script file for the action queries listed below a name>Chap7Practice.sql. Put a comment above each query Query #1. You will review your answers with to use the GuitarShop_Chap07 database. Each query is worth 1 point. nd save it as Products Categories table in 5. Write an INSERT statement that adds this row to the syour initials> Products table: table. This statement should change the CategoryName column to “Woodwinds”, and it should use the CategoryID column to identify the row. exercise 2. This statement should use the CategoryID column to identify the row. ProductID: CategoryID: ProductCode: ProductName Description: ListPrice: DiscountPercent:0 DateAdded The next automatically generated ID dgx 640 Yamaha DGX 640 88-Key Digital Piano Long description to come. 799.99 Today’s date/time. Use a column list for this statement. Write an UPDATE statement that modifies the product you added in exercise 5. This statement should change the Discount ercent columín from 0% to 35%. 6.
01s 111 Chapter 7 Practice Lab
Expert Answer
Answer to Cis 111 Chapter 7 Practice Lab Student Name: Graded by: You will create one script file for the action queries listed be… . . .
OR
