database you created above using MS Access. c. How many Projects have a Project Budget greater than $85,000. (05 Marks) d. Display the First Name, Last Name of all employees with a salary greater than...

database you created above using MS Access.


c.    How many Projects have a Project Budget greater than $85,000.
(05    Marks)




d.    Display the First Name, Last Name of all employees with a salary greater than the average salary.
(10    Marks)




e.    Find the First Name, Last Name, Department No and salary of employees who are assigned to Project N2.
(10    Marks)


f.    Find details of employees attached to the Computer Science department.
(10 Marks)










2.    Determine the Functional Dependencies that exist in the Student table given below.