DATABASE TERMINOLOGY

1234567891011121314151617181920212223
Across
  1. 1. Ensuring consistency of data across tables
  2. 5. A complete row in an Entity
  3. 7. A transaction is permanent once executed and should remain regardless of external events
  4. 8. Execution of transactions should lead to the same result as if they were done sequentially
  5. 10. Data is the same when found in other entities
  6. 13. Unnecessary reptition of data
  7. 14. A piece of information about an Entity
  8. 15. A primary key that is made up of more than one field
  9. 17. A database that is made up of several linked tables
  10. 18. Prevents simultaneous access to records to prevent inconsistency after transactions
  11. 19. Entities contain only atomic values
  12. 20. Unique Identifier for each record
  13. 22. Each entity can only be linked to one other entity
  14. 23. A transaction must maintain the referential integrity between related entities
Down
  1. 2. Producing the best model for a relational database
  2. 3. No non-key Dependency
  3. 4. When a primary key appears in another table, used to link them
  4. 6. Allows databases to be searched quickly via an index
  5. 9. A transaction must be processed in its entirety or not
  6. 11. A single logical operation executed on a database
  7. 12. One Entity can be linked to many other entities
  8. 16. No Partial Key Dependency
  9. 19. A database that consists of a single entity
  10. 21. Technical name for a table