Question 963 – Nielit Scientist-B IT 4-12-2016
December 3, 2023UGC NET Dec-2020 and June-2021 Paper-2
December 3, 2023Database-Management-System
|
Question 808
|
Normalization from which is based on transitive dependency is classified as:
|
First normal form
|
|
|
Second normal form
|
|
|
Fourth normal form
|
|
|
Third normal form
|
Question 808 Explanation:
The table is in 3NF if and only if both of the following conditions hold:
1. The relation R (table) is in second normal form (2NF)
2. Every non-prime attribute of R is non-transitively dependent on every key of R.
1. The relation R (table) is in second normal form (2NF)
2. Every non-prime attribute of R is non-transitively dependent on every key of R.
Correct Answer: D
Question 808 Explanation:
The table is in 3NF if and only if both of the following conditions hold:
1. The relation R (table) is in second normal form (2NF)
2. Every non-prime attribute of R is non-transitively dependent on every key of R.
1. The relation R (table) is in second normal form (2NF)
2. Every non-prime attribute of R is non-transitively dependent on every key of R.