normalization

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

• 1. Data

• 1. Fields

• 1. Redundancy

• 1. Database

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

• 1. Insert

• 1. Update

• 1. Delete

• 1. All of the above

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

• 1. 1NF

• 1. 2NF

• 1. 3NF

• 1. BCNF

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

• 1. Transition Dependency

• 1. No Transition Dependency

• 1. Relational Dependency

• 1. No Relational Dependency

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

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

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

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

• 1. All of the above

A functional dependency is a relationship between or among

• Entities
  

• Rows

• Attributes
  

• Tables

If more than one value of B is present for a single value of A in a dependency A -> B, then the relationship is

• 1. Single

• 1. Multi-valued

• 1. Both a and b

• 1. None of the above

If more than one value of B is present for a single value of A in a dependency A -> B, then the relationship is

• 1. Single

• 1. Multi-valued

• 1. Both a and b

• 1. None of the above