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 57 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

LegendaryAnswers

  • Member
  • Posts: 341
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

More than 50% of American adults have oral herpes, which is commonly known as "cold sores" or "fever blisters." The herpes virus can be active on the skin surface without showing any signs or causing any symptoms.

Did you know?

Adolescents often feel clumsy during puberty because during this time of development, their hands and feet grow faster than their arms and legs do. The body is therefore out of proportion. One out of five adolescents actually experiences growing pains during this period.

Did you know?

Looking at the sun may not only cause headache and distort your vision temporarily, but it can also cause permanent eye damage. Any exposure to sunlight adds to the cumulative effects of ultraviolet (UV) radiation on your eyes. UV exposure has been linked to eye disorders such as macular degeneration, solar retinitis, and corneal dystrophies.

Did you know?

Limit intake of red meat and dairy products made with whole milk. Choose skim milk, low-fat or fat-free dairy products. Limit fried food. Use healthy oils when cooking.

Did you know?

Inotropic therapy does not have a role in the treatment of most heart failure patients. These drugs can make patients feel and function better but usually do not lengthen the predicted length of their lives.

Leaf surface features. Leaf surface features.
Leafcutter ants carrying leaf fragments back to the nest where they will be processed to create a su Leafcutter ants carrying leaf fragments back to the nest where they will be processed to create a su
A coronary artery bypass graft (CABG) is a procedure to bypass a blocked coronary artery. The proced A coronary artery bypass graft (CABG) is a procedure to bypass a blocked coronary artery. The proced
(A) Dornier Compact Delta® lithotripsy system. Acoustic shock waves generated by the shock-wave-gene (A) Dornier Compact Delta® lithotripsy system. Acoustic shock waves generated by the shock-wave-gene
This girl’s photo illustrates the main features of fetal alcohol syndrome, including a flat nasal ... This girl’s photo illustrates the main features of fetal alcohol syndrome, including a flat nasal ...
Overhead stretch for the shoulder muscles. Lean back to create the stretch using your body weight. Overhead stretch for the shoulder muscles. Lean back to create the stretch using your body weight.
Video: The Krebs Cycle Animation

For a complete list of videos, visit our video library