151k views
3 votes
What is 3NF in database design?

1 Answer

2 votes

Answer:

The 3NF form is a "eliminate columns not dependent on the key" in the database design.

Step-by-step explanation:

3NF form stands for third normal form says that it is necessary to remove all column that references to all related information that is not based on the primary key.

  • It is difficult to store data into one table to remove this problem we use the normalization, there are many forms in the normalization that are "1NF, 2NF, 3NF, and BCNF".
  • The main purpose to use 3NF (normal form) in the database is to remove the data duplication.

User Charles Marsh
by
9.1k points
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.