INFO 3233 TEST 2 QUESTIONS AND VERIFIED
ANSWERS
1. Normalization is a process that____________. - Answers - controls data
redundancies
for most business database design purposes____ is adequate - Answers - 3NF
Second normal form is better than_ - Answers - 1NF
Generally, the higher the normal form, the more__________are required to produce a
specified output. - Answers - joins
Sometimes the highest level of normalization conflicts with the need for - Answers - fast
performance
6. In general, denormalization produces - Answers - faster performace
7. An attribute that is part of a key is called a ________ attribute. - Answers - prime
8. A partial dependency can exist only if a table's primary key is composed of ______. -
Answers - several attributes
9. A table is in ________ if it is in 2NF and there are not transitive dependencies. -
Answers - 3NF
10. A table is in ________if every determinant in the table is a candidate key. - Answers
- BCNF
11. If a _________ attribute is the determinant of a key attribute, it fails to meet BCNF. -
Answers - nonkey
12. In the process of normalization, breaking off functional dependencies and placing
them in separate table structures is called_________. - Answers - Decompostion
13. If a table contains only one candidate key, then ________ and BCNF are
equivalent. - Answers - 3NF
14. The _________ provides the macro view of an organization's data requirements and
operations. - Answers - ER- diagram
15. _____________represents a micro view of the entities within the E-R diagram. -
Answers - normalization procedures
ANSWERS
1. Normalization is a process that____________. - Answers - controls data
redundancies
for most business database design purposes____ is adequate - Answers - 3NF
Second normal form is better than_ - Answers - 1NF
Generally, the higher the normal form, the more__________are required to produce a
specified output. - Answers - joins
Sometimes the highest level of normalization conflicts with the need for - Answers - fast
performance
6. In general, denormalization produces - Answers - faster performace
7. An attribute that is part of a key is called a ________ attribute. - Answers - prime
8. A partial dependency can exist only if a table's primary key is composed of ______. -
Answers - several attributes
9. A table is in ________ if it is in 2NF and there are not transitive dependencies. -
Answers - 3NF
10. A table is in ________if every determinant in the table is a candidate key. - Answers
- BCNF
11. If a _________ attribute is the determinant of a key attribute, it fails to meet BCNF. -
Answers - nonkey
12. In the process of normalization, breaking off functional dependencies and placing
them in separate table structures is called_________. - Answers - Decompostion
13. If a table contains only one candidate key, then ________ and BCNF are
equivalent. - Answers - 3NF
14. The _________ provides the macro view of an organization's data requirements and
operations. - Answers - ER- diagram
15. _____________represents a micro view of the entities within the E-R diagram. -
Answers - normalization procedures
