Not programming

Homework 2, Relational Algebra H Instructions: Hand-writen answers are acceptable. Be clear and to the point According to the four tables in the following, use appropriate relational algebra to derive the answers. EMPLOYEES PLANS - ECode EName 101 Andy 102 Betty 103 Cindy 104 David 105 Ellen Code YrService PCodePDesc 2 25 14 17 Term Life Stock Option Long-Term Disability Dental Insurance JOBS BENEFIT PCode Faculty Staff Administrator 101 101 102 102 102 103 103 105 2 Write step-by-step relational algebra to find... I. ECode and EName of employees whose job description are 'Staff with over 20 years of service. 2. ECode and EName of employees of employees who have 'Dental Insurance' benefit. 3. ECode and EName of employees whose job description is Staff and who has 'Stock Option' benefit. 4. ECode of employee(s) who do NOT have any benefit plan