PT2520
Lab 10 Course Project
Purpose
In this final lab, you will apply the knowledge acquired from Units 4-9 of this course to completing a project, which will require the following skills:
Creating tables
Creating a composite key
Adding columns to an existing table
Creating a stored procedure to guard against a SQL injection attack
Granting permissions
Applying the concept of clustered indexes
Creating a non-clustered index
Creating a trigger
Executing queries to meet requirements
Project Scenario
The course project is based on the Westlake Research Hospital scenario that you have been studying throughout the course and uses the Westlake database you used for the Group A labs. To complete the project, you will need to use your copy of the SQL2008ExpVM virtual machine, as it existed at the end of the last unit (Unit 9). Your instructor will provide you with a script file named ProjectLoadData.sql, which you will use to populate the database. You will receive instructions on how to use this file in Step 10 of the Technical Steps section of this lab.
Expected Deliverables/Outcomes
Upon completion of the project, you will submit a MS Word document with the answers to the three questions integrated within the project at key points. Questions 1 & 2 are located at the end of Step 11 and Question 3 at the end of Step 12 of the Technical Steps section of this lab. This MS Word document will be named nn_Projectanswers.doc where “nn” will be changed to your initials.
You will also submit eight screen shots of specific steps of the database for the project. These eight screen shots should each be a separate file. The filename of the screen shot will take the format of nnProject_XX_X, where nn is your initial and XX_X corresponds to the Step number in the section of Technical Steps of this lab. The following are the required screen shots for submission (Substitute your initials for nn): nnProject_6 nnProject_11_2 nnProject_13 nnProject_14_1 nnProject_14_2 nnProject_14_3
Purpose
In this final lab, you will apply the knowledge acquired from Units 4-9 of this course to completing a project, which will require the following skills:
Creating tables
Creating a composite key
Adding columns to an existing table
Creating a stored procedure to guard against a SQL injection attack
Granting permissions
Applying the concept of clustered indexes
Creating a non-clustered index
Creating a trigger
Executing queries to meet requirements
Project Scenario
The course project is based on the Westlake Research Hospital scenario that you have been studying throughout the course and uses the Westlake database you used for the Group A labs. To complete the project, you will need to use your copy of the SQL2008ExpVM virtual machine, as it existed at the end of the last unit (Unit 9). Your instructor will provide you with a script file named ProjectLoadData.sql, which you will use to populate the database. You will receive instructions on how to use this file in Step 10 of the Technical Steps section of this lab.
Expected Deliverables/Outcomes
Upon completion of the project, you will submit a MS Word document with the answers to the three questions integrated within the project at key points. Questions 1 & 2 are located at the end of Step 11 and Question 3 at the end of Step 12 of the Technical Steps section of this lab. This MS Word document will be named nn_Projectanswers.doc where “nn” will be changed to your initials.
You will also submit eight screen shots of specific steps of the database for the project. These eight screen shots should each be a separate file. The filename of the screen shot will take the format of nnProject_XX_X, where nn is your initial and XX_X corresponds to the Step number in the section of Technical Steps of this lab. The following are the required screen shots for submission (Substitute your initials for nn): nnProject_6 nnProject_11_2 nnProject_13 nnProject_14_1 nnProject_14_2 nnProject_14_3