relational database
Definition:
With this type of data file there are no predefined links or associations to link files. Relational databases are characterized by two features. First, the file is tabular, with each new record being appended. Records therefore do not need to be ordered within the file, and can be added, deleted or altered with ease. Secondly, associations are made on the basis of the value or contents of a field, rather than on the basis of addresses. A practical example in MARKETING, would be the creation of various status reports. The invoice file would relate to a sales executive file and/or a stockholding file. As the value in one file changes (e.g. 100 units are sold), the associated files are automatically updated (e.g. stockholding is reduced 100 units, and the appropriate sales executive is credited with the sale).
Cross-References:
[marketing]
Links:
Figures:
© Westburn Publishers Ltd 2002, The Westburn Dictionary of Marketing edited by Michael J Baker, ISBN 978-0-946433-01-8. www.themarketingdictionary.com. Entry: [Kenneth R. Deans], [1998].