If a relation has two sets of independent attributes then A) independent redunda

Question

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

Explanation / Answer

Question 12
a.Independent redundancy will apprear.

This will happen as the two attrributes are not related to each other hence in future there dependency can be on other attributes which may lead to separete redundancy

Question 13
a.BCNF

BCNF will be hard to compute.As for the realtion to come in BCNF it must the previous noramlisation form 1NF,2NF,3NF must be satisfied.

Question 14
d.None of the above

As no particular normalisation form removes all the dependencies.

Question 15
b.before creating the schema in the DBMS

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.