This topic contains a solution. Click here to go to the answer
« previous next »

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

ap345

  • Hero Member
  • *****
  • Posts: 537
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?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

sokh

  • Sr. Member
  • ****
  • Posts: 357
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.


ap345

  • Member
  • Posts: 537
Reply 2 on: Jul 7, 2018
:D TYSM

kusterl

  • Member
  • Posts: 315
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

The top five reasons that children stay home from school are as follows: colds, stomach flu (gastroenteritis), ear infection (otitis media), pink eye (conjunctivitis), and sore throat.

Did you know?

The eye muscles are the most active muscles in the whole body. The external muscles that move the eyes are the strongest muscles in the human body for the job they have to do. They are 100 times more powerful than they need to be.

Did you know?

Signs and symptoms of a drug overdose include losing consciousness, fever or sweating, breathing problems, abnormal pulse, and changes in skin color.

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Did you know?

Asthma occurs in one in 11 children and in one in 12 adults. African Americans and Latinos have a higher risk for developing asthma than other groups.

The Genetic Code The Genetic Code
Cushing’s syndrome. A photograph of a woman with the characteristic facial features of Cushing’s syn Cushing’s syndrome. A photograph of a woman with the characteristic facial features of Cushing’s syn
Diverse living organisms share common chemical features Diverse living organisms share common chemical features
Common structural features Common structural features
Surface Features on Europa Surface Features on Europa
The primary ignition system is used to trigger and therefore create the secondary (high-voltage) ... The primary ignition system is used to trigger and therefore create the secondary (high-voltage) ...
Video: Krebs cycle : Formation of acetyl coenzyme A and Electron transport chain

For a complete list of videos, visit our video library