Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started