GATE CS 2020 (Forenoon) — Question 46

Database Management Systems (DBMS)Normalization Schemes (1NF, 2NF, 3NF, BCNF Boundaries)MCQ2 marks · −2/3 if wrongMedium

Consider a relational table R that is in 3NF, but not in BCNF. Which one of the following statements is TRUE?
  1. A
    R has a non-trivial functional dependency X \(\rightarrow\) A, where X is not a superkey and A is a prime attribute.
  2. B
    R has a non-trivial functional dependency X \(\rightarrow\) A, where X is not a superkey and A is a non-prime attribute and X is not a proper subset of any key.
  3. C
    R has a non-trivial functional dependency X \(\rightarrow\) A, where X is not a superkey and A is a non-prime attribute and X is a proper subset of some key.
  4. D
    A cell in R holds a set instead of an atomic value.
Practise the full 2020-FN paper
Challenge a friend: WhatsApp Telegram
From RENYXERAThis week's 10-question challengeSame 10 past-GATE questions for everyone this week — see where you stand.
Practise more on Normalization Schemes (1NF, 2NF, 3NF, BCNF Boundaries)Timed, in the real exam interface · free to start

A GATE question every morning

One real past-paper question every morning for your branch, answer hidden until you tap. Free on Telegram.

Join
Stuck? Ask in the student group