PARTI. Relational Model Consider the following relational schema: Suppliers (sid: integer, sname:str

PARTI. Relational Model Consider the following relational schema: Suppliers (sid: integer, sname:string, saddress:string) Parts (pidinteger,pame:string, pcolor:string, pmaterial:string) Catalog (sid:integer, pid:integer, cost:real, instock:real) Using this schema, write the query for the following questions: a) Find the names of suppliers who supply some red part or some green part. b) Find the id of all the suppliers who supply a part costing over $20.00 and having over 50 items on stock. c) Find the name of suppliers who supply a plastic part. d) Find the names of all suppliers that do not supply a red or blue part.

NEED HELP WITH SUCH A TASK? WE HAVE THE BEST TUTORS FOR YOU. ORDER NOW FROM 10$/PG