2) Consider the tables given below. Table Name: Vegetables (V) Veg_ID Veg_Name Veg_Qty 1 2 4...

• 
  
  
  

    

Transcribed Image Text:

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<=2 (V) SELECTveg Name LIKE 'C%'(V) PROJECTS.nameSELECTv veg supplierID=s.veg supplieriD and v.veg_name='carrot' (V x S) Veg_supplieriDF count(Veg_Qty) (V) ii. iii. iv. V. 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<=2 (V) SELECTveg Name LIKE 'C%'(V) PROJECTS.nameSELECTv veg supplierID=s.veg supplieriD and v.veg_name='carrot' (V x S) Veg_supplieriDF count(Veg_Qty) (V) ii. iii. iv. V.

Answer rating: 100% (QA)

f PROJECT SupplierID1 OR SupplierID2 O... View the full answer