08 Normalization II

4. Multiple Choice (circle only one answer): a. Given the relation schema R(A,B,C,D,E) and the dependencies: {A,B}  {C,D,E}; A  E We can infer the following: a. A is a key for R b. {B,E} is a key for R c. {A,B} is a key for R d. None of the above b. Given the relation schema R(A,B,C,D, E) and the functional dependencies: {A}  {C,D}; D  {C}; B  E; {C,E}  A which of the following could be the primary key of R? a. {A} b. {A,B,E} c. {B,E} d. {B,D} c. Given the relation schema R(A,B,C,D,E) and the functional dependencies: {E}  {C,D}; {A,E}  B; B  A, what is the highest normal form of R? a. 1NF b. 2NF c. 3NF d. BCNF e. None of the above d. Given the relation schema R(A,B,C,D,E,F) and the dependencies: {C,D}  {A,B,E}; A  {C,D,E} We can infer the following: a. R is in 3NF b. {C,D} is a candidate key for R c. {A} is a candidate key for R d. E is a prime attribute e. F is a prime attribute f. None of the above