Task 4: Consider the tables given below and write the relational Algebra for the following tasks: Table Name: Products \begin{tabular}{|1|1|1|1|1|} \hline Productid & Product Name & Unit & Price & Supplierld \hline 1 & Chais & 10 boxes $\times 20$ bags & 18 & 1 \hline 2 & Chang & $24-12$ oz bottles & 19 & 1 \hline 3 & Aniseed Syrup & $12-550 \mathrm{ml}$ bottles & 10 & 1 W Thline 4 & Chef Anton's Cajun Seasoning & $48-602$ jars & 22 & 2 \hline \end{tabular) \begin{tabular}{|1|1|1|1|1|} \hline Supplierid & SupplierName & ContactName & Address & City \hline 1 & Exotic Liquid & Charlotte Cooper & 49 Gillbert St. & Londona \hline 2 & New Orleans Cajun Delights & Shelley Burke & P.O. Box 78934 & New Orleans \hline 3 & Grandma Kelly's Homestead & Regina Murphy & 707 Oxford Rd. & Ann Arbor \hline 4 & Tokyo Traders & Yoshi Nagase & $\begin{array}{111}9-8 & \text { Sekimai } \text { Musashino-shi } &\text { Tokyo }\end{array}$ \hline \end{tabular) A. Write the Relational algebra for the following questions. 1. Find all the information of products whose price is from 15 to 25 inclusively. ii. Find the lowest price of products for each supplier ID. iii. Find I ID, name and address of suppliers whose city is Tokyo. B. Convert the following SQL statements to Relational Algebra expressions : 1. Select * From Products Where Supplierid in $(1,2,3)$; ii Select Productio, ProductName From Products Where Price between 10 and 20 ; CS.VS.964