Tuple in DBMS
FREE
Overview
Tuples are one of the most used items in Database Management Systems(or DBMS). A Tuple in DBMS is just a row having inter-related data about a particular entity(it can be any object). This data is spread across some columns having various attributes such as name, age, gender, marks, etc. It should be noted that Tuples are mostly seen in Relational Databases Management Systems(RDBMS) as RDBMS works on the relational model (Tabular format).
What Is Tuple In DBMS?
In DBMS(Database Management System), most of the time, we need to store the data in tabular format . This kind of data storage model is also called a Relational model, and the system which leverages the relational model is called Relational Database Management System (RDBMS). These relations (or tables) consist of rows and columns. But in DBMS, we call these rows 'Tuples' and a row 'Tuple'.
Let us see Tuple in DBMS in detail. Let us understand this with the help of a real-life example.
Example Of Single Record Or Tuple
Consider the table given below. We have data of some students like their id, name, age, etc., here, each row has almost all the information of the respective student. The first row has all the information about a student named "Sufiyan". Similarly, all other rows contain information about other students. Hence, a single row is also termed a "record" as it contains all the information of a student. This row or record is termed a Tuple in DBMS. Hence Tuple in DBMS is just a row representing some inter-related data of a particular entity such as student, employee, user, etc.
Table for reference:
| ID | Name | Age | Subject | Marks |
|---|---|---|---|---|
| 1 | Sufiyan | 21 | Maths | 80 |
| 2 | Akash | 23 | Physics | 90 |
| 3 | Robin | 29 | Chemistry | 75 |
| 4 | Alina | 24 | Biology | 95 |
A Tuple from the above-given table
In the above-given image, you can see that a Tuple is just a row having attributes of a particular entity like name, age, marks, etc.
Conclusion
- A Tuple in DBMS is just a row that contains inter-related data about a particular entity.
- Tuple is also called record in DBMS.
- Tuples are mostly used in Relational Databases Management Systems (RDBMS).