I have heard my professor saying that when X → Y is a functional dependency, adding any attribute to X or removing any attribute from Y will still yield a functional dependency. I do not understand how this could be true? If I add any attribute into X, how could it imply the same Y?
2026-02-25 12:18:26.1772021906
Functional dependency - adding any attribute to X will still yield a FD?
43 Views Asked by Bumbble Comm https://math.techqa.club/user/bumbble-comm/detail At
1
There are 1 best solutions below
Related Questions in LOGIC
- Theorems in MK would imply theorems in ZFC
- What is (mathematically) minimal computer architecture to run any software
- What formula proved in MK or Godel Incompleteness theorem
- Determine the truth value and validity of the propositions given
- Is this a commonly known paradox?
- Help with Propositional Logic Proof
- Symbol for assignment of a truth-value?
- Find the truth value of... empty set?
- Do I need the axiom of choice to prove this statement?
- Prove that any truth function $f$ can be represented by a formula $φ$ in cnf by negating a formula in dnf
Related Questions in RELATION-ALGEBRA
- Relational Algebra, find every author who co-authored with every other?
- Relational Algebra Operator Tree
- Is it legal to use the cardinality of a universal quantifier in relational calculus?
- Such thing as inverse/undo "search" or "filter" operator
- How to find exactly $2$ events that from events list that meet certain criteria in tuple relational calculus?
- Why are homomorphisms of graphs/relations defined the way they are?
- Is there a name for this sort-of-inverse function?
- Difference between $A\to B\to C$ and $A\to(B\to C)$
- Functional dependency - adding any attribute to X will still yield a FD?
- Relational Algebra : Cross Product of a Relation with Table-Dum & Table-Dee
Trending Questions
- Induction on the number of equations
- How to convince a math teacher of this simple and obvious fact?
- Find $E[XY|Y+Z=1 ]$
- Refuting the Anti-Cantor Cranks
- What are imaginary numbers?
- Determine the adjoint of $\tilde Q(x)$ for $\tilde Q(x)u:=(Qu)(x)$ where $Q:U→L^2(Ω,ℝ^d$ is a Hilbert-Schmidt operator and $U$ is a Hilbert space
- Why does this innovative method of subtraction from a third grader always work?
- How do we know that the number $1$ is not equal to the number $-1$?
- What are the Implications of having VΩ as a model for a theory?
- Defining a Galois Field based on primitive element versus polynomial?
- Can't find the relationship between two columns of numbers. Please Help
- Is computer science a branch of mathematics?
- Is there a bijection of $\mathbb{R}^n$ with itself such that the forward map is connected but the inverse is not?
- Identification of a quadrilateral as a trapezoid, rectangle, or square
- Generator of inertia group in function field extension
Popular # Hahtags
second-order-logic
numerical-methods
puzzle
logic
probability
number-theory
winding-number
real-analysis
integration
calculus
complex-analysis
sequences-and-series
proof-writing
set-theory
functions
homotopy-theory
elementary-number-theory
ordinary-differential-equations
circles
derivatives
game-theory
definite-integrals
elementary-set-theory
limits
multivariable-calculus
geometry
algebraic-number-theory
proof-verification
partial-derivative
algebra-precalculus
Popular Questions
- What is the integral of 1/x?
- How many squares actually ARE in this picture? Is this a trick question with no right answer?
- Is a matrix multiplied with its transpose something special?
- What is the difference between independent and mutually exclusive events?
- Visually stunning math concepts which are easy to explain
- taylor series of $\ln(1+x)$?
- How to tell if a set of vectors spans a space?
- Calculus question taking derivative to find horizontal tangent line
- How to determine if a function is one-to-one?
- Determine if vectors are linearly independent
- What does it mean to have a determinant equal to zero?
- Is this Batman equation for real?
- How to find perpendicular vector to another vector?
- How to find mean and median from histogram
- How many sides does a circle have?
Informally, this is because if we know that the values of a set of attributes $X$ uniquely determine the values of a set of attributes $Y$, then obviously the values of some set $X' \supset X$ of attributes also determines the values of attributes $Y$ uniquely. And if the values of all attributes in $Y$ are determined uniquely, so are, of course, the values of all attributes in $Y' \subset Y$.
Formally, if $X$ of $n$-tuples, functional dependency $$ (x_1,\ldots,x_k) \to (x_{n-l+1},\ldots,x_n) $$ means that whenever two tuples in $X$ have the same first $k$ components, they also have the same last $l$ components, i.e. that $$ \text{For all }x,y\in X \,:\, x_1=y_1,\ldots,x_k=y_k \,\Rightarrow\, x_{n-l+1}=y_{n-l+1},\ldots,x_n=y_n $$
Now, if we replace $k$ by $k' \geq k$ and $l$ by $l' \leq l$, which amounts to adding attributes to the left-hand side and removing attribute from the right-hand side of the function dependency, that statement remains true. Observe that obviously $$\begin{eqnarray} x_1&=&y_1,&\ldots&,x_{k'}&=&y_{k'} &\Rightarrow& x_1&=&y_1,&\ldots&,x_k&=&y_k &\text{ if $k \leq k'$} \\ x_{n-l+1}&=&y_{n-l+1},&\ldots&,x_n&=&y_n &\Rightarrow& x_{n-l'+1}&=&y_{n-l'+1},&\ldots&,x_n&=&y_n &\text{ if $l' \leq l$,} \end{eqnarray}$$ and by combining that with the definition of functional dependency above, we get (again assuming $k \leq k'$, $l' \leq l$) that $$ \begin{eqnarray} \text{For all }x,y\in X \,:& x_1=y_1,\ldots,x_{k'}=y_{k'} \\ \Rightarrow& x_1=y_1,\ldots,x_k=y_k \\ \Rightarrow& x_{n-l+1}=y_{n-l+1},\ldots,x_n=y_n \\ \Rightarrow& x_{n-l'+1}=y_{n-l'+1},\ldots,x_n=y_n \text{.} \end{eqnarray} $$ Leaving out the middle part of the chain of implications yields exactly what we wanted $$ \text{For all }x,y\in X \,:\, x_1=y_1,\ldots,x_{k'}=y_{k'} \,\Rightarrow\, x_{n-l'+1}=y_{n-l'+1},\ldots,x_n=y_n \text{.} $$