See data model and dimensional modeling. Building an Entity Relationship Model The Erwin modeling program from CA Technologies stands for Entity Relationship for Windows.