Problem
1. Explain the difference between a primary key and a candidate key.
2. Describe four uses of a primary key.
3. What is a surrogate key, and under what circumstances would you use one?
4. How do surrogate keys obtain their values?
The response should include a reference list. Double-space, using Times New Roman 12 pnt font, one-inch margins, and APA style of writing and citations.