The GATE Grind

GATE 2025 CS (CS1) – Question 47

Databases · ER-Model and Database Architecture · 2 marks · Multiple select

Consider a relational schema $team(name, city, owner)$, with functional dependencies $\{name \rightarrow city,\ name \rightarrow 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. The relation $team$ is NOT in BCNF.
  2. The relations $t1$ and $t2$ are in BCNF.
  3. The decomposition constitutes a lossless join.
  4. The relation $team$ is NOT in 3NF.

Practise this question in The GATE Grind →

Show answer and explanation

Correct answer: (B) The relations $t1$ and $t2$ are in BCNF.; (C) The decomposition constitutes a lossless join.

Explanation

The relation $team(name,city,owner)$ has FDs $name\to city$ and $name\to owner$. So $name^+=\{name,city,owner\}$ and **name is the (only) candidate key**.

Answer: B, C.

More ER-Model and Database Architecture questions

All ER-Model and Database Architecture questions →