Question

At least two tables are required to make which of the following key ?
(a) Primary key (b) Alternate key (c) Candidate key (d) Foreign key.​

Answer 1

Answer:

Candidate key requires at least two tales

Answer 2

Option (d) "Foreign key" is the correct answer for the above question.

Explanation:

The foreign key is a key which is the primary key of a foreign table. If there is one table, then there will be a primary key that is used to identify all the data of a table. But if the table not in the normalized form then we have to divide one table into multiple tables to make it normalized. Then the other table except the primary table is known as the foreign table and the primary key used to identify the records of a foreign table is known as a foreign key.

So the above paragraph concludes that there is a need for two table to decide the foreign key which is also asked by the question. Hence the answer is foreign key which is referred from the option d. Hence Option d is the correct answer for the above question while the other is not because--

• Option a states about the primary key which is decided by one table only.
• Option b states about the alternate key which is also decided by one table only.
• Option c states about the candidate key which is also decided by one table only.

Learn More:

• Foreign key : https://brainly.in/question/5751683