1. 14 points] Match the following terms with the description that most closely matches it. Term A. Atomicity B. C. Isolation D. Durability 1. The effect on the database of a transaction is never lost, once the transaction has completed. Consistency 2. Transactions appear to be executed as if no other transaction is executing at the same time 3. All-or-nothing execution of transactions 4. The database does not violate integrity constraints or other stated expectations. 2. [5 points] What is the importance of keys in a relational database? Explain each of the following types of keys: Super key . Candidate key Primary key Foreign key