INSY 3304 QUIZ (CH.6)

A table is in 4NF if it is in 3NF, and _____. no column contains the same values all attributes must be dependent on the primary key and must be dependent on each other all attributes are unrelated it has no multivalued dependencies

it has no multivalued dependencies

In a _____ situation, one key determines multiple values of two other attributes and those attributes are independent of each other. partial dependency functional dependency multivalued dependency transitive dependency

multivalued dependency

If a table has multiple candidate keys and one of those candidate keys is a composite key, the table can have _____ based on this composite candidate key even when the primary key chosen is a single attribute. partial dependencies Boyce-Codd normal forms time-variances redundancies

partial dependencies

From a structural point of view, 3NF is better than _____. 3NF 5NF 2NF 6NF

2NF

A table that is in 2NF and contains no transitive dependencies is said to be in _____. 3NF 2NF 4NF 1NF

3NF

Some very specialized applications may require normalization beyond the _____. 1NF 4NF 3NF 2NF

4NF

Normalization purity is often easy to sustain in the modern database environment. True False

F

A table is in fourth normal form if it is in third normal form and has no independent multivalued dependencies. True False

T

Denormalization produces a lower normal form. True False

T

In order to meet performance requirements, portions of the database design may need to be occasionally denormalized. True False

T

It is possible for a table in 2NF to exhibit transitive dependency, where the primary key may rely on one or more nonprime attributes to functionally determine other nonprime attributes. True False

T

The combination of normalization and ER modeling yields a useful ERD, whose entities can be translated into appropriate table structures. True False

T

The objective of normalization is to ensure that each table conforms to the concept of well-formed relations. True False

T

To generate a surrogate key, Microsoft Access uses a(n) _____ data type. character identity sequence AutoNumber

auto number

BCNF can be violated only if the table contains more than one _____ key. candidate secondary primary foreign

candidate

The most likely data type for a surrogate key is _____. numeric character logical date

numeric

Dependencies based on only a part of a composite primary key are known as _____ dependencies. composite primary incomplete partial

partial

A _____ derives its name from the fact that a collection of multiple entries of the same type can exist for any single key attribute occurrence. primary key repeating group transitive dependency partial dependency

repeating group

A relational table must not contain a(n) _____. relationship repeating group entity attribute

repeating group

When a table contains only one candidate key, _____ are considered to be equivalent. the 3NF and the BCNF the 1NF and the 2NF the 4NF and the 3NF the BCNF and the DKNF

the 3NF and the BCNF