Primary and Foreign Keys
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What are the usual short names for Primary Key and Foreign Key?
2. Why are primary and foreign keys so important in a database?
3. What problem did repeating "United States of America" in the Family table illustrate?
4. After the change, what does the Family table store in the Birth Location column?
5. In the Family and Birth_Location tables example, which column is declared the PRIMARY key?
6. And which column is declared the FOREIGN key?
7. What does declaring the keys make possible?
8. How do you find which country the code "001" refers to?
9. A primary key value in a table should be:
10. Which sentence best describes a foreign key?