Chapter 2, Problem 2.8RQ

Explanation of Solution

Relation:

• Relation is a two-dimensional table in which data is named. The relations have the named columns and numbers which denote the unnamed rows.
• Although relation is defined as the two-dimensional table of data, not all the tables are considered as the relations.
• For example, let’s consider the bank database
  • In this database, the “Customer” table stores the data about customer in the primary key column with the attribute “customer_id”.
  • At the same time, the “Accounts” table also holds the data about bank accounts and associated customers.
  • Therefore, these two tables such as “Customer” table and “Accounts” table can be linked together through the “customer_id” column to determine the relation that is present with the data from both the tables.

Tuple:

• In the relational model, data are organized in tables, which consist of rows and columns...