[Solved]4 30 R B C D Two Candidate Keys One Range Superkeys R May B List Highest Normal Forms Fol Q37266279

this is design database class, please help

(4) (30%) (a) R(A,B,C,D) has two candidate keys and A is one of them. What are the range of superkeys R may have? (b)List the highest normal forms for the following relations [i] R(A,B,C,D) {A->D, B->C) [ii] R(A,B,C,D) A->D, B->CD) [ii] R(A,B,C,D) A->D, D->B) [iv] R(A,B,C,D) A->D, D->BC) [] R(A,B,C,D) A->D, D->ABC) (c) It is known that for R(A,B,C,D): 1. R has exactly 4 superkeys. 2. B and C are non-prime attributes. What are the candidate key(s)? Show transcribed image text (4) (30%) (a) R(A,B,C,D) has two candidate keys and A is one of them. What are the range of superkeys R may have? (b)List the highest normal forms for the following relations [i] R(A,B,C,D) {A->D, B->C) [ii] R(A,B,C,D) A->D, B->CD) [ii] R(A,B,C,D) A->D, D->B) [iv] R(A,B,C,D) A->D, D->BC) [] R(A,B,C,D) A->D, D->ABC) (c) It is known that for R(A,B,C,D): 1. R has exactly 4 superkeys. 2. B and C are non-prime attributes. What are the candidate key(s)?

Expert Answer

---

Answer to (4) (30%) (a) R(A,B,C,D) has two candidate keys and A is one of them. What are the range of superkeys R may have? (b)Lis… . . .