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 68 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
YES! Correct, THANKS for helping me on my review

kswal303

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

« previous next »
 

Did you know?

Nearly all drugs pass into human breast milk. How often a drug is taken influences the amount of drug that will pass into the milk. Medications taken 30 to 60 minutes before breastfeeding are likely to be at peak blood levels when the baby is nursing.

Did you know?

People with high total cholesterol have about two times the risk for heart disease as people with ideal levels.

Did you know?

Fatal fungal infections may be able to resist newer antifungal drugs. Globally, fungal infections are often fatal due to the lack of access to multiple antifungals, which may be required to be utilized in combination. Single antifungals may not be enough to stop a fungal infection from causing the death of a patient.

Did you know?

Asthma cases in Americans are about 75% higher today than they were in 1980.

Did you know?

Symptoms of kidney problems include a loss of appetite, back pain (which may be sudden and intense), chills, abdominal pain, fluid retention, nausea, the urge to urinate, vomiting, and fever.

Japanese farmers create pentagon-shaped oranges Japanese farmers create pentagon-shaped oranges
Surface Features on Titan Surface Features on Titan
Key anatomical features of Homo habilis include reduced facial size, a parabolic palate, and some br Key anatomical features of Homo habilis include reduced facial size, a parabolic palate, and some br
Start the valve adjustment procedure by first disconnecting and labeling, if necessary, all ... Start the valve adjustment procedure by first disconnecting and labeling, if necessary, all ...
Circular friction to the broad iliotibial band. The heel of the hand is used to create friction ... Circular friction to the broad iliotibial band. The heel of the hand is used to create friction ...
Explain how it can be desirable from an intertemporal perspective for a country run a current ... Explain how it can be desirable from an intertemporal perspective for a country run a current ...
Video: Pressure Flow Model Animation

For a complete list of videos, visit our video library