1. Define and discuss the concept of transitive dependency.
2. What three data anomalies are likely to be the result of data redundancy? How can such anomalies be eliminated?
3. Suppose that someone tells you that an attribute that is part of a composite primary key is also a candidate key. How would you respond to that statement? Explain.