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?

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?

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

Consider the relation schema R(A, B, C, D, E, F) and the set S = {AB->C, BC->AD, D->E, C->B) of functional dependencies. Assuming that R is decomposed into the relation schemas R1(A,B), R2(B,C), R3(A,B,D,E) and R4(E,F). Use the Chase test to show if this is a lossless decomposition.
Consider the relation R(A, B, C, D, E), and the decomposition of R into R1(ABC) and R2(ADE).(a) Give a set of functional dependencies (FDs) such that the decomposition into R1 andR2 is lossless join and dependency preserving. Justify why your FDs satisfy the criteria.(b) Give a set of functional dependencies such that the decomposition into R1 and R2 islossless join, but not dependency preserving. Justify why your FDs satisfy the criteria.(c) Give a set of functional dependencies such that the decomposition into R1 and R2 isnot lossless join, but dependency preserving. Justify why your FDs satisfy the criteria.
Consider a relation schema R(A, B, C, D, E, G) and a set of functional dependencies F = {A → C, AD → CE, B → ACD, C → B}. (a) Show the steps of computing a canonical cover for F. (b) Compute the closure of AG and then determine whether or not AG is a candidate key. (c) Determine whether or not (A, E, G) is in BCNF and justify your answer using the transitive closure of a set of attributes. If (A, E, G) is not in BCNF, find a BCNF decomposition of it. (d) Assume that (A, E, G) is decomposed into (A, G) and (E, G). Given the above functional dependencies, is this decomposition always lossless? If so, prove this. Otherwise, explain it using an example (i.e., a case of decomposing a table containg rows and columns into two tables). (e) Assume that R is decomposed into R1(A, B, C, D) and R2(A, E, G). Is this decomposition dependency preserving? Justify your answer.
Consider the following set F of functional dependencies on the relation schema R = (A, B, C, D, E, G,H): A→ D AB→ DE BD→ A AC→ G a) Prove ABCH and BCDH are candidate keys of R. b) Give a lossless BCNF decomposition of R based on the set of functional dependencies (No need to compute the closure). Does the decomposition preserve dependencies? Why or why not? c) Given the following canonical cover: A->D AB->E BD->A AC->G Give a lossless dependency preserving 3NF decomposition of R accordingly. Again, no need to compute the closure.
Consider the relation schema R (A, B, C, D, E, F, G, H) with the set of functional dependencies K = {A→B, B→DE, F→H, G→CE}. Determine all candidate keys of R in a systematic manner (do not use the Armstrong's Axioms) and explain how you determine them. Show each step.
Consider the following set F of functional dependencies on the relation schema(A, B, C, D, E, G):A → BCDBC → DEB → DD → A Give a 3NF decomposition of the given schema based on a canonical cover.
1. A known relationship mode of R (U, F), U= (c, t, h, r, s, g, q); F={c->tq, cs->g, ht->r,hr->c, hs->r}; find the minimum cover of F, then use the Normal Form decompositionalgorithm to standardize this mode to 3NF, and check if the decomposition has thenonadditive join property.
Show that the following decomposition of the schema R of Exercise 7.1 is not alossless decomposition:(A, B, C)(C, D, E).Hint: Give an example of a relation r(R) such that ΠA, B, C (r) ⋈ ΠC, D, E (r) ≠ r
Consider a relation with schema R(A,B,C,D,E,G) and functional dependencies (FDs) C→D; B→A; D→E; E→G ) What is the closure of {B,C}? Show steps of your solution. Find 2 nontrivial FDs that can be inferred from the given FDs set. Explain how you found them. Propose one key for a given schema and FDs. Explain how you found it.
Consider the following set F of functional dependencies on the relation schema(A, B, C, D, E, G):A → BCDBC → DEB → DD → A Prove (using Armstrong’s axioms) that AG is a superkey.
Consider the following set F of functional dependencies on the relation schema(A, B, C, D, E, G):A → BCDBC → DEB → DD → A Compute a canonical cover for this set of functional dependencies F; give each step of your derivation with an explanation.
1.A known relationship mode of R (U, F), U= (A, B, C, D, E, G); F={AB->C, D->EG,C->A, BE->C, BC->D, CG->BD, ACD->B, CE->AG}; find the minimum cover of F,then use the Normal Form decomposition algorithm to decompose this mode to 3NF, andcheck if the decomposition has the nonadditive join property.