Database-Management-System
August 29, 2024ER-Model
August 29, 2024Database-Management-System
|
Question 342
|
“X is not a proper subset of any Key” is a 3NF violation called as:
|
Partial dependency
|
|
|
Total dependency
|
|
|
Transitive dependency
|
|
|
None of the above
|
Question 342 Explanation:
If X is not a proper subset of any key means there is no partial dependency. And if there is a violation then the only possibility left is transitive dependency, means if there is transitive dependencies then there is 3NF violation.
Correct Answer: C
Question 342 Explanation:
If X is not a proper subset of any key means there is no partial dependency. And if there is a violation then the only possibility left is transitive dependency, means if there is transitive dependencies then there is 3NF violation.