Q1) Consider the following relational schema for a Company: Employee (Fname, Lname, Emp_id, Bdate, Address, Gender, Salary,Super_Emp_id, D_no) Department (D_name, D_no, D_Mgr_id, Mgr_start_date ) Dept_Location(D_no, D_location ) Project...

Q1) Consider the following relational schema for a Company:

Employee (Fname, Lname, Emp_id, Bdate, Address, Gender, Salary,Super_Emp_id, D_no)

Department (D_name, D_no, D_Mgr_id, Mgr_start_date )

Dept_Location(D_no, D_location )

Project (P_name, P_number, P_location, D_no )

Works_on (Emp_id, P_no, Hours )Write the following queries in relational algebra.

a. Find the total number of female employee in the Organization, whose salary is more than 25000

b. Find the names of the employee who do not have supervisors.

c. Find the names of employees who work on all projects controlled by department No 05

d. Make a list of project numbers for projects that involve an employee whose last name is “Smith”, either as a worker or as a manager of the department that controls the project.

e. Find the total number of Employees in organization.

f. Find the names of the employees who worked more than 10 hours on project “mobile”