GATE CS 2025 (Forenoon) — Question 47

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

Consider a relational schema team(name, city, owner), with functional dependencies \( \{\text{name} \rightarrow \text{city}, \text{name} \rightarrow \text{owner}\} \). The relation team is decomposed into two relations, t1(name, city) and t2(name, owner). Which of the following statement(s) is/are TRUE?
  1. A
    The relation team is NOT in BCNF.
  2. B
    The relations t1 and t2 are in BCNF.
  3. C
    The decomposition constitutes a lossless join.
  4. D
    The relation team is NOT in 3NF.
Practise the full 2025-FN paper
Challenge a friend: WhatsApp Telegram
From RENYXERAPractise this subject in the exam simulatorTimed, GATE-style tests with analytics that find your weak topics.
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