Normalisation, Chapter 7

Improving ____ leads to more flexible queries.
1. atomicity
2. normalization
3. denormalization
4. derived attributes
A table is in fourth normal form (4NF) if ____.
1. all attributes are dependent on the primary key
2. it is in 3NF and there are no repeating groups
3. it is in 3NF and has no independent multivalued dependencies
4. no column contains the same values
When designing a database you should ____.
1. make sure entities are in normal form before table structures are created
2. create table structures then normalize the database
3. only normalize the database when performance problems occur
4. consider more important issues such as performance before normalizing
The normalization process involves assigning ____ to tables based on the concept of determination.
1. data
2. files
3. attributes
4. relations
____ yields increased performance in a database system.
1. Denormalization
2. Normalization
3. Atomization
4. Compression
____ refers to the level of detail represented by the values stored in a table's row.
1. Atomicity
2. Duplication
3. Granularity
4. Depth
A ____ key is an artificial PK introduced by the designer with the purpose of simplifying the assignment of primary keys to tables.
1. surrogate
2. composite
3. candidate
4. foreign
The ____ model views the data as part of a table or collection of tables in which all key values must be identified.
1. relational
2. object-oriented
3. conceptual
4. external
Tables in ____ will perform suitably in business transactional databases.
1. 0NF
2. 1NF
3. 2NF
4. 3NF
Another name for a prime attribute is a ____ attribute.
1. index
2. view
3. key
4. surrogate
A 2NF table can exhibit ____ dependency.
1. partial
2. complete
3. transitive
4. indirect
An attribute that is part of a key is known as a(n) ____ attribute.
1. important
2. nonprime
3. prime
4. entity
The conflicts between design efficiency, information requirements, and processing speed are often resolved through ____.
1. conversion from 1NF to 2NF
2. conversion from 2NF to 3NF
3. compromises that may include denormalization
4. conversion from 3NF to 4NF
A table in ____ contains no transitive dependencies.
1. 1NF
2. 2NF
3. 3NF
4. none of the above
When a table contains only one ____ key, the 3NF and the BCNF are equivalent.
1. primary
2. surrogate
3. foreign
4. candidate
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 ____.
1. 1NF
2. 2NF
3. 3NF
4. 4NF
A ____ is any attribute whose value determines other values within a row.
1. secondary key
2. partial dependency
3. transitive dependence
4. determinant
Identification of the ____ will let you know where you are in the normalization process.
1. normal form
2. primary key
3. attributes
4. repeating groups
In an ideal (database design) world, the level of desired granularity is determined at the ____ design or at the requirements gathering phase.
1. data
2. conceptual
3. functional
4. external
Unnormalized tables yield no simple strategies for creating virtual tables, which are also known as ____.
1. warehouses
2. indexes
3. views
4. sets

Normalisation, Chapter 7

Quiz