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.