What is a common mistake with primary and foreign keys in Data Modeling?

A common mistake with primary and foreign keys is applying it mechanically without understanding workload requirements, failure modes, security, performance, maintainability, and operational impact.