what is tuple in dbms

1 year ago 53
Nature

In a relational database management system (DBMS), a tuple is a basic unit of data that represents a single record or row. It is also known as a record or row and contains a collection of attribute values in which no two unique items have the same name. Tuples are used to represent inter-related data about a particular entity, such as a student, employee, or user.

Tuples are mostly seen in relational databases management systems (RDBMS) as RDBMS works on the relational model (tabular format) . Queries are used to retrieve specific data from the database, and the result of a query is a set of tuples that match the criteria specified in the query. For example, a query to retrieve the first and last names of customers with a specific email address would return a set of tuples with those attributes for each customer that matches the criteria.

In summary, a tuple in DBMS is a row representing some inter-related data of a particular entity such as a student, employee, or user. It is a basic unit of data in a relational database management system (DBMS) and represents a single record or row.