 |
Foreign Key |   |
Software - Databases
|
A Foreign Key is the occurrence of the primary key of one table as a non-primary key in another table. The foreign key can be used to link together the separate tables constructed for different entities or subjects contained within the database as a whole. For example, if the library had another table in its database with data on all the publishers, the field with the publishers' names in it could be the primary key for that table:
The foreign key
in the table 'Books' is the field 'Publisher' and it is the
primary key for the table 'Publishers'.
|
