Which forms are based on the concept of functional dependency:

Normal Form MCQ - General Knowledge Question and Answer

Normalization is a database design technique which organizes tables in a manner that reduces redundancy and dependency of data. It divides larger tables into smaller tables and links them using relationships.

Which forms are based on the concept of functional dependency: 


1NF
2NF
3NF
4NF

Answer:

The table is in 3NF if every non-prime attribute of R is non-transitively dependent (i.e. directly dependent) on every superkey of R.

Share Me: