Normalization
1. Normalization is a process for changing attributes to entities. F
2. In order to meet performance requirements you may have to denormalize portions of the
database design. T
5. Repeating groups must be eliminated by making sure that each row defines a single
entity. T
6. All relational tables satisfy the 1NF requirements. T
7. Data redundancies are caused by the fact that every row entry requires duplication of
data. T
8. A table is in second normal form (2NF) if it is in 1NF and it includes no partial
dependencies. T
9. It is possible for a table in second normal form (2NF) to exhibit transitive dependency,
where one or more attributes may be functionally dependent on nonkey attributes. T
10. Normalization procedures focus on the characteristics of specific entities. It represents a
micro view of the entities within the E-R diagram. T
11. Dependencies based on only part of a composite primary key are called full
dependencies. T
12. Normalization works through a series of stages called normal forms. Typically
__________ stages are processed.
a. 2 b. 3 c. 4 d. 5
13. Normalization stages are
a. 1NF b. 2NF c. 3NF d. All of the above e. None of the above
14. A table that displays data redundancies yields ____________ anomalies.
a. update b. insertion c. deletion d. all of the above e. None of the above
15. The term first normal form (1NF) describes the tabular format in which
a. all the key attributes are defined.
b. there are no repeating groups in the table. Row/column intersection can contain one and only
one value, not a set of values.
c. all attributes are dependent on the primary key.
d. All of the above
e. None of the above
16. A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on
the primary key, is said to be in
a. 1NF. b. 2NF. c. 3NF d. 4NF e. BCNF
17. A table that is in 1NF and includes no partial dependencies only is said to be in
a. 1NF. b. 2NF c. 3NF. d. 4NF e. BCNF.
18. A table that is in 2NF and contains no transitive dependencies is said to be in
a. 1NF b. 2NF c. 3NF d. 4NF e. BCNF.
19. Data redundancy produces
a. wasted disk space b. data anomalies c. data integrity problems d. All of the above
20. The ________ model views the data as part of a table or collection of tables in which all key values must
be identified.
a. relational b. object-oriented c. conceptual d. external
21. Normalization is a process for assigning __________ to entities.
a. data b. files c. attributes d. relations
22. Normalization works through a series of normal
a. schemas. b. entities. c. databases. d. forms.
23. From a structural point of view, 2NF is better than
a. 1NF b. 3NF c. 4NF d. BCNF
24. Dependencies can be identified with the help of the dependency
a. form. b. schema. c. diagram. d. database.
