A Survey of the Organization and Processing of Database Systems With Case Study

As increases in the size and complexity of information systems began to tax features of conventional file-based technology, systems based on other data models began to emerge in the data processing community. The need to represent relationships between data items in addition to the items themselves led to a set of models classified as databases. Of particular importance has been the relational database model, in which relationships are implied by corresponding attribute values in data sets or relations. This organization allows straightforward representation of many real-world bodies of information as well as great versatility in processing. The relational model proved particularly useful in establishing a transfer voucher automation system for UT Martin Business Affairs, specifically in regard to Printing and Duplicating processes. The use of DBMS1, a relational database system, provided features necessary for concise representation of account information and direct means of manipulating this information in terms of-relational theory. Batch processes for generation of monthly voucher summaries and departmental log sheets were facilitated by a system file format easily interpreted under MUSIC. Details of the completed Printing and Duplicating subsystem may be extrapolated in the future to address similar Business Affairs needs in electronic maintenance and office supplies charges.