Database terminology

Technical terminology:

  • RDBMS: relational database management system 
  • Record: one horizontal row in a database table 
  • Recordset: a selection or limited collection of a number of rows in a database table 
  • Field: a cell in a database table 
  • Field name: the column name of a "column" in a database table 
  • Data type: the type of data that can be stored in a "field." 
  • Auto increment: an id can be automatically incremented by one when you add a new record to a database table 
  • CRUD: you can create, read, update and delete database data. 
  • SQL: structured query language. To execute a CRUD command, you use the SQL language. 
  • Transaction: a single SQL command.
Next page