Web based Bookstore Management System for Wisdom

Abstract

ABSTRACT Education has been the most critical factor in the present knowledge era, not only in the world but also in Sri Lanka. Every parent tries to provide the best education for their children, hence there has been a rapid demand for the popular national schools and international schools. Therefore, the demand for international school syllabus textbooks has been also increasing, in addition to the demand for local school additional texts. Because of that, there is a big opportunity in selling international texts and local syllabus related texts for the booksellers in the country. WISDOM BOOKSHOP (WB) is one of the well-recognized, ongoing bookshops and also WB was established 20 years ago in Wattala area. Presently plays a vital role in International textbooks for Local, London – O/L, A/L sections in bookshop segment. It only handles retail customer‟s book Sales at begins; later caters through the books from Dealers (suppliers). Then Wisdom Bookshop combines with several Dealers with Wholesale and Retail sales with Agents in bookshop Sector. At present they have their own website and use IT facilities to some extent in their daily internal business process but based on poor semi-automated Computer System. This makes the business inefficiently, Data inaccuracy and unavailability so it causing its future progress although they are able to reach their customers via the web. WEB BASED BOOKSTORE MANAGEMENT (WBBM) is providing a solution for the key problems in the internal business process. This solution is built in a way to cover the overall processes of the bookstore such as Purchase, Sales, Stock controlling and Report Generation. The System has tailored Model View Controller (MVC) Architecture and Object Oriented (OOAD) techniques with UML were used to analyze and design the system. The development process was preliminary based on the Rational Unified Process (RUP). HTML5 was used as the core markup language while CSS3 for styling. PHP use for server-side scripting, JavaScript, jQuery and AJAX for client-side scripting. MySQL was used as the DBMS of the system. WBBM would improve the efficiency and productivity of the daily functions of the business, and also would strengthen the suppliers – business - customers‟ relationship which leads to adding competitive advantage to the business in for future progress. The online distributed nature of the system will be very helpful to expand their business in the future as well.