nts each 26 Normalization works through a series of stages c

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

Solution

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.