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
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