Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 386
|
If a relation is an 2NF and 3NF forms, then
|
no non-prime attribute is functionally dependent on other non-prime attributes
|
|
|
no non-prime attribute is functionally depend on the prime attributes
|
|
|
all attributes are functionally independent
|
|
|
prime attribute is functionally independent of all non-prime attributes
|
Question 386 Explanation:
If a relation is an 2NF and 3NF forms, then no non-prime attribute is functionally dependent on other non-prime attributes because for 3NF the condition is that for A->B , either A is a super key or B is a prime attribute.
Correct Answer: A
Question 386 Explanation:
If a relation is an 2NF and 3NF forms, then no non-prime attribute is functionally dependent on other non-prime attributes because for 3NF the condition is that for A->B , either A is a super key or B is a prime attribute.