engineering recuitment RPSC Programmer Mock Test 2024 DBMS Integrity Constraints and Normal Form Functional Dependency
Given an instance of the relation R(ABCD).
|
A |
B |
C |
D |
|
a1 |
b1 |
c1 |
d1 |
|
a1 |
b2 |
c2 |
d2 |
|
a2 |
b2 |
c2 |
d3 |
|
a3 |
b3 |
c4 |
d3 |
Which of the following functional dependencies hold?
1
{AB} → D and D → A
2
{AB → C and B → D
3
{AB} → C and B → C
4
{AB} → D and A → D
5
Question Not Attempted