nts each 26. Normalization works through a series of stages called normal forms.

Question

nts each 26. Normalization works through a series of stages called normal forms. Far most purposes in business database design. stages are as high as you need to go in the normalization process. c. four d, five 27. From a structural point of view, 3NF is better than a. 4NF b., 2NF 5NF d. 6NF 28. From a structural point of view, 2NF is better than a, INF b. 3NF c, 4NF 29. An attribute that is part of a key is known as a(n). attribute a, mportant b. nonprime d, entity 30. A table that displays data redundancies yields a, consistencies fewer attributes d, more entities 31. Data redundancy produces a, slower lookups b. robust design c, efficient storage use d data integrity problems 32. Some very specialized applications may require normalization beyond the a. INF b, NF c. 3NF d. ANF

Explanation / Answer

26.) In general, we can go up to 5NF but in most of the business design, 3NF provides expected redundancy. Hence option b is right.

From a structural point of view 1NF < 2NF < 3NF <4NF < 5NF < 6NF.

27.) From structural point of view, 3NF is better than 2NF. Hence option b is right.

28.) From structural point of view, 2NF is better than 1NF. Hence option a is right.

29.) An attribute that is a part of a key is known as prime attribute. Hence option c is right.

31.) Data redundancy produces data integrity problems. Hence option d is right.

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

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