database management system

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