1 Sol.
Given FDs:-
AB->C
BC->D
CD->E
DE->A
AE->B
We have schema S(A,B,C,D)
We compute closure of CD
CD+ = CD
CD+ = CDE (CD->E)
CD+ = CDEA (DE->A)
CD+ = CDEAB (AE->B)
Hence CD->B is correct
Option b.CD->B is correct
2.Sol
Option a.(3,null) is correct
1) what is the correct answer 2) what is the correct answer Consider R(A,B,C,D,E) with FD's:...
Consider the following relation R(A,B,C,D,E,G) and the set of functional dependencies F = { A → BCD BC → DE B → D D → A} Give a 3NF decomposition of the given schema based on a canonical cover
Given the following Schema S = (R, FD) where R = (A, B, C, D, E, F) and FD contains the following dependencies: A -> BC B ->C C -> D D ->E C -> E E -> F DE -> F C -> F 1. Find a minimal cover of F 2. Find a key for the schema 3. Find a 3N decomposition of the schema that satisfies the lossless join decomposition and dependency preservation properties 4. Find 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...
Suppose that you decompose a schema R (A, B, C, D, E) into two schemas as below: R1 (A, B, C) R2 (C, D, E) Show that this decomposition is not a lossless join decomposition. Hint: Take a suitable Relation, r, for the Schema R and show that r is a lossy join decomposition.
Consider the schema R=(A, B, C, D, E) and let the following set F of functional dependencies hold for R: F= {A → BC, CD → E, B D } Problem 3 Suppose that the schema R=(A, B, C, D, E) is decomposed into R/ - (A, B, C) and R=(A, D, E). Show if this decomposition is a lossless decomposition with respect to the given set of functional dependencies F.
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
Given the following relation schemas and the sets of FD's: a- R(A,B,C,D) F={ABẠC,C7D, D´A, BC+C} b- R(A,B,C,D) F={BẠC, BD, AD>B} C- R(A,B,C,D) F={AB-C, DC+D, CD+A, AD+B} d- R(A,B,C,D) F={AB=C, C+D, D™B, DE} e- R(A, B, C, D, E) F= {AB+C, DB+E, AE>B, CD+A, ECD} In each case, (i) Give all candidate keys (ii) Indicate the BCNF violation Give the minimal cover and decompose R into a collection of relations that are BCNF. Is it lossless? Does it preserve the dependencies?...
R Consider an instance of relation R below A B C D E 5 5 5 5 5 5 5 5 5 4 5 2 4 5 2 4 1 4 5 5 5 4 2. 5 4 4 1 2 4 2 What would possibly be a candidate key of relation R? (2 points) Select one: AE BC BD CD All of the above. None of the above.
Consider a relation R(A,B,C,D,E) with the following functional dependencies: 8. AB C BCD CDE DEA (a) Specify all candidate keys for R. (b) Which of the given functional dependencies are Boyce-Codd Normal Form (BCNF) violations'? (c) Give a decomposition of R into BCNF based on the given functional dependencies. (d) Give a different decomposition of R into BCNF based on the given functional dependencies. (e) Give a decomposition of R into 3NF based on the given functional dependencies.
R Consider an instance of relation R below A B C D E 5 5 5 5 5 5 5 LO bs 5 4 5 2 4 5 2 5 5 4 1 4 5 4 2 5 4 4 1 2 4 2 What would possibly be a candidate key of relation R? (2 Points) Select one: O AE BC BD CD All of the above. None of the above.