Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 491
|
If a relation is in 2NF then :
|
every candidate key is a primary key
|
|
|
every non-prime attribute is fully functionally dependent on each relation key
|
|
|
every attribute is functionally independent
|
|
|
every relational key is a primary key
|
Question 491 Explanation:
→ If a relation is in 2NF then every non-prime attribute is fully functionally dependent on each relation key.
→ 2NF ensures that the relation contains no partial dependency. A relation is in 2NF if it is in 1NF and have no partial dependency.
→ 2NF ensures that the relation contains no partial dependency. A relation is in 2NF if it is in 1NF and have no partial dependency.
Correct Answer: B
Question 491 Explanation:
→ If a relation is in 2NF then every non-prime attribute is fully functionally dependent on each relation key.
→ 2NF ensures that the relation contains no partial dependency. A relation is in 2NF if it is in 1NF and have no partial dependency.
→ 2NF ensures that the relation contains no partial dependency. A relation is in 2NF if it is in 1NF and have no partial dependency.