Question

Consider the two relations below. The primary keys are underlined. Identify all possible foreign key(s) from the options.

loan (loan_number, branch_name, amount)
borrower (customer_name, loan_number)
customer_name
Loan_number
loan_number, customer_name
loan_number, customer_name, branch_name

Answer 1

loan_number is the right answer.

loan (loan_number, branch_name, amount)
borrower (customer_name, loan_number)

A foreign key is a field (or a set of fields) in a table that uniquely identifies a row of another table and it (often) refers to the primary key in the parent table.

Answer 2

Loan_number is the possible foreign key(s) from the options

Foreign Key

• In the relational database, a foreign key is a column used to link between two tables.
• A foreign key is a column(s) that references a column of another table. The intention of the foreign key is to ensure the referential integrity of the data.
• Hence in the above details borrower table has a column called loan_number which is a foreign key, because it is the primary key of the loan table.