Across
- 2. process of restoring the database to a correct state after failure (10 letters) → RECOVERY
- 7. form that removes transitive dependency (3 letters) → 3NF
- 8. Across
- 9. clause used to group rows with same values (5 letters) → GROUP
- 10. of join that returns all rows from the left table and matched rows from the right table (9 letters) → LEFTJOIN
Down
- 1. used to avoid deadlock by assigning a timestamp to each transaction (10 letters) → TIMESTAMP
- 3. transaction properties of atomicity, consistency, isolation, and durability (4 letters) → ACID
- 4. that no other transaction can access data being used by another transaction (9 letters) → LOCKING
- 5. level of abstraction describing how data is stored (7 letters) → PHYSICAL
- 6. to uniquely identify records across multiple tables (11 letters) → FOREIGNKEY
