Give your definition of a stored procedure. Based on the Academic Database, identify and describe a scenario where it would be necessary to use a stored procedure. Your answer should be addressed in 100 to 150 words.