QUIZ NORMALIZATION

If there is more than one key for relation schema in DBMS then each key in relation schema is classified as

• primary key

• candidate key

• composite key

• foreign key

The form of dependency in which the set of attributes that are neither a subset of any of the keys nor the candidate key is classified as

• partial dependency

• transitive dependency

• full functional dependency

• functional dependency

If every non-key attribute is functionally dependent on the primary key, then the relation will be in

• First Normal Form

• Second Normal Form

• Third Normal Form

• Fourth Normal Form

Atomicity of domains of attributes is related to

• First Normal Form

• Second Normal Form

• Third Normal Form

• Fourth Normal Form

Which of the following statement is INCORRECT?

• Data Redundancy can be handled by inconsistency

• Redundancy in date may lead to its inconsistency

• Inconsistency in data may lead to redundancy

• Data inconsistency can be handled by Redundancy

The table attached is an example of First Normal Form.

• TRUE

• FALSE

In the case of Database normalization the order of the rows and columns is immaterial;

• TRUE

• FALSE

A table is in 3NF if it is in 2NF and if it has no ......................

• functional dependencies

• transitive dependencies

• multivalued dependencies

• partial dependencies

Complete the statement below.

Data Normalization is the process of decomposing relations with ____ to produce smaller, well-structured relations.

Complete the statement below.

A table should not pertain to more than one _____