Author Question: Explain the features of the following code.CREATE PROCEDURE usp_StudentLogInstudentKey nchar(10)ASIF ... (Read 59 times)

ap345 · **on:** Jul 7, 2018

Explain the features of the following code.CREATE PROCEDURE usp_StudentLogInstu dentKey nchar(10)ASIF EXISTS(SELECT FROM studentWHERE studentKey=studentKey)BEGINSELECT studentLastNameFROM StudentWHERE Studentkey=studentKeyEND

What will be an ideal response?

Question 2

Explain how views and stored procedures could be used to help ensure the security of a database.

What will be an ideal response?

sokh · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

This code creates a stored procedure called usp_StudentLogIn. It asks for a parameter StudentKey. Next it checks to see if that studentKey exists in the student table. If it does it returns the students name.

Answer to Question 2

Views present the user with a view of the data that is appropriate to their use of the database. Views can be used to hide the underlying structure of the tables and columns. This can help prevent a disgruntled user from attacking the underlying structure. Stored procedures can be used to capture INSERTS, UPDATES, and DELETES and make sure they occur safely.