On the first day of Database Systems, I asked the instructor about the introduction of "Artificial Keys" in a table’s schema (more formally known as Surrogate Keys). I had used surrogate keys in almost all of my DB schemas prior to this class. He urged us to avoid surrogate keys (and use natural keys from... Read More