Datubāžu jēdzieni, skaidrojumi

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
Across
  1. 4. A graphical representation of entities and relationships
  2. 5. A query inside another query
  3. 7. command is used to sort the data returned in descending order
  4. 10. command is used with WHERE to include rows where either condition is true
  5. 14. specifies the values of an INSERT INTO statement
  6. 19. Code that runs automatically when an event occurs
  7. 20. Database organized by relations or tables
  8. 23. Temporary storage for quick access
  9. 25. A property or field of an entity
  10. 29. Returns all records from the left table
  11. 31. used to group the result set
  12. 32. used to add a column in an existing table
  13. 33. A popular open-source relational database
  14. 36. command is used to execute a stored procedure
  15. 39. Non-relational database model
  16. 40. A structured collection of data stored electronically
  17. 43. Returns matching records from two tables
  18. 44. command is used to test for non-empty values (NOT NULL values)
  19. 45. Returns the length of a string
  20. 48. A link between two or more tables
  21. 50. The accuracy and consistency of data
  22. 51. A rule enforced on data
Down
  1. 1. A request for data from a database
  2. 2. command is used to update existing rows in a table
  3. 3. Returns a number as string
  4. 5. The structure that defines tables and relationships
  5. 6. To bring back data from a backup
  6. 8. A field or attribute in a table
  7. 9. To undo changes from a transaction
  8. 11. A unique identifier for a record
  9. 12. A field that links two tables
  10. 13. command filters a result set to include only records that fulfill a specified condition
  11. 15. Structured Query Language
  12. 16. limits the value that can be placed in a column
  13. 17. command is used in a WHERE clause to search for a specified pattern in a column
  14. 18. A copy of database data for recovery
  15. 21. command is used to sort the data returned in ascending order
  16. 22. A data structure to speed up queries
  17. 24. Returns all records from the right table
  18. 26. A set of data organized in rows and columns
  19. 27. is used with WHERE to only include rows where both conditions is true
  20. 28. A single record in a table
  21. 30. command is used to sort the result set in ascending or descending order
  22. 34. command is used with UPDATE to specify which columns and values that should be updated in a table
  23. 35. Returns all records when there is a match in either table
  24. 37. To save changes made in a transaction
  25. 38. Copying data from one database to another
  26. 41. Extremely large and complex data sets
  27. 42. Combining data from multiple tables
  28. 46. Formats a value with the specified format
  29. 47. A real-world object represented in a database
  30. 49. Combines results of two queries