IT Quiz 6 – Flashcards
Unlock all answers in this set
Unlock answersquestion
1NF, 2NF, and 3NF are ____.
answer
Normalization Stages
question
A ____ derives its name from the fact that a group of multiple entries of the same type can exist for any single key attribute occurrence.
answer
Repeating Group
question
A ____ exists when there are functional dependencies such that Y is functionally dependent on X and Z is functionally dependent on Y, and X is the primary key.
answer
Transitive Dependency
question
A relational table must not contain a(n) ____.
answer
Repeating Group
question
A table is in 4NF if it is in 3NF and ____.
answer
Has no multivalued dependencies
question
A table that displays data redundancies yields ____.
answer
Anomalies
question
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 ____.
answer
INF
question
A table that is in 1NF and includes no partial dependencies is said to be in ____.
answer
2NF
question
A table that is in 2NF and contains no transitive dependencies is said to be in ____.
answer
3NF
question
A table where all attributes are dependent on the primary key and are independent of each other, and no row contains two or more multivalued facts about an entity, is said to be in ____.
answer
4NF
question
A table where every determinant is a candidate key is said to be in ____.
answer
BCNF
question
According to naming conventions described in Chapter 2, ____ would be the best name for a column representing the charges per hour in a table named JOB.
answer
JOB_CHG_HOUR
question
An atomic attribute ____.
answer
Cannot be further subdivided
question
An attribute that is part of a key is known as a(n) ____ attribute.
answer
Prime
question
An example of denormalization is using a ____ denormalized table to hold report data. This is required when creating a tabular report in which the columns represent data that is stored in the table as rows.
answer
Temporary
question
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.
answer
Determines
question
BCNF can be violated only if the table contains more than one ____ key.
answer
Candidate
question
Before converting a table into 3NF, it is imperative the table already be in ____.
answer
2NF
question
Data redundancy produces ____.
answer
Data integrity problems
question
Dependencies based on only a part of a composite primary key are called ____ dependencies.
answer
Partial
question
For most business transactional databases, we should normalize relations into ____.
answer
3NF
question
From a strictly database point of view, ____ attribute values can be calculated when they are needed to write reports or invoices.
answer
Derived
question
From a structural point of view, 2NF is better than ____.
answer
1NF
question
Granularity refers to ____.
answer
the level of detail represented by the values stored in a table's row
question
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.
answer
Partial Dependencies
question
If you have three different transitive dependencies, ____ different determinant(s) exist.
answer
Three
question
Improving ____ leads to more flexible queries.
answer
Atomicity
question
In a real-world environment, we must strike a balance between design integrity and ____.
answer
Flexibility
question
In a(n) ____ diagram, the arrows above the attributes indicate all desirable dependencies.
answer
Dependency
question
Most designers consider the BCNF as a special case of the ____.
answer
3NF
question
Normalization represents a micro view of the ____ within the ERD.
answer
Entities
question
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.
answer
Three
question
Of the following normal forms, ____, is mostly of theoretical interest.
answer
DKNF
question
Some very specialized applications may require normalization beyond the ____.
answer
4NF
question
The conflicts between design efficiency, information requirements, and processing speed are often resolved through ____.
answer
Compromises that include denormalization
question
The most likely data type for a surrogate key is ____.
answer
Numeric
question
To generate a surrogate key, Microsoft Access uses a(n) ____ data type.
answer
AutoNumber
question
When designing a database, you should ____.
answer
make sure entities are in normal form before table structures are created
question
____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.
answer
Data Warehouse
question
____ yields better performance.
answer
Denormalization
