Databases in which tables can be joined through the use of common fields are known as situational databases.

This would be called a relational database. Simply put, this is a collection of information that is organized in numerous formally described tables, all of it is linked an can be accessed or reassembled in numerous variations without reorganizing the actual database tables. This was invented in 1970 at IBM by E. F. Codd.