Database question

Problem 1: (20 points) In the S(B, D, E): following three problems, assume the schemas are RA B, C, D) problems. Question 1): (a) Qi and Qa produce the same answer. (b) The answer to Qi is always contained in the answer to Qa- (c) The answer to Q2 is always contained in the answer to Qi. (d) Q1 and Qa produce different answers. Question 2) (a) Qi and Qa produce the same answer. (b) The answer to Q is always contained in the answer to Qa (c) The answer to Qz is always contained in the answer to Q1 (d) Qi and Q2 produce different answers Question 3) and 4) are based on the following E/R diagram: A2 A7 AI AS A8 E2 R2 E3 R3 Question 3): Which of the relationships is necessarily redundant? (a) R1 (b) R2 (c) R3 (d) None Question 4): When we convert it into a database scheme, which of the following relations is created? (a) R3(A1, A6) (b) R1(A1, A4) (c) R1(A1, A4, A6) (d) EZCA4, A5)