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
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
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’.
ENAME | JOB | SAL | HIREDATE | HIREDATE+2 |
KING | PRESIDENT | 5000 | 17-NOV-81 | 19-NOV-81 |
BLAKE | MANAGER | 2850 | 01-MAY-81 | 03-MAY-81 |
CLARK | MANAGER | 2450 | 09-JUN-81 | 11-JUN-81 |
JONES | MANAGER | 2975 | 02-APR-81 | 04-APR-81 |
SCOTT | ANALYST | 3000 | 19-APR-87 | 21-APR-87 |
FORD | ANALYST | 3000 | 03-DEC-81 | 05-DEC-81 |
SMITH | CLERK | 800 | 17-DEC-80 | 19-DEC-80 |
Table contents seven rows i.e it stores the details of all the 7 employees in 7 separate tuples