The purpose of this assignment is to master the design of stored procedures. Use Company database in...

Question

The purpose of this assignment is to master the design of stored procedures. Use Company database in XAMPP.

Create a user defined stored procedure (uspGetDeptStats) on the Company database that would accept a department name (varchar of maximum 15 character text string) and then generates the following statistics only if the given department name exists:

The firstname and the lastname of the manager of this department.

The number of employees work for this department.

The total salary of all employees work for this department.

The total number of dependents of all employees who work for this department.

The total weekly workhours of employees who belong to this department and who work on the projects that are controlled by this department.

Reference:
Sample stored procedures: uspGetEmpSalary, uspEmpHours, and uspEmpDependents
See text version of these files at C:\xampp\htdocs\course\scripts\company\storedproc
for theCompany databasewithschema,tables, anddescription

Upload the stored procedure file (uspGetDeptStats.sql) and the following declaration through Canvas:


	========================================================

	Name: _________________________

	Panther-ID: x x x -_______

	Course: COP 4710
	

	Assignment#: 3

	Due: Wed, Mar 15, 2023

	I hereby certify that this work is my own and none of      it is the work of any other person.

	Signature: ______________________

	=========================================================

Attached you will find the sample output of what the program should output

sample-output-asg3-n1rfyzgg.png

Ashutosh Sanjay · Accepted Answer

Output1:
 
Output2:
Output3:
Output4:

The purpose of this assignment is to master the design of stored procedures. Use Company database in XAMPP.Create a user defined stored procedure (uspGetDeptStats) on the Company database that would...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment