1.Consider the schema: Suppliers (sid: integer, sname: string, address: string) Parts (pid: integer, pname: string, color: string) Catalog (sid: integer, pid: integer, price: real) The keys for each relation in the schema are underlined, and the domain of each field is listed after the field name. The Catalog relation lists the prices charged for parts by Suppliers. Write the following queries in SQL. g. Using correlated subqueries, list the sids of suppliers who supply red colored parts "or" who's store are located in "Ruston City". h. List pairs of sids such that the supplier with the first sid charges more for some part than the supplier with the second sid. 2. State true or false: a. The logical query plan results in the creation of a parse tree b. Index scan is a physical query plan operator uses an index to read blocks of a data file. c. To achieve query optimization, select statements are pushed as far down the parse tree as possible to reduce the number of branches in the parse tree. d. An iterator in the physical query plan comprises of three steps (a) Open(), (b) GetNext(), (c) Close() e. To achieve query optimization, extra project statements are added near the leaves of the parse tree to reduce the size of tuples going up the tree