Database Glossary Terms Beginning With The Letter R
recordAlso called a row or, more historically, a tuple. A recordrepresents a single set of discrete data item in a table. An example of a record in a database table would be the first name, last name and gender of individuals. Each row of data that includes the first name, last name and gender is a complete record.
recordsetA set of records returned by a query or table.
referential integrityAdherence to the rule defined by a relationship. The foreign key value must exist in the set of primary key values; if this condition is not met, then a record change or modification will not be committed to the database. There is one exception: If a foreign key field returns Null, the foreign table records are not prevented from being stored. These records are considered orphaned, since no parent record has been defined.
A specification that states what procedures should be implemented in an application.