A company has several employees. Each employee is trained on some machines, and many employees can be trained on the same machine. For each employee, the company has an ID, name, address, zone, salary, tax level, machineid, trained since date, machine maximum capacity, machine type and machine energy rating on file. More information about various fields is below.

Question:

Express this query in relational algebra. Find eid of employees who can execute Project Sanchez.

Table 1 : Employee Training Eid- employee ID, Ename - employee name, Eaddress- employee address, Ezone- zone depending on eaddress, Esalary-employee salary, Etaxlevel- tax bracket depending on esalary and ezone, Mid - Machine ID that the employee is trained on, Trained Since- Date since given employee was trained on given machine, Mcapacity - Maximum Capacity of that machine, Mtype- type of machine, Menergyrating- energy rating of machine, depending on mcapacity and mtype menergyrating A 120 Type A Note: As per convention, the underline below a field name signifies a key. eid ename eaddress ezone lesalaryetaxlevel mid trainedsince mcapacity mtype 3 Morty Smith 23 Harry Place 4200 3900 A 1 2000-01-01 5 Russell Bueno 803 Arroyo Lane 4523 3500Z 1 2011-04-03 120 Type A 5 Russell Bueno 803 Arroyo Lane 4523 3500Z 2. 2012-05-04 98 Types 3 Morty Smith 23 Harry Place 4200 3900 A 3 1999-05-03 230 Types 3 Morty Smith 23 Harry Place 4200 3900 A 4 2012-12-12 111 TypeP A C 2900F 4 2013-07-15 C 4 Frank Whitney 174 Ramsey Circle 2 Rick Astley 23 Harry Place 2300 4200 111 TypeP 30 TypeC 4100B 5 2010-04-01 B 2300 2900F 5 B 4 Frank Whitney 174 Ramsey Circle 2 Rick Astley 23 Harry Place 2019-08-01 2020-12-12 30 TypeC 110 TypeP 4200 4100B 7 B 4 Frank Whitney 174 Ramsey Circle 2300 2900F 7 2021-02-01 110 TypeP B 1 Glenda McCall 56573 Hintze Lane 4001 4000A 8 2013-07-15 99 Type A D 1 Glenda McCall 56573 Hintze Lane 4001 4000 A 9 2010-04-01 100 Types D Now, here is additional information. You will need both Table 1 and Table 2 and the related information here to solve Q5 Table 2: Project Pid- project ID, Pname- project name, Pcapacity- required capacity to execute project pid pname 2 Clark 3 Sanchez pcapacity 100 112 4 Bassham 98 7 McCall 229 9 Alt 23 The company accepts projects that are executed on machines. Each project has a required capacity. For a machine to execute a project, it must have maximum capacity >= project capacity. Machines of any type can execute any project provided it has the capacity. Note: As per convention, the underline below a field name signifies a key