R Mod I

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

• Data

• Fields

• Redundancy

• Database

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

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

• Add

• Subtract

• Multiply

• Divide

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

• Abnormal

• Normal

• Special

• None

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

• 1NF

• 2NF

• 3NF

• 6NF

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

• Primary

• Foreign

• Composite

• Alternate

When a relation is in 2NF and there is ___, it is in 3NF.

• Transitive Dependency

• No Transitive Dependency

• Relational Dependency

• No Relational Dependency

What is TRUE about the First Normal Form (1NF)?

• If a relation contains an atomic value, it will be 1NF.

• A table attribute cannot contain more than one value, according to this rule.

• A single-valued attribute can only be stored in it.

• All of the above

Neither multivalued nor composite attributes, nor their combinations, may be used in the ___ normal form.

• First

• Second

• Third

• Fourth

What is TRUE about the Second Normal Form (2NF)?

• Relational must belong to 1NF in the 2NF.

• All attributes other than the primary key are fully functional in the second normal form

• Both A and B

• None of the above