Normalization Revision

The purposes of normalization are :

• To ensure that the anomalies doesn’t occur

• To ensure easy for record searching/finding

• To reduce data or storage redundancy

• All the above

Steps in Normalization are :

• UNF- 1NF-2NF-3NF-BCNF

• 2NF-3NF-BCNF

• 1NF-2NF-3NF-BCNF

• None of the above

"Constraint between two attributes or two sets of attributes."

The above statement is referring to :

• Functional Dependecies

• Transitive Dependencies

A process for assigning attributes into a table and reduces data redundancy and helps eliminate the data anomalies that associated with poor database design is called as :

• Normalization

• Anomalies

• Information Redundancy

A relation is in 1NF if it doesn't contain any ____________?

• Determinants

• Null values in primary key fields

• Repeating group