Question: 1. What is a partial dependency? With what normal form is it associated?
2. What three data anomalies are likely to be the result of data redundancy? How can such anomalies be eliminated?
3. Define and discuss the concept of transitive dependency.
4. What is a surrogate key, and when should you use one?