theurbanpenguin.com
Creating Tables with Foreign Key Contraints - The Urban Penguin
It is quite normal in SQL databases to reference and ID number rather than a name. this way if the name changes that change can be reflected without the need of updating information in all the referencing tables. As the reference is to the ID not the name there is nothing to update so long …