Neco 2025 Computer Studies Question 14

The company database has two tables. The Employees table records each employee's department and salary, while the Departments table records each department's budget. The number of employees, the average salary per employee, and the budget for each department are given below:\n\n\begin{array}{c|c|c|c}\text{DeptID} & \text{Employees} & \text{Avg Salary (₦)} & \text{Budget (₦)}\\\hline\n1 & 15 & 200{,}000 & 4{,}000{,}000\\\n2 & 20 & 150{,}000 & 3{,}500{,}000\\\n3 & 10 & 180{,}000 & 2{,}500{,}000\\\n4 & 25 & 210{,}000 & 6{,}000{,}000\\\n5 & 12 & 190{,}000 & 3{,}000{,}000\\\n6 & 8 & 170{,}000 & 2{,}000{,}000\\\n7 & 20 & 160{,}000 & 4{,}500{,}000\\\n8 & 10 & 175{,}000 & 2{,}800{,}000\end{array}\n\nFor each department compute the total salary expense (number of employees \(\times\) average salary) and determine whether it exceeds \(80\%\) of the department's budget. List the DeptIDs, in ascending order, of the departments where the total salary expense exceeds \(80\%\) of the budget.