Natural Keys vs. Surrogate Keys
Natural Keys are attributes that naturally identify a record. They are often derived from real-world entities and can be complex, such as a combination of fields like FirstName, LastName, and DateOfBirth.
Surrogate Keys are artificial keys, typically simple integers, assigned to uniquely identify records. They are created during the data loading process.
