×

Courses

Chapters

>
<

DBMS

DBMS Tuple | CrackEase

Tuple

Tuple illustration

In a relational database, a tuple is a single entry (also called a row or record) in a table.

The terms tuple, row, and record are often used interchangeably.

TUPLE

Row example diagram

Each tuple represents a complete record for a specific entity. All tuples in a table share the same structure (columns), but each holds different data.

Example: An employee table storing 10 employees will contain 10 tuples — one tuple per employee.

Consider the sample table emp below:

ENAME JOB SAL HIREDATE HIREDATE+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

This table contains seven rows — i.e., seven tuples — each storing details of one employee.

Footer Content | CrackEase
→
←