Given the following two tables where primary keys are underlined and foreign keys are marked with #:

Employee (employeeNo, empName, jobTitle)

Project (projectID, projectName, sponsor, startYear, endYear)

WorkedOn (#employeeNo, #projectID, year, month, noHours)

a) Express the following queries in Relational Algebra:

(i) List names and numbers of employees whose job is entitled "System Analyst". [1 mark]

(ii) List all ids of projects that are started in 2015 and sponsored by "Orpic". [1 mark]

b) Write the following SQL query in relational algebra:[1 mark]

SELECT e.empName, p. projectName

FROM Employee e, WorkedOn wo, Project p

WHERE e. employeeNo = wo. employeeNo AND

p. projectID = wo. projectID;

please fast i will rate you