If a relation has two sets of independent attributes then A) independent redundancy will appear B) multivalued dependency redundancy will appear C) BCNF redundancy will appear D) deletion anomaly will appear The following normal form is the hardest to compute A) BCNF B) 3NF C) 2NF The following normal form eliminates all redundancies (including multivalued) A) BCNF B) 4NF C) 2NF D) None of the above Normalization should take place A) before designing an E/R diagram B) after creating the tables in the DBMS C) before entering the schema in the DBMS D) after the first query If {A, B} is the only key of R(A, B, C, D) then A) AB rightarrow C is a BCNF violation B) C rightarrow B is a 3NF violation C) {A, B, C is a superkey D) A rightarrow C If X rightarrow Y and Y rightarrow Z then the following non-trivial fd can be obtained: A) X rightarrow Z - Y B) X rightarrow Z - X C) X rightarrow Z D) X intersection Z = 0