Texts: Use the sample employee relation given below to answer the questions that follow
Table 1: employee relation with sample data
emp_num last_name first_name mid_initial hire_date job_code emp_years
101 Adams Peter A 7/3/2015 501
102 Lee Anna E 6/26/2004 502 19
103 Ramoras Drake F 9/3/2011 503 12
104 Miles Kirk K 1/29/2002 501 21
105 Johnson Chris K 5/29/2007 502 16
106 Mourning Alonzo D 7/11/2019 500 4
107 Smith Donald B 6/28/2008 501 15
108 Kaur Neelam 3/4/2006 501 17
109 Ho Paul W 8/4/2012 500 11
110 Gupta Lovedeep 4/2/2010 505 13
111 Stephens Sarah M 10/2/2006 506 17
112 Sisir Deepa G 11/1/2009 507 14
113 Li Simon L 7/1/2011 508 12
114 Nguyen James 6/30/2008 508 15
115 Singh Amarpreet 1/28/2006 501 17
116 Taluda Javier P 8/3/2011 510 12
117 Williams Mary G 12/11/2019 509 4
118 Wang Grace 5/3/2011 510 12
i) Write a relational algebra expression that returns employees with less than 10 years of work experience at the given employer (emp_years) (2 marks)
ii) Write a SQL statement that is equivalent to the relational algebra expression in i above (2 marks)
iii) Write a relational algebra expression that returns employee last_name, first_name, and hire_date (2 marks)
iv) Write a SQL statement that is equivalent to the relational algebra expression in iii) above (2 marks)
v) Write a relational algebra expression that returns the last_name, first_name, and emp_years for employees whose job code is either 500 or 501. (2 marks)
vi) Bonus (3 marks): Write a SQL statement that is equivalent to the relational algebra expression in v) above.
