Question: plz solve this question 2) Consider the tables given below. Table Name: Vegetables (V) Veg_ID Veg_Name Veg_Qty Veg Price Veg_SupplierID 1 Cucumber 10 boxes 3

plz solve this question
plz solve this question 2) Consider the tables given below. Table Name:
Vegetables (V) Veg_ID Veg_Name Veg_Qty Veg Price Veg_SupplierID 1 Cucumber 10 boxes

2) Consider the tables given below. Table Name: Vegetables (V) Veg_ID Veg_Name Veg_Qty Veg Price Veg_SupplierID 1 Cucumber 10 boxes 3 1 2 Carrot 24 packets 2 1 3 Tomato 20 boxes 1.5 3 4 Brinjal 5 boxes 2.5 2 Table Name:Suppliers (S) Contact Name Veg Supp SupplierName lieri Address City 1 ABC Incorporation LLC. Mr. Syed Al-Rusay! Muscat N 2 P.O. Box 786, Suhar Chummus Vegetable Ms. Lilli Suppliers LLC 3 18+ November Muscat Farm Fresh Vegetables Mr. Ahmed LLC Street. 4 Vegetable Mr. Mogambo Sultan Muscat African Traders Madinat Qaboos 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 supplieri-2 OR supplierid=3 OR supplieria(V) ii. PROJECTveg 10, Veg_Name SELECTveg_prices and veg_pricec-2 (V) iii. SELECTveg. Name LIKE 'cx'(V) iv. PROJECTs.name SELECTy veg_supplier Des vegsupplier and v.veg_name'corror (V x S) ver_supplieripFcount(Veg_qty(V) V

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!