entity relationship (ER) data model: also called an ER schema, are represented by ER diagrams. These are well suited to data modelling for use with databases. ternary relationship: a relationship type that involves many to many relationships between three tables.