• 
  
  
  

    

2) Consider the tables given below. Table Name: Vegetables (V) Veg_ID Veg_Name Veg_Qty 1 2 4 1 2 3 Cucumber 4 Carrot Tomato Brinjal Table Name:Suppliers (S) Veg Supp SupplierName lierID 10 boxes 20 boxes 24 packets 2 5 boxes African Traders Veg_Price Veg SupplierID 3 1.5 2.5 ABC Incorporation LLC. Mr. Syed Chummus Vegetable Ms. Lilli Suppliers LLC. 1 1 3 ContactName 2 Farm Fresh Vegetables Mr. Ahmed LLC Vegetable Mr. Mogambo Address Al-Rusayl P.O. Box 786, 18th Street. Madinat Qaboos November City Muscat Suhar Muscat Sultan Muscat b. Convert the following Relational Algebra expressions to SQL statements (Note: 'V' refers to table Vegetable, 'S' refers to table Supplier): i. PROJECTveg_IDSELECT SupplierID=1 OR supplierID=2 OR supplieriD-3 OR supplierID=4(V) PROJECTveg_ID, Veg_Name SELECTveg Price>=1 and Veg_price