Final answer:
A collection of tables that allows connections between the information in each table is known as a Relational database. These databases store data in predefined categories within tables and define relationships using foreign keys to connect different tables, avoiding duplication of data.
Step-by-step explanation:
The term for a collection of tables that allows connections between the information in each table is: a) Relational database.
Relational databases are designed to recognize relations among stored items of information. They consist of a set of tables containing data fitted into predefined categories. Each table (also called a relation) contains one or more data categories in columns. Each record, also known as a row, contains a unique instance of the data for the categories defined by the columns. The key aspect of a relational database is its ability to store relationships between these tables through the use of foreign keys (a field in one table that uniquely identifies a row of another table).
For example, a relational database for a bookstore might have a table for authors, another one for books, and another for publishers. Through relational design, it is possible to understand which books are written by which authors and are published by which publishers, with consistency and without unnecessary duplication of data.