Question: Q 3 . ( a ) ( 4 % ) What is Deletion Anomaly? Illustrate with an example. ( b ) ( 2 % )

Q3.
(a)(4%) What is Deletion Anomaly? Illustrate with an example.
(b)(2%) Prove that X -> A, if A is a subset of X, according to the definition of functional dependency.
(c)(4%) 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!