1

GATE CSE 2024 Set 2

Numerical

+2

-0.66

A functional dependency $F: X \to Y$ is termed as a useful functional dependency if and only if it satisfies all the following three conditions:

- $X$ is not the empty set.
- $Y$ is not the empty set.
- Intersection of $X$ and $Y$ is the empty set.

For a relation $R$ with 4 attributes, the total number of possible useful functional dependencies is _________

Your input ____

2

GATE CSE 2024 Set 1

MCQ (More than One Correct Answer)

+2

-0.66

The symbol → indicates functional dependency in the context of a relational database. Which of the following options is/are TRUE?

3

GATE CSE 2021 Set 1

MCQ (Single Correct Answer)

+2

-0.67

Consider the relation R(P, Q, S, T, X, Y, Z, W) with the following functional dependencies.

PQ → X; P → YX; Q → Y; Y → ZW

Consider the decomposition of the relation R into the constituent relations according to the following two decomposition schemes.

D_{1} : R = [(P, Q, S, T); (P, T, X); (Q, Y); (Y, Z, W)]

D_{2} : R = [(P, Q, S); (T, X); (Q, Y); (Y, Z, W)]

Which one of the following options is correct?

4

GATE CSE 2020

MCQ (Single Correct Answer)

+2

-0.67

Consider a relational table R that is in 3NF, but not in BCNF. Which one of the following statements is TRUE?

Questions Asked from Functional Dependencies and Normalization (Marks 2)

Number in Brackets after Paper Indicates No. of Questions

GATE CSE 2024 Set 2 (1)
GATE CSE 2024 Set 1 (1)
GATE CSE 2021 Set 1 (1)
GATE CSE 2020 (1)
GATE CSE 2019 (1)
GATE CSE 2015 Set 1 (1)
GATE CSE 2014 Set 1 (1)
GATE CSE 2013 (2)
GATE CSE 2008 (3)
GATE CSE 2007 (1)
GATE CSE 2006 (2)
GATE CSE 2005 (2)
GATE CSE 2004 (2)
GATE CSE 2003 (1)
GATE CSE 2002 (2)
GATE CSE 2001 (1)
GATE CSE 2000 (1)
GATE CSE 1999 (1)
GATE CSE 1998 (2)
GATE CSE 1997 (2)
GATE CSE 1995 (1)

GATE CSE Subjects

Theory of Computation

Operating Systems

Algorithms

Database Management System

Data Structures

Computer Networks

Software Engineering

Compiler Design

Web Technologies

General Aptitude

Discrete Mathematics

Programming Languages