Consider the following sets of functional dependencies over a relation R(A,B,C). F1 = {A → B, B C} F2 = {A → B, A C} F3 = {A B, AB C} Which of these sets are equivalent? (Two sets of functional dependencies (FDs) F and F' are equivalent if all FDs in F' follow from the ones in F, and all FDs in F follow from the ones in F'.)

Consider the following sets of functional dependencies over a relation R(A,B,C). F1 = {A → B, B C} F2 = {A → B, A C} F3 = {A B, AB C} Which of these sets are equivalent? (Two sets of functional dependencies (FDs) F and F' are equivalent if all FDs in F' follow from the ones in F, and all FDs in F follow from the ones in F'.)

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 a relation R(A,B,C,D,E) with functional dependencies AB→C, A→D, and D→E. (a) What are the keys for R?(b)What is the closure A, that is A+ ? What is the closure AB, that is (AC)+ ?
Consider a relation R(A,B,C,D,E) with functional dependencies AB→C, A→D, and D→E. (a) What are the keys for R? (b) What is the closure A, that is A+ ? What is the closure AB, that is (AB)+ ?
1. Consider a relation schema R1(A, B, C, D) that satisfies the set of functional dependencies F1 ={A→B, B→C, C→A}.a) Calculate A + and (AC)+b) Can AB→ C? Justify your answer.c) Find all the candidate keys of R1 using F1 and show your steps to find them. 2. Consider a relation schema R2(A, B, C, D) that satisfies the set of functional dependencies F2 = {A→B, C→D, D→AC}.a) Is (AD) is candidate key of R2? Justify your answer.b) Is R2 in BCNF? Explain the reason to your answer.c) If R2 is not in BCNF, give a lossless-join BCNF decomposition of R2. Is this decomposition dependency preserving? 3. Consider a relation schema R3(A, B, C, D, E) that satisfies the set of functional dependencies F3 = {A → BC, AC → BD}.a) Calculate (AC)+ and (AE)+b) Is AB → C in F3 +? Justify your answer.c) Find the canonical cover Fc of F3.d) Is R3 in 3NF? Explain the reason to your answer. If R3 is not in 3NF, give a lossless-join, dependency preserving 3NF decomposition of R3.
Given a relation R( P, Q, R, S, T, U, V, W, X, Y) and Functional Dependencyset FD = { PQ → R, P → ST, Q → U, U → VW, and S → XY}, determine whetherthe given R is in 3NF? If not convert it into 3 NF.
Consider the universal relation: R = (A, B, C, D, E, F, G, H, I, J) and the set of functional dependencies: A, B -> C B, D -> E, F A, D -> G, H A -> I H -> J What is the key for R? And Decompose R into 2NF, and then into 3NF relations.
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(A, B, C, D, E, G):A → BCDBC → DEB → DD → A Compute B+.
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.
Let's suppose, a relation R=(A, B, C, D, E. H) with a set of functional dependencies F: (AE->BC, B ->AD, CD->E, E→CD, A->E) is given. Relation R (A, B, C, D, E, H) is decomposed into R1 (A, B, C, D) and R2 (A, B, E, H). Find out whether the decomposition is lossless or not, and whether it is dependency preserving or not.
Given a relation R(P ,Q ,R ,S, T, U,V,W, X,Y) and functional dependency set FD = {PQ→R,P→ST,Q→U,U→VW and S→XY} determine whether the given R is in 3NF? If not convert it into 3NF?
Consider the Relation R4 = (A,C,B,D,E,F), with Functional Dependencies: A -> B, C -> D, E -> D. What is the Candidate Key for R4?
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.