For VIVA

When is a table is said to be 3NF

• Normalization improves performance by reducing redundancy.

• If and only if it is in 2NF and every non key attribute is Non-transitively dependent on the primary key

• It involves introduction of redundancy in data

• None of the above

Identification of the ____ will let you know where you are in the normalization process.

• normal form

• primary key

• attributes

• repeating groups

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 ____.

• 1NF

• 2NF

• 3NF

• 4NF

A table in ____ contains no transitive dependencies.

• 1NF

• 2NF

• 3NF

• none of the above

The conflicts between design efficiency, information requirements, and processing speed are often resolved through ____.

• conversion from 1NF to 2NF

• conversion from 2NF to 3NF

• compromises that may include denormalization

• conversion from 3NF to 4NF

A 2NF table can exhibit ____ dependency.

• partial

• complete

• transitive

• indirect

Tables in ____ will perform suitably in business transactional databases.

• 0NF

• 1NF

• 2NF

• 3NF

The ____ model views the data as part of a table or collection of tables in which all key values must be identified.

• relational

• object-oriented

• conceptual

• external

A ____ key is an artificial PK introduced by the designer with the purpose of simplifying the assignment of primary keys to tables.

• surrogate

• composite

• candidate

• foreign

The normalization process involves assigning ____ to tables based on the concept of determination.

• data

• files

• attributes

• relations