Let R(A,B,C,D,E) be a relation with FDs F = {AB-CD, A-E, C-D, DE} The decomposition of...

Question

Question

Let R(A,B,C,D,E) be a relation with FDs F = {AB-CD, A-E, C-D, DE} The decomposition of R into R1(A, B, C), R2(B, C, D) and R3

Answer 1

Answer #1

Answer:

Lossless and Not Dependency Preserving

Explanation: It is lossless because Att(R1) U Att(R2) U Att(R3) = ABCDE = Att(R)

It is Not Dependency Preserving because (AB->CD, A->E, C->D, D->E) cannot be ensured in R1(A,B,C), R2(B,C,D) and R3(C,D,E)

Answer 2

Similar Homework Help Questions

Let R(A,B,C,D,E) be a relation with FDs F = {AB-CD, A-E, C-D, D-E} The decomposition of...

Let R(A,B,C,D,E) be a relation with FDs F = {AB-CD, A-E, C-D, D-E} The decomposition of Rinto R1(A, B, C), R2(B, C, D) and R3(C, D, E) is 2 Points) Select one: Lossless and Dependency Preserving. Lossy and Not Dependency Preserving. Lossless and Not Dependency Preserving. Lossy and Dependency Preserving.
Let R(A,B,C,D,E) be a relation with FDs F = {AB-CD, A-E, C-D, D-E} The decomposition of...

Let R(A,B,C,D,E) be a relation with FDs F = {AB-CD, A-E, C-D, D-E} The decomposition of Rinto R1(A, B, C), R2(B, C, D) and R3(C, D, E) is 2 Points) Select one: Lossless and Dependency Preserving. Lossy and Not Dependency Preserving. Lossless and Not Dependency Preserving. Lossy and Dependency Preserving.
Find the decopmosition of R into R1(A, B, C), R2(B, C,D ) and R3(C, D, E)...

Find the decopmosition of R into R1(A, B, C), R2(B, C,D ) and R3(C, D, E) Let R(A,B,C,D,E) be a relation with FDs F = {AB-CDAE, C-D, D-E} The decomposition of R into R1(A, B, C), R2(B, C, D) and RP(C, D, E) is (2 Points) Select one: Lossy and Not Dependency Preserving. Lossless and Not Dependency Preserving. Lossy and Dependency Preserving. Lossless and Dependency Preserving.

Let R(A, B, C, D, E) be a relation wit FDs F = {AB->C, CD->E, E->B,...

Let R(A, B, C, D, E) be a relation wit FDs F = {AB->C, CD->E, E->B, CE->A}.... Question 4 Not yet answered Marked out of 2.00 P Flag question Let R(A,B,C,D,E) be a relation with FDs F = {AB-C, CD-E, E-B, CE-A} Consider an instance of this relation that only contains the tuple (1, 1, 2, 2, 3). Which of the following tuples can be inserted into this relation without violating the FD's? (2 points) Select one: 0 (0, 1,...
Let R(A,B,C,D,E) be a relation with FDs F = {AB-C, CD-E, E–B} (2 Points) Select one:...

Let R(A,B,C,D,E) be a relation with FDs F = {AB-C, CD-E, E–B} (2 Points) Select one: O Ris in 3NF but not in BCNF. O Ris not in 3NF but in BCNF. O Ris in 3NF and in BCNF. R is not in 3NF and not in BCNF.
Let R(A,B,C,D,E) be a relation with FDs F = {AB-C, CD-E, E-B, CE-A} Consider an instance...

Let R(A,B,C,D,E) be a relation with FDs F = {AB-C, CD-E, E-B, CE-A} Consider an instance of this relation that only contains the tuple (1, 1, 2, 2, 3). Which of the following tuples can be inserted into this relation without violating the FD's? (2 points) Select one: O (0, 1, 2, 4,3) (1,1,2,2,4) (1.2.2, 2, 3) o (1,1,3,2,3) All of the above can be inserted. None of the above can be inserted.

my choices for these are wrong. 10 points QUESTION 3 Given R=(A, B, C) is a...

my choices for these are wrong. 10 points QUESTION 3 Given R=(A, B, C) is a schema and F = {2C-A AB) is a set of FDs that hold on R. Which of the following statements is not true? d=(AB. AC) is a decomposition of that is in BCNF. O Ris in 3NF O BC is a candidate key for R Ris in BCN 10 points QUESTION 4 Given R= (A. 3. CD. E) is a schema and F= (A...
Consider the following relation R= {A, B, C, D, E} and the following set of functional...

Consider the following relation R= {A, B, C, D, E} and the following set of functional dependencies F={ A → BC CD → E B + D E + A} Give a lossless, dependency-preserving decomposition into 3NF of schema R
This question is from the subject: Database Systems QUESTION 8 Consider the relation R(A,B,C,D,E,F) with FDs...

This question is from the subject: Database Systems QUESTION 8 Consider the relation R(A,B,C,D,E,F) with FDs A -> C,B->D, C-> E, D -> F. Consider the BCNF status of R. Which of the following could be correct given the information above? 1. Ris in BCNF already. 2. Ris not in BCNF. It must be divided into R1(A,C,E) with FDs A->C, C-> E, and R2(B,D,F) with FDs B -> D, D -> F. 3. R is not in BCNF. It must...

5. [5 points] Let relation R (A, B, C, D, E) satisfy the following functional dependencies:...

5. [5 points] Let relation R (A, B, C, D, E) satisfy the following functional dependencies: AB → C BC → D CD → E DE → A AE → B Which one of the following FDs is also guaranteed to be satisfied by R? A. B. BCD → A A-B D. CE → B