| A | B |
|---|
| consultant | one who gives expert advice |
| CRUD analysis | the practice of checking a data model for create, retrieve, update and delete functions that the business requires |
| functions | used to perform calculations on data modify individual data items, manipulate output for groups of rows, format dates and numbers for display, and convert column datatypes |
| obsolete | no longer in use |
| barred relationship | a relationship that participates in an entitys unique identifier |
| redundant | unnecessarily repetitive |
| many to many | a relationship in which many records in one table match many records in another table |
| one to many | a relationship where a single record in table A can be related to one or more records in table B, but a single record in table B can only be related to one record in another table |
| one to one | a relationship where a single record in Table A can be related to one and only one record in Table B, and each record in Table B relates to one and only one record in Table A |
| transferable | property of a relationship between A and B, where an instance of A is related to an instance of B, and the association can be moved to another instance of B |
| non transferable | property of a relationship between A and B, where an instance of A is related to an instance of B, and the association cannot be moved to another instance of B |
