The process to properly define the database tables to provide flexibility, minimized redundancy and data integrity is called ______

Normalization is used for Eliminating redundant(useless) data and Ensuring data dependencies.

First Normal Form (1NF)

• It should only have a single value for attribute and values stored in it should be of the same domain
• All the columns in a table should have unique names.

Second Normal Form (2NF)

• It should be in the First Normal form.
• It should not have Partial Dependency.

Third Normal Form (3NF)

• It is in the Second Normal form.
• it doesn't have Transitive Dependency.

Boyce and Codd Normal Form (BCNF)

BCNF is an Advance version of the 3NF

• The relation must be in 3rd Normal Form
• and, for each functional dependency ( X → Y ), X should be a super Key.

Fourth Normal Form (4NF)

• It is in the Boyce-Codd Normal Form.
• it doesn't have Multi-Valued Dependency.