Question: Q 3 . ( a ) ( 4 % ) What is Deletion Anomaly? Illustrate with an example. ( b ) ( 2 % )
Q
a What is Deletion Anomaly? Illustrate with an example.
b Prove that X A if A is a subset of X according to the definition of functional dependency.
c Give an example of a functional dependency X Y in a relation R where X is not a superkey
in R Give an example of a non functional dependency where X cannot decide Y
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
