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.