Automated Stock Control System for Bookshops in Tertiary Institutions

Abstract

The recent need for automated stock control system for bookshops in tertiary institutions was generated by unequal availability of books and stiff scarcity of books in some areas while in other areas books are being wasted or unsold. This research has made use of distributed database systems in developing stock control systems for bookshops in tertiary institutions. Stock information is generally accessible from various terminals (Institution Bookshops) and stock queries are made easy and fast through any participating terminal (institution Bookshop). A distributed database can normally be applied by business units, companies, or geographical regions. To improve data availability and reliability,  replication of data is applied in this work. This approach provides for faster response times for users because the database is local to each business unit within the organization. The business unit is typically smaller than the entire organization, which reduces the overall load on the each server. A higher degree of availability can be achieved by storing multiple copies of the same information in different sites of Bookshops in tertiary institutions. Object Oriented Analysis and Design Methodology was used in this research. The major objective of this research is to design and implement the distributed database system for automated control system for bookshops in tertiary institutions.

Keywords: Distributed Database, higher availability, bookshops, OOADM