Consider a relation R A- B- C- D- E and functional dependencies-F-AC- B- C- D- A- E- C- BRelation R is decomposed into R1 A- B- C and R2C- D then which of the following is correct about this decomposition-

R(A, B, C, D, E) and R_1(A,B,C), R_2(C, D) R_1∪ R_2≠ R attiribute E is not preserve so it is not lossless. A→ E is not present so not dependency preserving. ...

You visited us 1 times! Enjoying our articles? Unlock Full Access!

Byju's Answer

Standard XI

Accountancy

Going Concern Concept

Consider a re...

Question

Consider a relation R (A, B, C, D, E) and functional dependencies:

$F = (A C \to B, C \to D, A \to E, C \to B)$

Relation R is decomposed into
$R_{1} (A, B, C) a n d R_{2} (C, D)$
then which of the following is correct about this decomposition?

Open in App

Solution

R(A, B, C, D, E) and
$R_{1} (A, B, C), R_{2} (C, D)$

$R_{1} \cup R_{2} \neq R$

attiribute E is not preserve so it is not lossless.

$A \to E is not present so not dependency preserving.$

So option (d) is correct.

Suggest Corrections

Similar questions

Q. Consider R(A, B, C, D, E) be a relation schema with the following functional dependencies:

F = {A \to B C, C D \to E, B \to D, E \to A}

Which of the following is true for decomposition of R into (A, B, C) and (C, D, E)?

Q. Consider a relation with five attributes

A B C D E G

. You are given the following dependencies.

A B \to C, A C \to B, A D \to E, B \to D, B C \to A, E \to G

. If relation is decomposed into

A B, B C, A B D E, E G, then find the characteristics

of this decomposition.

Q. Consider a relation R(A, B, C, D, E, F, G) and set of functional dependencies F.

F = {B C D \to A, B C \to E, A \to F, F \to G, C \to D, A \to G}

Number of tables rquiered to decompose R into BCNF is __________

C o n s i d e r a r e l a t i o n R (A, B, C, D, E) w i t h f u n c t i o n a l d e p e n d e n c i e s : N u m b e r o f c a n d i d a t e s k e y i n a b o v e r e l a t i o n R i s______. F = (A E \to C, C D \to E, C \to A, C \to D, D \to E]

Q. Consider relation schema

R (A, B, C, D)

and the two sets of functional dependency:

S_{1} = {A \to B, A B \to C, A C \to D, B \to C, B \to A}

S_{2} = {A B \to D, A C \to B, B \to D, B D \to C}

Which of the following is true?

Join BYJU'S Learning Program

Consider a relation R (A, B, C, D, E) and functional dependencies: F=(AC→B,C→D,A→E,C→B) Relation R is decomposed into R1 (A,B,C) and R2(C,D) then which of the following is correct about this decomposition?

R(A, B, C, D, E) and R1(A,B,C),R2(C,D) R1∪R2≠R attiribute E is not preserve so it is not lossless. A→E is not present so not dependency preserving. So option (d) is correct.

Consider a relation R (A, B, C, D, E) and functional dependencies:

$F = (A C \to B, C \to D, A \to E, C \to B)$

Relation R is decomposed into
$R_{1} (A, B, C) a n d R_{2} (C, D)$
then which of the following is correct about this decomposition?

R(A, B, C, D, E) and
$R_{1} (A, B, C), R_{2} (C, D)$

$R_{1} \cup R_{2} \neq R$

attiribute E is not preserve so it is not lossless.

$A \to E is not present so not dependency preserving.$

So option (d) is correct.