COMPUTER SCIENCE AND ENGINEERING
DATABASE MANAGEMENT SYSTEM
|
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: -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.
Detailed explanation-4: -When normalizing a 2NF relation to 3NF, we remove these transitive dependencies.
Detailed explanation-5: -Third normal form (3NF) is a database schema design approach for relational databases which uses normalizing principles to reduce the duplication of data, avoid data anomalies, ensure referential integrity, and simplify data management.