Relation Attributes and Tuples in RDBMS

For Complete YouTube Video: Click Here

In this class, we will understand the Relation Attributes and Tuples in RDBMS.

We already had an introduction to the database schema.

Relation Attributes and Tuples in RDBMS

Before understanding the definition of Relation Attributes and Tuples in RDBMS, we will understand what a relational model is?

Relational Model

The relational model represents the database as the collection of relations.

A relation is informally known as a table of values.

Understanding the definitions of Relation Attributes and Tuple in RDBMS lets us consider a simple employee entity type as shown below.

In converting an ER-Diagram into a database schema, each entity type is transformed into a relation or table.

All the attributes of the entity type are converted into the attributes columns of the table.

Each tuple or row of the relation or table is an entity of the entity type.

In our case, each tuple or row represents the details of an employee of the company.

The image below shows the employee relation.

Each column of the table is called an Attribute.

Each row of the table is called a tuple.

The collection of all such rows is called a relation or table.

The collection of such kinds of relations is called a database.