| A | B |
|---|
| Primary Key | Field in table that is of the same data sype and size as a related field in a linked table |
| Foreign | When tables are linked by the primary key, the related field in the second table is know as the foreign key |
| Join Line | A graphical representation o fthe link between two or more tables |
| Referential integrity | protects related data that is stored in multiple tables |
| Referential integrity | prevents a customer in a customers table from being deleted if the customer's ID also appears in the order table |
| Junction Table | a table used to join primary key fields from multiple tables |
| One-to-one | when only one record is linked to record in another table |
| One-to-many | When a record in one table is linked to more than one record in another table |
| Many-to-many | When multiple records from both tables are lnked |
| Many-to-many | two one-to-many tables that are connected by a junction table |
