×
>
<

Aptitude

Tuple

Generally, the database table is viewed as a collection of tuples

The term tuple is often also called row and record in a database table

TUPLE

Each tuple represents a complete record of the specific data item, each tuple stores different data with the same structure

Example : For example in an employee table, we need to store the details of 10 employees then the database table will consist of 10 tuples every each tuple contains details of that particular employee i.e 1 tuple for storing the record of one employee

Consider a sample table ‘emp’.

ENAMEJOBSALHIREDATEHIREDATE+2
KINGPRESIDENT500017-NOV-8119-NOV-81
BLAKEMANAGER285001-MAY-8103-MAY-81
CLARKMANAGER245009-JUN-8111-JUN-81
JONESMANAGER297502-APR-8104-APR-81
SCOTTANALYST300019-APR-8721-APR-87
FORDANALYST300003-DEC-8105-DEC-81
SMITHCLERK80017-DEC-8019-DEC-80

Table contents seven rows i.e it stores the details of all the 7 employees in 7 separate tuples