L. UOnsanin Consider the following schema and answer the following questions: Vendor (v ID: integer, v_Name: varchar, v_City: varchar) Product (p ID: integer, p_Name: varchar, p_colour: varchar)...

quickly please


Extracted text: L. UOnsanin Consider the following schema and answer the following questions: Vendor (v ID: integer, v_Name: varchar, v_City: varchar) Product (p ID: integer, p_Name: varchar, p_colour: varchar) Catalog (v ID: integer, p ID: integer, Cost: decimal, Type: varchar) a. Write the following queries in relational algebra. i. Find the names of vendors who are from 'Suhar'. ii. Find the IDs of products which are supplied at cost greater than 1000. iii. Find IDs of vendors who supplies products with blue color.


Extracted text: b. Write SQL queries for the following statements. i. Display all the product's details in the decreasing order of their cost. ii. Count and display the number of products supplied by each vendor. iii. Add the given new Product's data into the Product table. P ID P Nam P_color 2546 Picnic bag Brown T T TArial v 3 (12pt)