CIS376 Week 9 Lab 27, 28, and 29 creating views

INSTRUCTIONS: • LAB 27: Creating Views Prior to starting this lab, be sure you have done the following: a. Read Skill 3.1 in the textbook b. Watched Videos 26 and 27 in CBT Nuggets c. Familiarize yourself with the SQL commands in the textbook and videos • There are multiple parts to this lab, be sure to clear all the SQL before completing the next part. • Sign each lab part. The first line in the SQL Window must be a comment with your Name, Student ID, and Lab number. The following is an example: • For each part of the lab, you will be required to take a screen shot of the SQL window and result pane. If there are more results than fill the screen only capture the initial results. The following is an example of what is expected: Part 1 Using the AdventureWorks database and the Production schema create a view that returns Name from the Products table, Name from the ProductCategory table, Name from the ProductSubCategory table, and Quantity from the ProductInventory table. Use appropriate aliases for the columns. Inspect the tables to determine the join conditions. Take a screen shot of the SQL windows and results and paste it here. INSTRUCTIONS: • Part 2 Write a query to select rows from the above view returning only rows where the name in the ProductSubCategory table contains ‘bikes’. Take a screen shot of the SQL windows and results and paste it here. Part 3 Alter the view created in Part 1 to include the ListPrice from the Products table and only returns rows with a ListPrice greater than 2000 .....................................................continued.............................................