Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 744 |
For a database relation R(a,b,c,d) where the domains of a,b,c and d include only
atomic values, only the following functional dependencies and those that can be inferred
from them hold
A → c
B → d
The relation is in
atomic values, only the following functional dependencies and those that can be inferred
from them hold
A → c
B → d
The relation is in
| 1 normal form but not in 2 normal form | |
| 2 normal form but not in 3 normal form | |
| 3 normal form | |
| None of these |
Question 744 Explanation:
Candidate key is ab.
Since all a, b, c, d are atomic. So the relation is in 1NF.
Checking the FD’s
a → c
b → d
We can see that there is partial dependencies. So it is not 2NF.
Since all a, b, c, d are atomic. So the relation is in 1NF.
Checking the FD’s
a → c
b → d
We can see that there is partial dependencies. So it is not 2NF.
Correct Answer: A
Question 744 Explanation:
Candidate key is ab.
Since all a, b, c, d are atomic. So the relation is in 1NF.
Checking the FD’s
a → c
b → d
We can see that there is partial dependencies. So it is not 2NF.
Since all a, b, c, d are atomic. So the relation is in 1NF.
Checking the FD’s
a → c
b → d
We can see that there is partial dependencies. So it is not 2NF.
Subscribe
Login
0 Comments