A functional dependency is termed as a useful functional dependency if and only if it satisfies all the following three conditions:
• is not the empty set.
• is not the empty set.
• Intersection of and is the empty set.
For a relation with 4 attributes, the total number of possible useful functional dependencies is ________.
GATE CS 2024 (Afternoon) — Question 56
Database Management Systems (DBMS)Integrity Constraints & Functional DependenciesNAT2 marksHard
A GATE question every morning
One real past-paper question every morning for your branch, answer hidden until you tap. Free on Telegram.
More on Integrity Constraints & Functional Dependencies
- GATE CS 2026 (Forenoon) · Q30Let P, Q, R and S be the attributes of a relation in a relational schema. Let X Y indicate functional dependency in the context of a relati…
- GATE CS 2026 (Forenoon) · Q65Consider a relational database schema with a relation R(A, B, C, D) . If \ A, B\ and \ A, C\ are the only two candidate keys of the relatio…
- GATE CS 2026 (Afternoon) · Q42In the context of schema normalization in relational DBMS, consider a set F of functional dependencies. The set of all functional dependenc…
- GATE CS 2024 (Forenoon) · Q44The symbol indicates functional dependency in the context of a relational database. Which of the following options is/are TRUE?
- GATE CS 2022 (Forenoon) · Q31Consider a relation R(A, B, C, D, E) with the following three functional dependencies. AB C; BC D; C E; The number of superkeys in the rela…
- GATE CS 2021 (Afternoon) · Q16Consider the following statements S 1 and S 2 about the relational data model : S 1 : A relation scheme can have at most one foreign key. S…

