A decomposition is in 3NF if every decomposed relation is in 3NF. A decomposition is in BCNF if every decomposed relation is in BCNF. Let R(A,B,C,D,E,F,G) be a relation with the FDs: F = {CD → G, DG → C, AD→ G, G → A, AB → F}. Consider the decomposition of R into R1(C, D, G), R2(A, D, G), R3(A, B, F) and R4(C, E). Which of the following statements is TRUE about this decomposition? Select one: O Ris in BCNF but Not in 3NF. O R is in 3NF but Not in BCNF.

A decomposition is in 3NF if every decomposed relation is in 3NF. A decomposition is in BCNF if every decomposed relation is in BCNF. Let R(A,B,C,D,E,F,G) be a relation with the FDs: F = {CD → G, DG → C, AD→ G, G → A, AB → F}. Consider the decomposition of R into R1(C, D, G), R2(A, D, G), R3(A, B, F) and R4(C, E). Which of the following statements is TRUE about this decomposition? Select one: O Ris in BCNF but Not in 3NF. O R is in 3NF but Not in BCNF.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Normalization Here is a set of FDs for a relation R {A, B, C, D, E, F, G}; AB BC>DE AEF>G AC>DE a. Compute the closure of {A, C}, i.e. (A, C}* b. What are the candidate keys for R? Justify your answer. c. Is R in BCNF? Justify your answer. d. Give a 3NF decomposition of this relation.
Solve the following:
Consider the relation R = {A, B, C, D, E, F, G, H, I,J} and the set of functional dependencies F = { {A, B} → {C}, {A} → {D, E}, {B} → {F}, {F} →{G, H}, {D} → {I, J} }. (b) Whether (A,B,F} is a super key? Whether {A,B,F} is a candidate key? Why? (c) Whether {A,D} is a super key? Whether {A,D} is a candidate key? Why?
Task 4: Consider the relation schema R(A, B, C, D, E) with the following FDs FD1: {A,B,C} → {D,E} FD2: {B,C,D} → {A,E} FD3: {C} → {D} a) Show that R is not in BCNF. Ans) X = {C} then X+ = {C, D} which is not R therefore X is not a superkey, so R is not in BCNF. b) Decompose R into a set of BCNF relations (describe the process step by step). Ans) FD3 violates BCNF. Decomposing R using FD3. R1(C,D) with FDs: FD3, CK: {C} R2(A,B,C,E) with new FD: {A,B,C}→ E (Decomposed from FD1), CK: {A,B,C} {BC}+ = {BC} - Not a candidate key {ABC}+ = {ABCDE} - A candidate key {BCD}+ = {ABCDE} - A candidate key Candidate Keys = {ABC}, {BCD} The result of the decomposition consists of R1 and R2 %3D %3D
Solve the following:
The division operator of relational algebra, “÷”, is defined as follows. Let r(R)and s(S) be relations, and let S ⊆ R; that is, every attribute of schema S isalso in schema R. Given a tuple t, let t[S] denote the projection of tuple t onthe attributes in S. Then r ÷ s is a relation on schema R − S (that is, on theschema containing all attributes of schema R that are not in schema S). A tuplet is in r ÷ s if and only if both of two conditions hold:• t is in ΠR−S(r)• For every tuple ts in s, there is a tuple tr in r satisfying both of the following:a. tr[S] = ts[S]b. tr[R − S] = tGiven the above definition:a. Write a relational algebra expression using the division operator to findthe IDs of all students who have taken all Comp. Sci. courses. (Hint:project takes to just ID and course id, and generate the set of all Comp.Sci. course ids using a select expression, before doing the division.)b. Show how to write the above query in relational algebra, without usingdivision. (By doing so, you…
Give an example of a relation schema R′ and set F′ of functional dependencies such that there are at least three distinct lossless decompositions of R′ into BCNF.
Consider the schema R = (A, B, C, D, E, G) and the set F of functional dependencies:A → BCBD → ECD → AB Use the BCNF decomposition algorithm to find a BCNF decomposition of R. Start with A → BC. Explain your steps.
2.Consider relation R=(A,B,C,D) with the following FDs: B → C, C > D, and D A a. List all candidate keys of R. b. Is R in 3NF? BCNF? Justify your answer
21. of 40 A decomposition is in 3NF if every decomposed relation is in 3NF. A decomposition is in BCNF if every decomposed relation is in BCNF. Let R(A,B,C,D,E,F,G) be a relation with the functional dependencies: C→ E, EG→ D, DG-→A, and A→ BF. If we decompose R into relations R1(C, D, G), R2(A, D, G), R3(A, B, F), and R4(C, E), which of the following statements is TRUE? Select one: O The decomposition is in BCNF but Not in 3NF. The decomposition is in 3NF and in BCNF. The decomposition is in 3NF but Not in BCNF. O The decomposition is Not in 3NF and Not in BCNF.
Implement in Python / Java Algorithm: Testing for lossless (nonadditive) join property. Input: A universal relation R, a decomposition D = { R1, R2, R3, ….. Rm } of R, and a set F of functional dependencies. 1. Create an initial matrix S with one row i for each relation in Ri in D, and one column j for each attribute Aj in R. 2. Set S(i, j) := bij for all matrix entries. (* each bij is a distinct symbol associated with indices (i, j) * ) {for each column j representing attribute Aj {if (relation Ri includes attribute Aj ) then set S(I, j):=aj;};}; (* each aj is a distinct symbol associated with index (j) *) 3. For each row i representing relation schema Ri {for each functional dependency X → Y in F {for all rows in S which have the same symbols in the columns corresponding to attributes in X {make the symbols in each column that correspond to an attribute in Y be…
Consider the relation R on Z? given by: R = {((a, b), (c, d)) : a +d = c+b} Prove that R is an equivalence relation, and determine 3 elements of [(1,3)], the equivalence class of (1, 3).