| No. | Item | Definition |
|---|---|---|
| 1. | ACID | Core transaction reliability properties |
| 2. | aggregate | A summary calculation function |
| 3. | alias | A temporary query name |
| 4. | anomaly | Problem caused by poor design |
| 5. | associative entity | Entity representing a relationship |
| 6. | atomicity | All-or-nothing transaction property |
| 7. | attribute | A property of an entity |
| 8. | backup | Saved copy for recovery |
| 9. | BLOB | Binary large object data |
| 10. | boolean | True-or-false data type |
| 11. | business key | Meaningful real-world unique identifier |
| 12. | candidate key | Possible choice for primary key |
| 13. | cardinality | Number of related instances |
| 14. | column | A named field in a table |
| 15. | commit | Making transaction changes permanent |
| 16. | composite key | Key made from multiple columns |
| 17. | constraint | A rule limiting allowed data |
| 18. | count | Function returning number of rows |
| 19. | cursor | Pointer for row-by-row processing |
| 20. | database | An organized collection of data |
| 21. | datatype | The kind of value stored |
| 22. | date | Calendar day data type |
| 23. | DELETE | SQL command to remove rows |
| 24. | denormalization | Adding redundancy for performance |
| 25. | dependency | One attribute relying on another |
| 26. | DISTINCT | SQL keyword removing duplicates |
| 27. | domain | Allowed set of values |
| 28. | encryption | Protecting data by encoding |
| 29. | entity | A distinct thing being modeled |
| 30. | ERD | Entity-relationship diagram |
| 31. | ETL | Extract, transform, and load process |
| 32. | execution plan | Steps used to run query |
| 33. | expression | A combination producing a value |
| 34. | fact table | Central table of measurements |
| 35. | field | A single data attribute |
| 36. | foreign key | A key referencing another table |
| 37. | FROM | SQL source table clause |
| 38. | function | Routine returning a value |
| 39. | functional dependency | Attribute determined by another attribute |
| 40. | GROUP BY | SQL clause grouping rows |
| 41. | HAVING | SQL filter for groups |
| 42. | identifier | Attribute distinguishing each entity |
| 43. | identity | Auto-generated numeric identifier |
| 44. | index | A structure speeding data retrieval |
| 45. | INSERT | SQL command to add rows |
| 46. | integrity | Overall correctness of stored data |
| 47. | isolation | Transaction separation from others |
| 48. | join | Combining rows from multiple tables |
| 49. | junction table | Table resolving many-to-many links |
| 50. | key | A field identifying or linking data |
| 51. | literal | A fixed value written directly |
| 52. | lock | Mechanism controlling concurrent access |
| 53. | many-to-many | Relationship linking many on both sides |
| 54. | metadata | Data describing other data |
| 55. | migration | Controlled schema or data change |
| 56. | model | Abstract representation of data |
| 57. | natural key | Key from real data |
| 58. | normalization | Organizing data to reduce redundancy |
| 59. | NULL | Marker for missing or unknown |
| 60. | OLTP | System for transactional processing |
| 61. | one-to-many | Relationship linking one to many |
| 62. | one-to-one | Relationship linking single pairs |
| 63. | operator | A symbol performing an action |
| 64. | optimizer | Component choosing query plans |
| 65. | ORDER BY | SQL clause sorting results |
| 66. | parameter | A supplied input value |
| 67. | partition | A separated piece of a table |
| 68. | predicate | A condition evaluating true or false |
| 69. | primary key | The main unique identifier |
| 70. | procedure | Stored routine performing operations |
| 71. | projection | Selecting specific columns |
| 72. | query | A request for data |
| 73. | record | A stored set of related fields |
| 74. | redundancy | Unnecessary repeated data storage |
| 75. | referential integrity | Consistency of related key values |
| 76. | relationship | An association between entities |
| 77. | replica | A copied database instance |
| 78. | replication | Copying data between systems |
| 79. | restore | Returning data from backup |
| 80. | row | A single record in a table |
| 81. | schema | The database’s structural design |
| 82. | SELECT | SQL command to read data |
| 83. | sequence | Object generating ordered numbers |
| 84. | SQL | Language for relational databases |
| 85. | subquery | A query inside another query |
| 86. | sum | Function adding numeric values |
| 87. | superkey | Columns uniquely identifying rows |
| 88. | surrogate key | Artificial key with no business meaning |
| 89. | table | A structure storing rows and columns |
| 90. | timestamp | Stored date and time value |
| 91. | transaction | A unit of database work |
| 92. | trigger | Automatic action on data events |
| 93. | tuple | A row in relational theory |
| 94. | UNION | SQL operator combining results |
| 95. | UPDATE | SQL command to modify rows |
| 96. | varchar | Variable-length text type |
| 97. | view | A virtual table from a query |
| 98. | warehouse | Database for analysis and reporting |
| 99. | weak entity | Entity needing another’s key |
| 100. | WHERE | SQL filter condition clause |
