What is a common mistake with relationships and navigation properties in Entity Framework Core?

Relying on conventions without understanding optionality or cascade delete behavior can cause data loss or incorrect schemas. In practice, the value of this concept comes from understanding where it belongs in the architecture, what problem it solves, and what constraints or tradeoffs it introduces.