Developing an Information Management System for a Local Bookstore

This project analyzes the information management system of a local bookstore, which currently relies heavily on manual processes. The bookstore faces challenges including inefficient inventory management, lack of online ordering capabilities, and difficulties in tracking sales and financial data. The project proposes several IT solutions, including the development of a comprehensive product database, implementation of a point-of-sale (POS) system integrated with the database, and establishment of an online ordering system through a website. These solutions aim to streamline operations, improve inventory control, enhance customer reach, and facilitate better financial tracking. The project also explores different cost estimation options for implementing these solutions, including hiring an in-house IT specialist or outsourcing to a consulting firm. The goal is to modernize the bookstore's operations, enhance its competitiveness, and improve its overall efficiency and profitability. The project emphasizes the need for a robust IT strategy to support the bookstore's growth and adapt to evolving market demands.

Information Management System at a Local Book Store
1. Introduction
Book Store
The business analyzed down here is a local book shop that has distinctive areas of stationery for
various clients, business clients, and toy segments, which serve clients of youth segment.
The store has extended its product offering and its area to oblige more items and serve diverse
markets.
Product
Book shops have different product lines including books, stationery, wood cutting items and
carving, aromas, toys including men's and ladies' adornments, candles and different things.
Different styles in the Books area incorporate science-fi, awfulness, riddle, youthful grown-up,
shading, story current undertakings, history and kids' books.
Market
The business sectors that come in the book shop incorporate students, kids, organizations and
others searching books for schools, college and other recreation such as novels and magazines.
The book shop serves the market for particular schools, for which it sets particular uniforms and
books, which incorporate the whole course for each class. The most recent version of the book
shop is the printing and making segment with toys for both youths and small kids.

Composing and printing areas are getting to be noticeably well known as of late in light of the
fact that universities and schools are close-by.
Mission
The bookshop intends to push ahead in the coming years and works more on the particular garbs
of the schools and universities and the course of books. The motivation behind the bookshop
likewise is to make a segment for maps and history related things later on.
There is a need to enhance client reach in such manner since bookshops have extended their
operations so it requires more clients and deals to advance their products, and guarantee that the
products are extended keeping in mind the end goal to proceed effectively, adequate deals will be
created.
2. Problems
Current Information handling limit
The present structure of the bookshop, handling abilities are for the most part manual. In spite of
the fact that providers have a superior database framework and searching for more sensible
pitching alternatives in mass products to put bookshop in a book shop, the technique to keep
information physically isn't adequately supporting the objective.
The present data preparing framework additionally does not be able to discover a blunder in
deals.

In spite of the fact that business receipts are produced through the framework for a few classes,
including endowments and toys, despite everything they should be physically out in registers in
light of the fact that the rest of the framework and segment are figured physically.
This causes errors in the last tally, and here and there likewise gives the advantage of losing
workers and procuring unlawfully in such a vast store.
The proprietor, who has three siblings, is at the shop together and now and again at one time.
This causes the disarray of specialist for the framework, so the framework has not been
introduced in the database, but rather the siblings have begun to see that they require more
damage to be covered, while sufficiently running deals.
Currently these are problems
Problems with existing technology established in the bookstore are followed:
 The framework is inadequately orchestrated and refreshed, which implies that money
related and stock cases are taken care of physically. It will be inconceivable with the
developing areas of bookshop products and administrations.
 The money related framework demonstrates a misfortune that can be followed by the deal
and is done physically and can be looked at without every one of the sections in the
framework.
 The system of book shop and the general procedure isn't observed and cannot be in that
circumstance in light of the fact that the proprietors don't have the system to recognize
each exchange and keep the capable individual dependable.
 Clients are requesting different book shops which are putting forth online offers of books
and different products. The book shop system has made a database physically that can be

connected to the site and introduces an online system that will help in making more deals
and fulfilling clients.
 Since there is no internet requesting system, different book shops are recording a bigger
number of offers than book shop examined with web based shopping and home
conveyance.
 Advancement of new products is for the most part done through publications through
notices and different things. No attention is being made in the system and on the web.
3. IT Strategy
Proposed Solution
The accompanying are the solutions to help settle the previously mentioned issues. These
solutions will help aggregately accomplish business objectives and its clients will advance in the
market and business.
Database for all products and items in each area
The book shop needs to make a database of the considerable number of things accessible in the
store and it has a claim to fame. Such items ought to be given a novel ID as indicated by the
items area, where they are connected, so following an item from the database code is simple. The
database isn't a gigantic investment as the whole database system can be effectively gotten to
from Microsoft and utilizing free programming like Excel.
Monitoring system through look at and deal

Deals monitoring ought to be directed which implies that all deals and speculator adjusts ought
to be monitored by the proprietors who monitor deals and how much cash is gotten against the
exchange to guarantee that there is no shrouded cash And at long last turns into a cost for
business. The checkout ought to be connected with the database so the number of products can
be decreased before that day's over and the stock can be sold for the most part.
System for Online Order taking
The online requesting system can be presented through a website which is a compelling
speculation.
At the point when this system is associated with the database and right now accessible on the
book shop, online products are seen by the client, they can without much of a stretch place and
give their addresses and contacts. It ought to be connected to the dynamic system in the book
shop, for which an expert shop for a book shop is required with the goal that they can keep the
request and guarantee that they are being dispersed on the guaranteed time.
Keeping deals and stock and track of clients
Systems and online systems will be associated with all databases that will enable monitor stock
and deals. This will help both in stock support and budgetary administration.
No hidden cash exchange will be made and the deals made by every worker will turn into a
client's formula which can be asserted and will be accounted for with every exchange in the

system. In this way the strength of the brand of business can be achieved and the products can be
encouraged to attract more suppliers.
Cost estimation
The estimating alternative in the current solution is that the book shop holds a man who is great
at PC and database administration. To help with keeping up exchanges and stock systems, the
open deliberation must be created and connected to the website. It is costly than the following
evaluating solution will be paid month to month for proficient administrations for this situation
in light of the fact that for this situation.
The following estimating solution is that the website takes the administrations of a counseling
firm to help build up the website and the database. They offer support of life time and redesign
the base cost when required. In such a case, just a single time venture will be made on system
improvement. No regularly scheduled installments will be required and the system will be
updated when required. In such a case, the control of the system will be in the hands of the
proprietor.
4. Summary
The book shop needs to be practical and prepared to apply for the correct speculation book shop
to build up a superior deals and stock system. In this way, the library should procure an expert to
manage the improvement of the database and web administration, refreshes every day to the
expert wiped out system and investigating the website and in addition stock. Since developing

and developing in the New Year, book shops require their own experts to manage issues and
issues.