217k views
4 votes
A foreign key is a column in one table that references a primary key in another table? (true/false)

User Qwame
by
7.8k points

1 Answer

3 votes

Answer:

The correct answer for the given question is "true"

Step-by-step explanation:

A foreign key is a column in one table which value must match be the primary key in another table.The forign key provide a linking between the two table.

Suppose we have two table customer and order

customer table:

C_ID Name Age

1 rahul 30

2 sumit 23

order table:

C_ID o_id ordernum

1 123 13044

2 1234 13045

C_ID column is the PRIMARY KEY in the customer table

C_ID column is the FOREIGN KEY in the Order table

Because the value of C_ID column in order table is matched with PRIMARY KEY table i.e :customer table.So the answer is true .

User Vitalii Bratok
by
8.0k points

No related questions found