West African Journal of Industrial and Academic Research

The AJOL site is currently undergoing a major upgrade, and there will temporarily be some restrictions to the available functionality.
-- Users will not be able to register or log in during this period.
-- Full text (PDF) downloads of Open Access journal articles will be available as always.
-- Full text (PDF) downloads of subscription based journal articles will NOT be available
We apologise for any inconvenience caused. Please check back soon, as we will revert to usual policy as soon as possible.

Automated Stock Control System for Bookshops in Tertiary Institutions

AI Oladimeji, E Boniface, IC Chiamaka


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

AJOL African Journals Online