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.