1. Define and discuss the concept of transitive dependency.
2. What three data anomalies are likely to be the result of dataredundancy? How can such anomalies be eliminated?
3. Suppose that someone tells you that an attribute that is partof a composite primary key is also a candidate key. How would yourespond to that statement? Explain.
Expert Answer
An answer will be send to you shortly. . . . .