Database Terminology

2. A logical connection between two tables is called a ______.
3. The technique used to speed up searching in a table by creating an ordered list of key fields is ______.
6. A field used for searching or sorting but not necessarily unique is a ______.
7. — A system that cannot handle large volumes of data lacks ______.
8. When one record in a table relates to multiple records in another table, it is a ______ relationship.
9. A single column in a table that stores one piece of information about an entity is a ______.
12. The property that ensures data is accurate and consistent across files is called ______.
14. A field that links to the primary key in another table to create relationships is a ______.
15. A real-world object or concept that data is stored about is called an ______.
16. When records in two tables can relate to multiple records in each other, it is a ______ relationship.
17. When one record in a table relates to only one record in another table, it is a ______ relationship.

1. The rule that ensures foreign keys match valid primary keys is called ______.
4. The same data is stored in multiple files, causing unnecessary duplication.
5. A field (or combination of fields) that could be chosen as the primary key is a ______.
10. A unique identifier for each record in a table is called the ______.
11. A single row in a table representing one instance of an entity is called a ______.
12. When one file is updated but others are not, the data becomes ______.
13. A collection of related data organized into rows and columns is a ______.