| A | B |
|---|
| Barred relationship | A relationship that participates in an entity's unique identifier |
| Intersection entity | The product of the resolution of a many to many relationship |
| Redundancy | Something that is unnecessarily repetitive |
| Normalization | A series of steps followed to obtain a database design that allows for efficient access and storage of data in a relational database. Reduces redundancy and data becoming inconsistent |
| First Normal Form | The output of the first step of database normalization. Eliminates repeating groups |
| One to one | Relationship where each record in A can be related to one and only one record in B, and each record in B relates to one and only one record in 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 |
| 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 Table A |
| Nontransferability | Property of a relationship where an instance of A is related to an instance of B, and the association cannot be moved to another instance of B |
| Many to Many | A relationship in which many records in one table match many records in another table |
| Redundant | Unnecessarily repetitive |
