Q.2 a, b,c,d

have 100 tuples and 200 tuples, respectively. (a) What are the minimum and maximum possible number of tuples in the resulting relation instance of RMS (b) What is your answer to the above question if it is given that attribute A is a key for R. (c) When attribute A is a key for R and A is a foreign key for S referencing R. Q.2 [16 pts, 4 pts each] Given that an instance of relation R(A, B) contains the tuples {(1,2).(2,3),(3,1)} and an instance of relation S(B, C) contains the tuples {(1,2).(1.3).(2.3),(2,1)). Provide the results (both the schema and the set of tuples) of the following Relational Algebra operations: (a) RXS (b) RDS (c) R Mascs (d) RMAS 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