What is primary and foreign keys in Data Modeling?

primary and foreign keys is an important concept in Data Modeling. Understand its purpose, how it works, when to use it, and the tradeoffs it introduces before applying it in a production system.