| A | B |
|---|
| filter | allows for the retrieval of information that meets specific criteria |
| sort | allows for information to be arranged in a specific order such as alphabetical |
| database relationship | link between two or more tables in a database |
| one-to-many | relationship that occurs when a record in one table is linked to more than one record in another table |
| many-to-many | relationships are formed by connecting two or more tables that have a one-to-many relationship using a junction table |
| primary key | used to format each record in a database table as a unique entity; allow database tables to communicate |
| foreign key | when tables are linked by the primary key |
| join line | graphical representation of the link between two or more tables |
| referential integrity | protects related data that is stored in multiple tables |
| raw data import | useful and practical method for obtaining information from other sources and creating database tables |
| junction table | a table used to join primary key fields from multiple tables |
