+ 4
When populating a table how does one add a foreign key? Is it done just by adding the foreign key id? Thanks
3 Answers
0
Ù
۱Űۚۧ
0
A foreign key comes from a fully normalized database structure. That means the value in one table resolves to a primary key in another table.
For example, in a retail transaction, you go to the store and buy some goods. The receipt is a collection of those goods and has its own receipt number. The foreign keys on the receipt would be the individual products purchased in the transaction.
- 1
ya