Normalization

Problems in Relational Data Model are :

• Anomalies

• Information Redundancy

• None of the above

Anomalies is Errors or inconsistence that may result when a user attempts to update a table that contains redundant data.

• True

• False

3 types of anomalies are :

• insert

• delete

• modification

• None of the above

Information Redundancy is Duplication of data due to storing the same data multiple times.

• True

• False

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

• Information Redundancy

• Anomalies

The purposes of normalization are :

• To ensure that the anomalies doesn’t occur

• To reduce data or storage redundancy

• To ensure easy for record searching/finding

• All the above

Steps in Normalization are :

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

• 1NF-2NF-3NF-BCNF

• 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

Choose three types of Functional Dependency

• Full Functional Dependency

• Partial Functional Dependency

• Transitive Functional Dependency

• None of the above

"Occurs when an attribute is functionally dependent on another non-key attribute."

The above statement is referring to :

• Full Functional Dependency

• Partial Functional Dependency

• Transitive Dependencies