What is a Relationship?

A courting, in the Context of Databases, is a scenario that exists among two Relational Database Tables when one desk has a overseas key that references the number one key of the opposite table. Relationships allow relational Databases to break up and keep Records in one of a kind tables, even as linking disparate records Objects.

What Does Relationship Mean?

For example, in a financial institution database a CUSTOMER_MASTER desk stores customer facts with a number one key column named CUSTOMER_ID; it also stores purchaser facts in an ACCOUNTS_MASTER desk, which holds data about various bank debts and associated customers. To link these tables and decide Client and financial institution account records, a corresponding CUSTOMER_ID column must be Inserted within the ACCOUNTS_MASTER table, referencing present patron IDs from the CUSTOMER_MASTER table. In this example, the ACCOUNTS_MASTER table’s CUSTOMER_ID column is a overseas key that references a column with the equal call in the CUSTOMER_MASTER table. This is an Instance of a relationship among the 2 tables.

The fundamental feature that differentiates relational databases from other database kinds (e.G., flat-Files) is the ability to define relationships.