COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Primary key
|
|
|
Foreign key
|
|
|
Secondary key
|
|
|
Non of the above
|
Detailed explanation-1: -The foreign key here signifies the data or information category in a specific table, that is indicated in the new table as the primary key column. Thus the, the foreign key helps to determine the relationship among tables.
Detailed explanation-2: -A foreign key is a column or a set of columns in a table whose values correspond to the values of the primary key in another table. In order to add a row with a given foreign key value, there must exist a row in the related table with the same primary key value.
Detailed explanation-3: -A foreign key (FK) is a column or combination of columns that is used to establish and enforce a link between the data in two tables to control the data that can be stored in the foreign key table.