Solve no only .. using information in number 1

Due Date: 25" February, 2025, 11:59pm COSC 3P32 Introduction to Database Systems Winter 2025 Assignment #2 No late assignments are accepted This assignment accounts for 5% of your final grade and is worth a total of 50 marks. This assignment is to be completed individually. All of the questions in this assignment use the following database schema, in which the keys of each relation are underlined: Restaurant(rname: st ring, addr string, phone: string, stars: integer) Chef(cname. string, specialdish: string, rating: integer) CooksFor(cname: string, rname: string, salary: integer) Offers(rname: string, dishname: string, price: real) Question 1 [8 marks] For each of the following pairs of queries, explain whether or not the queries are equivalent. You must explain your answer. To be equivalent, the queries must provide the same answer for every possible set of valid data, so think very carefully about exactly what happens during evaluation. a) b) i) [2 marks] (i) Tcname((sstars4 Restaurant) CooksFor))) (ii) SELECT C.cname FROM Restauran CooksFor C WHERE R.rname = C.rname AND R.stars = 5 [3 marks] (i) Tedishname ((Trname,dishname(Gprice50 Offers)) N (Trname,dishname(Sprice50 * price 10000 GROUP BY C.cname (ii) SELECT C.cname, MAX(C.rating) FROM Chef C WHERE C.cname NOT IN F.cname FROM CooksFor F WHERE F.salary