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 25 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
Wow, this really help

AISCAMPING

  • Member
  • Posts: 347
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

To maintain good kidney function, you should drink at least 3 quarts of water daily. Water dilutes urine and helps prevent concentrations of salts and minerals that can lead to kidney stone formation. Chronic dehydration is a major contributor to the development of kidney stones.

Did you know?

In 1844, Charles Goodyear obtained the first patent for a rubber condom.

Did you know?

Approximately one in four people diagnosed with diabetes will develop foot problems. Of these, about one-third will require lower extremity amputation.

Did you know?

Bacteria have been found alive in a lake buried one half mile under ice in Antarctica.

Did you know?

The Food and Drug Administration has approved Risperdal, an adult antipsychotic drug, for the symptomatic treatment of irritability in children and adolescents with autism. The approval is the first for the use of a drug to treat behaviors associated with autism in children. These behaviors are included under the general heading of irritability and include aggression, deliberate self-injury, and temper tantrums.

Amniocentesis. In this examination procedure, amniotic fluid is aspirated with a syringe that is ins Amniocentesis. In this examination procedure, amniotic fluid is aspirated with a syringe that is ins
Surface Features on Titan Surface Features on Titan
Bone Features Bone Features
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) ...
The essential features of the “Perutz mechanism” of the T-R transition in hemoglobin The essential features of the “Perutz mechanism” of the T-R transition in hemoglobin
Reengineering the Ti plasmid to create transgenic plants Reengineering the Ti plasmid to create transgenic plants
Video: Types of Transport - Uniport, Antiport and Symport (Glucose and Na+K+ Transporters)

For a complete list of videos, visit our video library