Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 393
|
For a database Relation R (A,B,C,D) where the domains of A,B,C, and D only include atomic values, only the following functional dependency and those that can be inferred from them hold: A → C, B →D. The relation is in:
|
1NF but not in 2NF
|
|
|
2 NF but not in 3NF
|
|
|
3NF but not in BCNF
|
|
|
BCNF but not in 4NF
|
Question 393 Explanation:
Candidate key is AB.
And clearly there is partial functional dependency which is
A → C ,in which non prime attribute C is partially dependent on A
And clearly there is partial functional dependency which is
A → C ,in which non prime attribute C is partially dependent on A
Correct Answer: A
Question 393 Explanation:
Candidate key is AB.
And clearly there is partial functional dependency which is
A → C ,in which non prime attribute C is partially dependent on A
And clearly there is partial functional dependency which is
A → C ,in which non prime attribute C is partially dependent on A