Table name: food Column Name Data Type Constraint foodID Integer Primary Key foodName Varchar Not null foodPrice Number with three decimals ExpiryDate Date SupplierID Varchar Foreign key Table name:...

 Consider the tables . and write the relational Algebra for the following tasks

i. Find all the information about products whose price is more than OMR 5

ii. Find the number of products sold by each supplier id.

iii. Find food names and their expiry dates of Suppliers who are located in ‘Muttrah’

iv. Find the food name, expiry date and supplier name of all food that has expiry date before September 25, 2021.

v. Find the names of food, whose price is between 2 and 5

Extracted text: Table name: food Column Name Data Type Constraint foodID Integer Primary Key foodName Varchar Not null foodPrice Number with three decimals ExpiryDate Date SupplierID Varchar Foreign key Table name: supplierDetails Column Name Data Type Constraint SupplicrID SupplierName varchar Primary kcy varchar Not null Location varchar Not null Should be atleast 8 digits PhoneNumber Numeric