What is a candidate key?

What is a candidate key? Describe three types of anomalies that can arise in a table and the negative consequences of each. Fill in the blanks in each of the following statements: A relation that has no partial functional dependencies is in ______ normal form. A relation that has no transitive dependencies is in ______ normal form. A relation that has no multivalued attributes is in ______ normal form. Describe the most common way in which relationships in an E-R diagram are expressed in a corresponding relational data model. What is the primary purpose of normalization? List three conditions that you can apply to determine whether a relation that is in first normal form is also in second normal form. What are the benefits of enforcing the integrity constraints as part of the database design and implementation process (instead of doing it in application design)? How do you represent a 1:M unary relationship in a relational data model? How do you represent an associative entity in a relational data model?