Let π,π,π and π be the attributes of a relation in a relational schema.β¦
GATE Β· 2026 Β· CS Β· Set 1 Β· Computer Science & IT
Let π,π,π and π be the attributes of a relation in a relational schema. Let π βΆπ indicate functional dependency in the context of a relational database, where X,Y β{π,π,π ,π}.
Which of the following options is/are always true?
- A.
If ( {π,π} βΆ{π } and {π} βΆ{π } ), then {π} βΆ{π }
- B.
If {π,π} βΆ{π }, then ( {π} βΆ{π } or {π} βΆ{π } )
- C.
If ( {π} βΆ{π } and {π} βΆ{π} ), then {π,π} βΆ{π ,π}
- D.
If {π} βΆ{π }, then {π,π} βΆ{π }
Attempted by 258 students.
Sign up free to check your answer
Sign up freeLoading lessonβ¦