"Aggregate Queries" Please respond to the following:
· Suppose you have been hired as an IT professional to support database reporting functionality for a Human Resources system. Compose at least two aggregate function queries that can be useful for the executives of the organization to extract summary data from a database system.
· Synthesize how aggregate functions help the organization understand employee performance. Provide an example that supports how the aggregate function is used to leverage talent within the organization. Note: The Strayer Oracle Server may be used to test and compile the SQL Queries developed.
Classmates:
· Suppose you have been hired as an IT professional to support database reporting functionality for a Human Resources system. Compose at least two aggregate function queries that can be useful for the executives of the organization to extract summary data from a database system.
If I was a senior in a Human resource area the first thing I would like to know is how many days off a person might be taking. To accomplish this I would need an aggregate function that adds up recorded days off in a separate column of the employee's record table. To recover this information the query should look like
SELECT SUM (dyoff) from emp WHERE empln=smith;
The next thing I might like to know the number of years an employee has worked for the organization so that we may reward them at 5, 10, and 20year intervals.
I believe the query should look like;
SELECT (stdte-today)=([Entered year]) from emp WHERE empln=smith;
· Synthesize how aggregate functions help the organization understand employee performance. Provide an example that supports how the aggregate function is used to leverage talent within the organization. Note: The Strayer Oracle Server may be used to test and compile the SQL Queries developed.
Aggregated functions in a database are extremely important to any organization as they can do such things as calculate employees average sales, their commission rate and any other type of numerical calculation needed to evaluate the employee's performance. Using aggregate functions you can establish qualitatively who is performing at their peak and who may need some remedial training.