Relational Database

A relational database allows the user to set up data structures that include the relationships between data entities. When an attribute of one entity relates to another entity then a link can be defined. Thus, if the music issue were being implemented in a relational database, membership number would be defined as a link between member and part. When a part record was being examined, the relational database would use this link to allow the user to view data relating to the member who had the part on loan.

Instead of files, a relational database is made up of tables. Each line of a table corresponds to a record and each column to a field. The user will define table names and column names and specify link fields to establish relationships between the various tables. Once this has been done the relational database management program will allow the user to manipulate data in several tables at once. The program will use the links to allow access to the different tables. The tables themselves are flat files but the links impose an additional structure on these flat files by defining the relationships between them.

Relational databases help prevent data redundancy.

© LEV