Relational Database Management is an approach to database management, employed by Microsoft Access and other database management programs, in which data that is stored in two-dimensional data tables of columns and rows can be related if the tables have a common column or field. The term “relational” suggests the capability of this type of database software to relate two tables based on this common field and to construct a new third table based on this relation. For example, suppose that a bookstore’s database program store one table listing customer names and customer numbers, and a second table listing customer numbers and the subjects of the books purchased by the customer with this number. By formulating a query, a user could produce a third, new table that lists the customer name and the subjects of the books purchased by this customer. The customer number provides the common field by which the two original tables can be related. See join, system (RDBMS).
Relational Database Management
