FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -A table relationship works by matching data in key fields-often a field with the same name in both tables. In most cases, these matching fields are the primary key from one table, which provides a unique identifier for each record, and a foreign key in the other table.

Detailed explanation-2: -"Table” is another term for “relation"; although there is the difference in that a table is usually a multiset (bag) of rows where a relation is a set and does not allow duplicates.

Detailed explanation-3: -Why is a table called a relation? In a relational database, the table is a relation because its column-row format stores the relationship between data. The columns represent the attributes of the table, while the rows represent the data records. A tuple refers to a single row.