Consider the relation r1 with the functional dependencies that hold on it:…

Consider the relation r1 with the functional dependencies that hold on it:

r1(p, q, r, s, t)

p → q, r, s, t

s → t

The relation r1 is decomposed into two relations r1_a, r1_b:

r1_a(p, q, r, s)

r1_b(s, t)

Identify the correct statement/s based on this information:

  1. A.

    Relation r1 is in BCNF and r1_a, r1_b are in 3NF

  2. B.

    Relation r1 in in 3NF and r1_a, r1_b are in BCNF

  3. C.

    Relation r1 is in 2NF and r1_a, r1_b are in BCNF

  4. D.

    All the relations r1, r1_a and r1_b are in 3NF

Attempted by 220 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…