14 relations: Column (database), Data integrity, Data validation, Database trigger, Isolation (database systems), Null (SQL), Predicate (mathematical logic), Relational database management system, Row (database), Select (SQL), SQL, Table (database), Update (SQL), Where (SQL).
In a relational database, a column is a set of data values of a particular simple type, one value for each row of the database.
Data integrity is the maintenance of, and the assurance of the accuracy and consistency of, data over its entire life-cycle, and is a critical aspect to the design, implementation and usage of any system which stores, processes, or retrieves data.
In computer science, data validation is the process of ensuring data have undergone data cleansing to ensure they have data quality, that is, that they are both correct and useful.
A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database.
In database systems, isolation determines how transaction integrity is visible to other users and systems.
Null (or NULL) is a special marker used in Structured Query Language to indicate that a data value does not exist in the database.
In mathematical logic, a predicate is commonly understood to be a Boolean-valued function P: X→, called the predicate on X. However, predicates have many different uses and interpretations in mathematics and logic, and their precise definition, meaning and use will vary from theory to theory.
A relational database management system (RDBMS) is a database management system (DBMS) based on the relational model invented by Edgar F. Codd at IBM's San Jose Research Laboratory.
In the context of a relational database, a row—also called a tuple—represents a single, implicitly structured data item in a table.
The SQL SELECT statement returns a result set of records from one or more tables.
SQL (S-Q-L, "sequel"; Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).
A table is a collection of related data held in a structured format within a database.
An SQL UPDATE statement changes the data of one or more records in a table.
A WHERE clause in SQL specifies that a SQL Data Manipulation Language (DML) statement should only affect rows that meet specified criteria.