Chapter 10: Database Key Concepts — Primary Keys, Foreign Keys, Composite Keys, Surrogate Keys
This chapter organizes the differences between primary keys, foreign keys, candidate keys, composite keys, and surrogate vs. natural keys, and explains the modern best practice of a hybrid approach (surrogate key = PK + natural key = a unique constraint), for junior engineers.