(g) (h) and (i)

(C) WA CS (d) R Discs Q.3 [80 pts, 8 pts each) Given the following relational schema: club (cid, name, city, fee) membership (cid, mid, year) member (mid, name, phone) Give a Relational Algebra expression for each of the following queries: (a) Find the id and name of the people who are a member of a club in Ankara that has a fee lower than 1000 TL (b) Find the id and name of the people who do not have membership of any club in Ankara. (C) Find the name and phone number of people who have been a member of a club in Ankara after 2015 (d) Find the name of the clubs that have at least two members. Do not use any aggregate function (e) Find the name of the people who are a member of all the clubs in Ankara having a fee higher than 1000 TL (1) Find the name of the people who are a member of all the clubs in both Ankara and Istanbul () Find the most expensive club in each city, (h) Find the total fee paid by each member of the clubs in Ankara (1) Find the number of members of each club in Ankara Find the club in each city with the maximum number of members (C) WA CS (d) R Discs Q.3 [80 pts, 8 pts each) Given the following relational schema: club (cid, name, city, fee) membership (cid, mid, year) member (mid, name, phone) Give a Relational Algebra expression for each of the following queries: (a) Find the id and name of the people who are a member of a club in Ankara that has a fee lower than 1000 TL (b) Find the id and name of the people who do not have membership of any club in Ankara. (C) Find the name and phone number of people who have been a member of a club in Ankara after 2015 (d) Find the name of the clubs that have at least two members. Do not use any aggregate function (e) Find the name of the people who are a member of all the clubs in Ankara having a fee higher than 1000 TL (1) Find the name of the people who are a member of all the clubs in both Ankara and Istanbul () Find the most expensive club in each city, (h) Find the total fee paid by each member of the clubs in Ankara (1) Find the number of members of each club in Ankara Find the club in each city with the maximum number of members