Tuple/Record in DBMS

February 4, 2023

Tuple/Record in DBMS

On this page, we will discuss about the Tuples and Records in DBMS.

TUPLE IN DBMS

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 complete information 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 information 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

SQL Query to retrieve particular tuples

SELECT * FROM EMP
WHERE DEPTNO=20;

Output:
4 rows selected.

EMPNO	ENAME	JOB	MGR	HIREDATE	SAL	COMM	DEPTNO
7566	JONES	MANAGER	7839	02-APR-81	2975	–	20
7788	SCOTT	ANALYST	7566	19-APR-87	3000	–	20
7902	FORD	ANALYST	7566	03-DEC-81	3000	–	20
7369	SMITH	CLERK	7902	17-DEC-80	800	500	20

Only those tuples corresponding to the details of Department number 20 are displayed.

What is Database

Participation Constraint

DBMS Architecture

Data Models

Cardinality

RECORD IN DBMS

Each record represents complete information of the specific data item, each record 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 records every each record contains details of that particular employee i.e 1 record for storing the information 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 records

SQL Query to retrieve particular records

SELECT * FROM EMP
WHERE DEPTNO=20;

Output:
4 rows selected.

EMPNO	ENAME	JOB	MGR	HIREDATE	SAL	COMM	DEPTNO
7566	JONES	MANAGER	7839	02-APR-81	2975	–	20
7788	SCOTT	ANALYST	7566	19-APR-87	3000	–	20
7902	FORD	ANALYST	7566	03-DEC-81	3000	–	20
7369	SMITH	CLERK	7902	17-DEC-80	800	500	20

Only those records corresponding to the details of Department number 20 are displayed.

Prime Course Trailer

Related Banners

Get PrepInsta Prime & get Access to all 200+ courses offered by PrepInsta in One Subscription

Get over 200+ course One Subscription

Courses like AI/ML, Cloud Computing, Ethical Hacking, C, C++, Java, Python, DSA (All Languages), Competitive Coding (All Languages), TCS, Infosys, Wipro, Amazon, DBMS, SQL and others

Tuple/Record in DBMS