GATE Computer Science (CS) 2020 Solved Papers

Question : 39 of 65

Marks: +1, -0

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

A cell in R holds a set instead of an atomic value.
${R}$ has a nontrivial functional dependency ${X} → {A}$ , wh ${R}$ has a nontrivial functional dependency ${X} → {A}$ , where ${X}$ is not a sup and ${A}$ is a prime attribute.ere ${X}$ is not a sup and ${A}$ is a prime attribute.
${R}$ has a nontrivial functional dependency ${X} → {A}$ , where ${X}$ is not a sup and ${A}$ is a non- prime attribute and ${X}$ is a proper subset of some key.
${R}$ has a nontrivial functional dependency ${X} → {A}$ , where ${X}$ is not a sup and ${A}$ is a non- prime attribute and $X$ is not a proper subset of any key.

Solution:

{R}

has a nontrivial functional dependency

{X} → {A}

, where

{X}

is not a sup and

{A}

is a prime attribute.

Go to Question:

Prev Question

Next Question