The relation schemas 𝑅1 and 𝑅2 form a Lossless join decomposition of 𝑅 if…

PYQ UGC NET 2015

The relation schemas 𝑅1Β and 𝑅2Β form a Lossless join decomposition of 𝑅 if and only if

(a)Β R1∩R2β† (R1βˆ’R2)R_1 \cap R_2 \twoheadrightarrow (R_1-R_2)

(b)Β R1β†’R2R_1 \rightarrow R_2

(c)Β R1∩R2β† (R2βˆ’R1)R_1 \cap R_2 \twoheadrightarrow (R_2-R_1)

(d)Β R2β†’R1∩R2R_2 \rightarrow R_1 \cap R_2

Codes :

  1. A.

    (a) and (b) happens

  2. B.

    (a) and (d) happens

  3. C.

    (a) and (c) happens

  4. D.

    (b) and (c) happens

Attempted by 531 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…