GATE CS 2025 (Afternoon) — Question 46

Database Management Systems (DBMS)Normalization Schemes (1NF, 2NF, 3NF, BCNF Boundaries)MSQ2 marksMedium

Consider the following relational schema along with all the functional dependencies that hold on them. \( R1(A, B, C, D, E) \): \( \{D \rightarrow E, EA \rightarrow B, EB \rightarrow C\} \) \( R2(A, B, C, D) \): \( \{A \rightarrow D, A \rightarrow B, C \rightarrow A\} \) Which of the following statement(s) is/are TRUE?
  1. A
    \( R1 \) is in 3NF
  2. B
    \( R2 \) is in 3NF
  3. C
    \( R1 \) is NOT in 3NF
  4. D
    \( R2 \) is NOT in 3NF
Practise the full 2025-AN 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 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