University of Australia $($UoA$)$ is a university with $24$ departments located all across Australia. These

departments act as the work$-$space for each student and employee, with a total of $20,000$ employees

working at UoA.

You have been hired by UoA as a Database Administrator to do some data retrieval on their database. You

have been given the database schema and data, as seen below.

Page $3$ Kaplan Business School Assessment Outline

Employees$($EmployeeID$,$ DepartmentID, SalaryID, Title,

EmployeeFirstName $,$ EmployeeLastName, Gender, yearHired,

birthyear, PerformanceBonus$)$

Departments$($DepartmentID$,$ DepartmentName, Location$)$

SalaryClass$($SalaryID$,$ Salary$)$

DepartmentEmployee$($EmployeeID$,$ DepartmentID$)$

A member of the leadership team at UoA, Chris Taverly, is interested in the data stored in this database

and has asked you a variety of questions. As there are thousands of rows of data in this database, it is not

possible to find answers to these questions by eye. You are asked to use MySQL to find the answers to the

questions below.

Data Files

Once found on MyKBS$,$ you must download the following files:

Assessment$\_$Database.sql

Assessment$\_$Employee$\_$Data.sql

Assessment$\_$Data.sql