| Term | Definition |
|---|
| one-to-one | a type of relationship where one record in table A matches one record in table B. |
| one-to-many | a relationship where one record in table A matches many records in table B. |
| many-to-many | a relationship where many records in table A matches many records in table B and a record in table B has many records in table A. |
| junction | a table that is established to join a many to many relationship |
| primary key | a unique identifier |
| foreign key | in a one-to-many relationship, the primary key of table A becomes this in table B. |
| referential integrity | in a table relationship, this option will prevent deleting records in table A if the table B has corresponding related records. |
| relational database | tables can be related through a common field so that data from multiple tables can be seen at the same time. |
| normalization | the process of designing a database into multiple related tables. |
| record | a group of related fields such as one person's information. |
Combine with other sets
Share on Facebook
Share on MySpace