Question: Please help me with this question! 8. Database Security. (10 points) The following Employee table contains the records about employees' information. The database protects the
Please help me with this question!

8. Database Security. (10 points) The following Employee table contains the records about employees' information. The database protects the records with the query size restriction technique. This means for any operation such as COUNT(), SUM(), and MEAN(), no individual query operation that matches fewer than k or more than Nk will be answered. 8.1 For k=2, what are the answers of the below queries? ) SELECT SUM(Salary) FROM Employee WHERE (Sex='F' AND Position='engineer'); SELECT SUM(Salary) FROM Employee WHERE (Sex='F' AND Position='engineer' AND site='California')
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
