DBMS

A ___ is normalized after it has been organized.

• 1. Table

• Database

• Row

• Column

By normalizing relations or sets of relations, one minimizes ___.

• 1. Data

• Fields

• Redundancy

• Database

In addition to removing undesirable characteristics, normalization also eliminates ___ anomalies.

• 1. Insert

• Update

• Delete

• All of the above

A common approach to normalization is to ___ the larger table into smaller tables and link them together by using relationships.

• 1. Add

• Subtract

• Multiply

• Divide

Redundancy is reduced in a database table by using the ___ form.

• 1. Abnormal

• Normal

• Special

• None

Which of the following is not a type of Normal Form?

• 1. 1NF

• 2NF

• 3NF

• 10NF

Which of the following is a type of Normal Form?

• 1. ACNF

• BCNF

• CCNF

• DCNF

When a relation contains an atomic value, it is a ___ relation.

• 1. 1NF

• 2NF

• 3NF

• BCNF

2NF relations are those that are in 1NF with all the attribute types dependent on the ___ key.

• 1. Primary

• Foreign

• Composite

• Alternate

Non-prime attributes cannot be transitively dependent, so the relation must have the ___ normal form.

• 1. First

• Second

• Third

• Fourth