|
|
|
| hi everyone..i need some help on understanding some concepts. I've been having trouble understanding the concept of primary keys and foreign keys. can anyone help me with those.. | |
|
|
| wbafrank 2002-01-19, 9:02 pm |
|  For some reason this came thread came up twice - must have double clicked!! | |
|
| thanks frank the material was really helpful! | |
| MensaBoy 2002-01-21, 9:17 pm |
| Foreign keys are primary keys that have traveled to distant tables and speak with funny accents.
Primary keys are those fields in the column that uniquely identifies the tuple (row) in a normalized table.
What makes a table normalized?
All other fields in the tuple depend upon:
1. The Key
2. The whole Key
3. And Nothing But the Key
So help you, Codd |
|
|
|