IMS.

_______________ is a database schema design technique in which an existing schema is modified to minimize redundancy and dependency on data.

• Database

  para-normalization

• Database normalization

• Database foreign key

• None of them

Belongs to advantages of normalization

• minimize data redundancy.

• Greater overall database organization.

• flexible database design

• All of them

Normalization splits a large table into smaller tables and defines relationships between them to increase clarity in organizing data.

• True

• False

Reasons for Normalizing database

• Skill Matching

• Collaboration and Team Formation

• Making relations very large

• All of them

Each table cell should contain a single value

• 3NF

• 1NF

• 2NF

• 4NF

The entity should be considered already in 1NF

• 1NF

• 2NF

• 3NF

• None of them

is a drawback of Normalization

• Careless decomposition may lead to a bad database design, leading to serious problems.

• Greater overall database organization.

• It reinforces the concept of relational integrity.

• All of them

represented as a ________ Form of normalization.

• 1NF

• 2NF

• 3NF

• BCNF

____________ specifically refers to a situation in which an attribute in a relation depends on only a part (or a subset) of the primary key rather than the entire primary key.

• Dependency

• Partial dependency

• BCNF

• None of them

To resolve partial dependency, we need ______________ Technique

• First Normal Form

• Second Normal Form

• Third Normal Form