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 66 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
Great answer, keep it coming :)

aliotak

  • Member
  • Posts: 326
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

There are more nerve cells in one human brain than there are stars in the Milky Way.

Did you know?

Drying your hands with a paper towel will reduce the bacterial count on your hands by 45–60%.

Did you know?

Many people have small pouches in their colons that bulge outward through weak spots. Each pouch is called a diverticulum. About 10% of Americans older than age 40 years have diverticulosis, which, when the pouches become infected or inflamed, is called diverticulitis. The main cause of diverticular disease is a low-fiber diet.

Did you know?

Allergies play a major part in the health of children. The most prevalent childhood allergies are milk, egg, soy, wheat, peanuts, tree nuts, and seafood.

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates’s recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Basic features of the function of many excretory systems. Basic features of the function of many excretory systems.
Extended Objects Create a Focal Plane Extended Objects Create a Focal Plane
Rocking the leg to create rotation in the hip joint. Rocking the leg to create rotation in the hip joint.
Validation of the genetic code by amino acid sequence analysis of T4 phage lysozyme mutants Validation of the genetic code by amino acid sequence analysis of T4 phage lysozyme mutants
The Genetic Code The Genetic Code
Major features of human genome Major features of human genome
Video: Causes of Angina

For a complete list of videos, visit our video library