Definition - What does Relation mean?

Relation is sometimes used to refer to a table in a relational database but is more commonly used to describe the relationships that can be created between those tables in a relational database.

In relational databases, a relationship exists between two tables when one of them has a foreign key that references the primary key of the other table. This single fact allows relational databases to split and store data in different tables, yet still link the disparate data items together. It is one of the features that makes relational databases such powerful and efficient stores of information.

The ability to define relationships is so fundamental and so important that this is what differentiates relational databases from other types of databases, such as flat-file databases. Relation, therefore, is the defining feature of relational databases.

Relation may also be known as relationship.

Techopedia explains Relation

Consider a bank’s database. You have a CUSTOMER_MASTER table that stores customer data, with a primary key column called CustID, as well as an ACCOUNTS_MASTER table for holding information about various bank accounts and which customer owns them. To link these two tables together, that is to tie each customer to his or her bank account, a corresponding CustID column is required in the ACCOUNTS_MASTER table that references an already-existing customer ID in the CUSTOMER_MASTER table. In this case, the CustID column in ACCOUNTS_MASTER is a foreign key that references the column of the same name in CUSTOMER_MASTER. This scenario refers to the relation between the two tables.

Share this:

Connect with us

Email Newsletter

Join thousands of others with our weekly newsletter

The 4th Era of IT Infrastructure: Superconverged Systems
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.