Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

First you define a stored procedure in university DB named deptInfo. This procedure takes department name as input, and returns the number of instructors in

image text in transcribed

First you define a stored procedure in university DB named deptInfo. This procedure takes department name as input, and returns the number of instructors in the department, the total salary amount, and the budget of the department. In other words, deptInfo () has one input parameter and three output parameters. Test this procedure in MySQL Workbench to make sure it functions properly. Next, your application program calls the procedure and asks the user to enter a department name, and the program should return the number of instructors, the total salary amount and the budget, respectively. Here is a snapshot of the sample output. Please enter the department name : Comp. Sci. Comp. Sci. Department has 3 instructors. Comp. Sci. Department has a total salary of $232000.0 Comp. Sci. Department has a budget of $100000.0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microsoft Visual Basic 2005 For Windows Mobile Web Office And Database Applications Comprehensive

Authors: Gary B. Shelly, Thomas J. Cashman, Corinne Hoisington

1st Edition

0619254823, 978-0619254827

More Books

Students also viewed these Databases questions

Question

What are the objectives of performance appraisal ?

Answered: 1 week ago

Question

State the uses of job description.

Answered: 1 week ago