Question: Task 4: Consider the tables given below and write the relational Algebra for the following tasks: Table Name: Products begin{tabular}{|1|11|1|1]} hline ProductiD & Product Name

 Task 4: Consider the tables given below and write the relational

Task 4: Consider the tables given below and write the relational Algebra for the following tasks: Table Name: Products \begin{tabular}{|1|11|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 W \hline 3 & Aniseed Syrup & $12-550 \mathrm{ml}$ bottles & 10 & 1 W Thline 4 & Chef Anton's Cajun Seasoning & $48-602$ jars & 22 & 2 W \hline \end{tabular) \begin{tabular}{|1|1|1|1|1|} \hline Supplierid & Supplier Name & ContactName & Address & City \hline 1 & Exotic Liquid & Charlotte Cooper & 49 Gillbert St. & Londona Thline 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, Product Name From Products Where Price between 10 and 20 ; CS.VS.964

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!