Question: please solve section (a) and section (b) as soon as possible 2) Consider the tables given below. Table Name: Vegetables (V) Veg_ID Veg_Name Vez Qty

please solve section (a) and section (b) as soon as possible
please solve section (a) and section (b) as soon
please solve section (a) and section (b) as soon
2) Consider the tables given below. Table Name: Vegetables (V) Veg_ID Veg_Name Vez Qty Veg_Price Veg Supplieri 1 Cucumber 10 boxes 3 Carrot 24 packets 2 1 1 Nm 3 Tomato 20 boxes 1.5 3 4 4 Brinjal 5 boxes 2.5 2 Table Name:Suppliers (5) Contact Name Address City Veg_Supp SupplierName lier 1 ABC Incorporation LLC. Mr.Syed Al-Rusay! Muscat 2 P.O. Box 786, Suhar Chummus Vegetable Ms. Lilli Suppliers LLC Farm Fresh Vegetables Mr. Ahmed LLC 3 November Muscat 18 Street 4 African Traders Vegetable Mr. Mogambo Sultan Muscat Madinat Qaboos a. Write the relational Algebraic expressions for the following tasks and explain the symbols used in the representation Find all the information of vegetables whose price is from 15 to 2 inclusively . Find the number of suppliers in each city. i. Find ID and name of suppliers whose city is Muscat. iv. Display the name of supplier who supplies carrot Display the price of the most expensive vegetable b. Convert the following Relational Algebra expressions to SQL statements: PROJECT SELECT por 1,2A/ PROJECT. SELECT 2 (V) SELECT (V) PROJECT SELECT a.ram (Vx5) Veg Foung_chi (V iv. V. a. Write the relational Algebraic expressions for the following tasks and explain the symbols used in the representation i. Find all the information of vegetables whose price is from 1.5 to 2 inclusively. ii. Find the number of suppliers in each city. ii. Find ID and name of suppliers whose city is Muscat. iv. Display the name of supplier who supplies carrot Display the price of the most expensive vegetable V. Mas n2 F b. Convert the following Relational Algebra expressions to SQL statements: 1. PROJECT SELECT supplieri in (1.234|(V) il. PROJECTve8_10. vor. Name SELECTV.Price between 1 and 2 (V) ill. SELECTVOL. Name LIKE (V) PROJECTS.name SELECTyvek_suppliers veg_supplierit and veg_name'carrot (V x S) Veg_supplierio Fcount(Veg_aty (V) iv. 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 General Management Questions!