Normalization

Edit Answers
12345678910111213141516171819202122
Across
  1. 3. A type of relationship between attributes. (10 letters)
  2. 7. Problem of having same data in multiple places. (7 letters)
  3. 8. A stricter form of 3NF. (4 letters)
  4. 9. This anomaly occurs when changing data affects multiple rows. (6 letters)
  5. 10. ______ Normal Form removes transitive dependencies. (5 letters)
  6. 11. The process of organizing data to reduce redundancy. (13 letters)
  7. 12. Type of dependency removed in 3NF. (9 letters)
  8. 16. This anomaly occurs when adding new data is hard. (9 letters)
  9. 17. Type of dependency removed in 2NF. (7 letters)
  10. 18. _____ Normal Form removes repeating groups. (5 letters)
  11. 19. ______ Normal Form removes partial dependencies. (6 letters)
  12. 21. This anomaly occurs when deleting data leads to unintended loss. (8 letters)
  13. 22. A unique identifier in a relation. (3 letters)
Down
  1. 1. Unnecessary repetition of data. (10 letters)
  2. 2. The process of splitting tables to achieve normal forms. (13 letters)
  3. 4. The main identifier used to uniquely identify tuples
  4. 5. Opposite of normalization for performance improvement. (15 letters)
  5. 6. A potential primary key (9 letters)
  6. 13. Refers to a key in another table. (7 letters)
  7. 14. table in relational model. (8 letters)
  8. 15. A key made of more than one attribute. (9 letters)
  9. 20. Left-hand side of a functional dependency. (11 letters)