| German | English |
| 1:1-Beziehung | one-to-one relationship (An association between two tables in which the primary key value of each record in the primary table corresponds to the value in the matching field or fields of one, and only one, record in the related table) |
| n:1-Beziehung | many-to-one relationship (A relationship between two tables in which one row in one table can relate to many rows in another table) |
| 1:n-Beziehung | one-to-many relationship (An association between two tables in which the primary key value of each record in the primary table corresponds to the value in the matching field or fields of many records in the related table) |
