 | This article has multiple issues. Please helpimprove it or discuss these issues on thetalk page.(Learn how and when to remove these messages) (Learn how and when to remove this message)
|
In arelational database, arow or "record" or "tuple", represents a single, implicitly structureddata item in atable. A database table can be thought of as consisting of rows andcolumns.[1] Each row in a table represents a set of related data, and every row in the table has the same structure.
For example, in a table that represents companies, each row might represent a single company. Columns might represent things like company name, address, etc. In a table that representsthe association of employees with departments, each row would associate one employee with one department.
The implicit structure of a row, and the meaning of the data values in a row, requires that the row be understood as providing a succession of data values, one in each column of the table. The row is then interpreted as arelvar composed of a set oftuples, with each tuple consisting of the two items: the name of the relevant column and the value this row provides for that column.
Each column expects a data value of a particulartype.
For example, one column might require a uniqueidentifier, another might require text representing a person's name, another might require an integer representing hourly pay indollars.
| Types | |
|---|---|
| Concepts | |
| Objects | |
| Components | |
| Functions | |
| Related topics | |
