DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
First normal form
|
|
Second normal form
|
|
Third normal form
|
|
Fourth normal form
|
Detailed explanation-1: -Third normal form (3NF) A table is in 3NF if it is in 2NF and it contains no transitive dependencies; that is, a condition in which an attribute (non-primary-key) is dependent on another attribute (non-primary-key) that is not part of the primary key.
Detailed explanation-2: -Third Normal Form (3NF) it has no transitive-dependency for all the non-key attributes.
Detailed explanation-3: -Avoid transitive dependencies to help ensure normalization A transitive dependency in a database is an indirect relationship between values in the same table that causes a functional dependency. To achieve the normalization standard of Third Normal Form (3NF), you must eliminate any transitive dependency.
Detailed explanation-4: -Note: If P-> Q and Q-> R are two functional dependencies, then P-> R is known as a transitive dependency. When normalizing a 2NF relation to 3NF, we remove these transitive dependencies.
Detailed explanation-5: -Third Normal Form (3NF): A relation is in third normal form, if there is no transitive dependency for non-prime attributes as well as it is in second normal form.