In a Database Management System (DBMS), especially in the relational model, data is stored in the form of tables called relations. A tuple is a single row or record of a relation. In other words, each horizontal row of a table is called a tuple, and it represents one complete record — for example, the details of one student or one employee. Understanding the term tuple, along with related terms like attribute, degree and cardinality, is basic to learning the relational database model.
A tuple is a single row or record of a relation (table) in a DBMS.
A tuple is also called a record or a row.
Each tuple contains one value for each attribute (column).
An attribute is a column; a tuple is a row.
Degree = number of attributes (columns) in a relation.
Cardinality = number of tuples (rows) in a relation.
Each tuple is usually uniquely identified by a primary key.
A tuple is a single row of a relation (table) in a DBMS. Each tuple contains a set of related values, one for each attribute (column), and together they describe one entity or record.
For example, in a STUDENT table:
Roll No | Name | Class 1 | Aman | 10 2 | Riya | 9
Here, the row '1, Aman, 10' is one tuple, and '2, Riya, 9' is another tuple. Each tuple gives the complete information about one student.
A tuple is also called a record or a row.
Example: In the STUDENT table above, there are 3 columns (Roll No, Name, Class), so the degree is 3; and there are 2 rows, so the cardinality is 2.
So, the tuple is the basic unit of data storage in a relational database.
A tuple in DBMS is a single row or record of a relation (table) in the relational model. It contains a set of related values — one for each attribute (column) — that together describe one entity, such as the details of one student or one employee. A tuple is also called a record or a row.
A tuple is a horizontal row of a relation, representing one complete record. An attribute is a vertical column of the relation, representing one property or field (such as 'Name' or 'Class'). In short, a tuple is a row and an attribute is a column.
Degree is the number of attributes (columns) in a relation, and cardinality is the number of tuples (rows) in a relation. For example, a table with 3 columns and 5 rows has a degree of 3 and a cardinality of 5.
Yes. In the relational model of a DBMS, a tuple is the same as a row of a table. It is also called a record. Each tuple/row holds one complete set of related data values for all the attributes of the relation.
Difference Between Call by Value and Call by Reference
Learn the difference between Call by Value and Call by Reference in programming (C/C++). Understand memory allocation, variable changes, and pointers.
What is the Full Form of CCD in Technology?
Learn the full form of CCD in technology. Understand what a Charge-Coupled Device is and how it revolutionized digital cameras and astrophotography.
What is the Full Form of CCU in Hospitals?
Learn the full form of CCU (Coronary Care Unit) in medical terms. Understand the difference between an ICU and a CCU in a hospital.
What is the Full Form of CD in Computers?
Learn the full form of CD in computer terminology. Understand how a Compact Disc stores data optically and the difference between CD-ROM, CD-R, and CD-RW.
What are Cloud Computing Deployment Models?
Learn about the 4 main cloud computing deployment models: Public, Private, Hybrid, and Community Cloud. Understand their differences and uses.
Turn this guide into revision flashcards, a practice exam, or an AI-generated podcast — free, no signup required.