Topic 5 Flashcards
From a structural point of view, 3NF is better than _____
a. 2NF
b. 3NF
c. 5NF
d. 6NF
2NF
Normalization works through a series of stages called normal forms. For most purposes in business database design, _____ stages are as high as you need to go in the normalization process
a. two
b. three
c. four
d. five
three
From a structural point of view, 2NF is better than _____
a. 1NF
b. 3NF
c. 4NF
d. BCNF
1NF
An attribute that is part of a key is known as a (n) _____ attribute
a. important
b. nonprime
c. prime
d. entity
prime
Attribute A _____ attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B
a. determines
b. derives from
c. controls
d. owns
determines
Some very specialized applications may require normalization beyond the _____
a. 1NF
b. 2NF
c. 3NF
d. 4NF
4NF
Of the following normal forms, _____ is mostly of theoretical interest
a. 1NF
b. 3NF
c. BCNF
d. DKNF
DKNF
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
1NF
A (n) _____ exists when there are functional dependencies such that Y is functionally dependent on X, Z is functionally dependent on Y, and X is the primary key
a. partial dependency
b. repeating group
c. atomic attribute
d. transitive dependency
transitive dependency
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
a. partial dependency
b. transitive dependency
c. repeating group
d. primary key
repeating group
A relational table must not contain a (n) _____
a. entity
b. attribute
c. relationship
d. repeating group
repeating group
In a (n) _____ diagram, the arrows above the attributes indicate all desirable dependencies
a. Chen
b. dependency
c. functionality
d. ER
dependency
Dependencies based on only a part of a composite primary key are known as _____ dependencies
a. primary
b. partial
c. incomplete
d. composite
partial
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
a. Boyce-Codd normal forms
b. redundancies
c. time-variances
d. partial dependencies
partial dependencies
A table that is in 2NF and contains no transitive dependencies is said to be in _____
a. 1NF
b. 2NF
c. 3NF
d. 4NF
3NF
Improving _____ leads to more flexible queries
a. atomicity
b. normalization
c. denormalization
d. derived attribute
atomicity
An atomic attribute _____
a. cannot exist in a relational table
b. cannot be further subdivided
c. displays multiplicity
d. is always chosen to be a foreign key
cannot be further subdivided
The most likely data type for a surrogate key is _____
a. character
b. date
c. logical
d. numeric
numeric
Granularity refers to _____
a. the size of a table
b. the level of detail represented by the values in a table’s row
c. the number of attributes represented in a table
d. the number of rows in a table
the level of detail represented by the values in a table’s row
From a system functionality point of view, _____ attribute values can be calculated when they are needed to write reports or invoices
a. derived
b. atomic
c. granular
d. historical
derived
In a real-world environment, we must strike a balance between design integrity and _____
a. robustness
b. flexibility
c. uniqueness
d. ease of use
flexibility
To generate a surrogate key, Microsoft Access uses a (n) _____ data type
a. character
b. sequence
c. AutoNumber
d. identity
AutoNumber
BCNF can be violated only if the table contains more than one _____ key
a. primary
b. candidate
c. foreign
d. secondary
candidate
When a table contains only one candidate key, _____ are considered to be equivalent
a. the 1NF and the 2NF
b. the 3NF and the BCNF
c. the 4NF and the 3NF
d. the BCNF and the DKNF
the 3NF and the BCNF
