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.