GATE DA 2026 — Question 17

Database Management and Warehousingintegrity constraints, normal formMCQ1 mark · −1/3 if wrongMedium

Let R(A,B,C,D,E) be a relational schema with functional dependency set F={A→BC, CD→E, E→A}. Which of the following statements is correct?
  1. A
    AD, ED and CD are the only candidate keys of R.
  2. B
    AD and ED are the only candidate keys of R.
  3. C
    A, E and CD are the only candidate keys of R.
  4. D
    A and CD are the only candidate keys of R.
Practise the full 2026 paper
Challenge a friend: WhatsApp Telegram
Recommended book · affiliate linkDatabase System Concepts (Korth)Normalisation, SQL, transactions and indexing — the DBMS syllabus in one book.
Practise more on integrity constraints, normal formTimed, 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