Book Shop Management System 1.Introduction 1.1 Introduction Computer is fast emerging as a daily need in walks of life. The knowledge of computers and programming language has become basic Skill need to service in todays information based society. !very business Institution and the corporate section" make a use of computer for making their operation efficient # effective. Book distributors transaction handling is one of the comple$ process and it re%uired computeri&ed system to maintain overall transactions in an easier manner. 'ue to heavy demand of books in these competitive worlds" data increase so much. Books shop re%uired up to date information about the customer who purchased books or about the suppliers suppliers from where books are purchased. purchased. The books shop shop re%uires large amount of data to record and to store" which are collected from the Book (ouse. ) Book Shop Management Management system is basically for management of incoming and outgoing material from the Book shop It also maintain management of all incoming and outgoing finance from the Shop account section. It will reduce paper work # work load of user. To reduce the *aper work and provide fast service to customers. The main ob+ective is to provide the customers fast and error free transaction. It can be used in any Book Shop for maintaining database details and their %uantities. This pro+ect is used for handle user needs. I t must be outgoing process to know re%uirements re%uirements of customer during whole system system development life cycle ,ollowing are some of the inputs to the Book Shop
Book 'etails
-uantities of Books
Customer 'etails
Sale 'etails
!mployee 'etails
-uantities of the products System will help to produce following outputs
Customer bill receipt
ate /ist
Current -uantities of the products
0arious 0arious eports sales" stock" customers etc.
1.. Scope2 This software has demands in private and public area. This software provides a great help in managing the data in a well3mannered order. This pro+ect is designed specially to maintain the data in a se%uential manner and to save the tome and efforts of database )dministrator. The pro+ect is structured according to todays need. 'ue to time constraint it is possible that some points might remain uncovered by us. In future we will update our software to give valuable information left at present.
Chapter System overview .1. !$isting System The book shop contains different types of books of various sub+ects with various %uality according to the customers needs and re%uirement. The main thing of the book shop is to maintain maintain lot of records for the daily daily transaction of the business. business. It is necessary for every business to maintain all records" r ecords" which show the profit and loss of the business. In todays life people have very little time and many things To do. do. They have to manage all this unbalance workload" although everyone wants to achieve all their ambitions and dreams. )nd the present system of managing Books is very time consuming so it is very difficult to maintain good records and fast service. The paper work is becoming very difficult to handle day by day. Currently we have to keep track of each and every thing about the book shop on the paper or in register. 4e 4e have to maintain lot of registers to enter these large volumes of data. This leads to the wastage of stationary. Some disadvantages are2
.. *roblem with !$isting system2 Manual system involves a lot of paper work" so it becomes time3consuming and costly.
The chances of errors in calculation of delivery of Books are more in the current manual system. The calculation of total collection for day or month or y ear is very difficult.
Currently no security is provided to the large amount of data of the every book details.
It becomes very difficult to maintain details of every Book as records increases day by day
.5. Solution on problem 4hile creating new software we should analy&e what is the basic need of the software. )nalysis )nalysis is nothing but a planning of creation of software to get proper output from it. )nalysis )nalysis is details study of pro+ects that you want to show in your software solving problems. The basic need of the software is to save the time of the user with the help of all useful information. )nd )nd also to maintain the collection of data in your computer systematically" systematically" so that its easy to understand. The proposed system provides lot of facility to the user to store information of the Books and it provides information in %uick time in a systematic systematic manner. The processing time time on the data is very fast. It provides re%uired data %uickly to the user and also in specified manner to the user. )ll the information of Books changes is given to the user and also the reports are ar e also generated according to the re%uirement of the user. Today it is becoming very difficult to maintain record manually. This software system easily does the +ob of maintaining daily records as well as the transaction according to the user re%uirements. Some advantages are
6ser 7 ,riendly software
!asy to record all data about the Books and its details
It saves time of the user as well as prevent paper work
It provides the security to the database that is large amount of important data of the Book Shop
It provides more reliability for keeping information.
Chapter 5 (ardware and software e%uirement (ardware e%uirement2 (ere is the recommended hardware re%uirement for this software to run efficiently. 18 *entium 199 M(& or higher processor 8 5 MB )M 58 :; MB free hard disc space <8 S0=) monitors :8 *rinter >?ptional8
Software e%uirement2 This software comes under application software. So the necessary software for this is 18 4indows operating system family. 8 4indow 4indow @$" >that is window @:" @A" M!" etc.8 58 4indow T" ;;;" ;;5" *
Chapter < e%uirement )nalysis Identifying needs is the first step while designing a system and implementation. This is the way to handle user needs" it must be an outgoing process to know re%uirements re%uirements of customer during whole system system development life cycle. 'uring this phase the main things to be considered are got by placing meetings and %uestionnaires with customer. e%uirements found during all the stages proposed system development are
(ow the present system work.
Time take to operate the system.
/ist of contents associated with the system.
!rrorDfailure rate to be acceptable.
isk factors involved.
*roprietary aspects" liability risks" potential infringement" and political issues to consider.
(uman3machine and machine3machine communication.
Interfacing with e$ternal environment
<.1 ,easibility study 'epending on the results of the initial investigation the survey is now e$panded to a more detailed feasibility study. E,!)SIBI/ITFST6'FG is a test of system proposal according to its workability" workability" impact of the organi&ation" ability to meet needs and effective use of the resources. r esources. It focuses on these ma+or %uestions2 1.4hat are the users demonstrable needs and how does a candidate system meet themH . 4hat resources are available for given candidate systemH 5. 4hat are the likely impacts of the candidate system on the organi&ationH <. 4hether it is worth
to solve the problemH 'uring feasibility analysis for this pro+ect" following primary areas of interest are to be considered. Investigation and generating ideas about a new system does this. Steps in feasibility analysis eight steps involved in the feasibility analysis are2
,orm a pro+ect team and appoint a pro+ect leader.
*repare system flowcharts.
!numerate potential proposed system.
'efine and identify characteristics of proposed system.
'etermine and evaluate performance and cost effective of each proposed system.
4eight 4e ight system performance and cost data.
Select the best3proposed system.
*repare and report final pro+ect directive to management.
,easibility study is the procedure to identify" describe the evaluate candidate system and select the best possible action for the +ob. The initial investigation culminated in a proposal summari&ed the thinking of the analyst" was presented to the user for review. The proposal initiated a feasible study to describe and evaluate the best system to choose in terms of economical" technical and behavioral constraints. The terms constraints involved in feasibility analysis are3 o Technical o !conomical o ?perational o Behavioral
<.. Technical ,easibility
) study of resource availability that may affect the ability to achieve an acceptable system. This evaluation determines whether the technology needed for the proposed system is available or not.
Can the work for the pro+ect be done with current e%uipment e$isting software technology # available personalH
Can the system be upgraded if developedH
If new technology is needed then what can be developedH
This is concerned with specifying e%uipment and software that will successfully satisfy the user re%uirement. The technical needs of the system may include2 ,ront3end and back3end selection )n important issue for the development of a pro+ect is the selection of suitable front3end and back3end. 4hen we decided to develop the pro+ect we went through an e$tensive study to determine the most suitable platform that suits the needs of the organi&ation as well as helps in development of the pro+ect. The aspects of our study included the following factors. ,ront3!nd selection 1. It must have a graphical user interface that assists employees that are not from IT I T background. . Scalability and e$tensibility. 5. ,le$ibility. <. obustness. :. )ccording )ccording to the organi&ation re%uirement and the culture. 9. Must provide e$cellent reporting features with good printing support. . *latform independent. A. !asy to debug and maintain. @. !vent driven programming facility.
1;. ,ront3end must support some popular back end like MS )ccess. )ccording )ccording to the above stated features we selected Java 1.9 as the front3end for developing our pro+ect. Back3!nd Selection 1. Multiple user support. . !fficient data handling. 5. *rovide inherent features for security. <. !fficient data retrieval and maintenance. :. Stored procedures. 9. *opularity. . ?perating System compatible. A. !asy to install. @. 0arious drivers must be available. 1;. !asy to implant with the ,ront3end. )ccording to above stated features we selected MS3)ccess as the backend. The technical feasibility is fre%uently the most difficult area encountered at this stage. It is essential that the process of analysis and definition be conducted in parallel with an assessment to technical feasibility. feasibility. It centers on the e$isting computer system >hardware" software etc.8 and to what e$tent it can support the proposed system.
<.5. !conomic ,easibility !conomic +ustification is generally the EBottom /ineG consideration for most systems. !conomic +ustification includes abroad range of concerns that includes cost benefit analysis. In this we weight the cost and the benefits associated with the candidate system
)nd if it suits the basic purpose of the organi&ation i.e. profit making" the pro+ect is making to the analysis and design phase. The financial and the economic %uestions during the preliminary investigation are verified to estimate the following2
The cost to conduct a full system investigation.
The cost of hardware and software for the class of application being considered.
The benefits in the form of reduced cost.
The proposed system will give the minute information" as a result the performance is improved which in turn may be e$pected to provide increased profits.
<.<. Behavioral ,easibility )fter considering the following point that the system is behaviorally feasible. The pro+ect is carried out on the re%uest of the users. To a greater e$tent" the proposed system aims at ma$imi&ing user friendliness. fr iendliness. This is intended to overcome resistance to change by the e$iting staff. 6sers are %uite e$perienced in handling the computeri&ed system. 6sers are aware of the software and hardware environment.
Chapter : system design and modeling :.1. ! 'iagram
:.. 'ata flow 'iagram.
:..1. Basic
:.. ,rist level ','
:..5. Second level ','
:..5. Third level ','
:.5. system 'esign Software design is an actually a multi3step process that focuses on four distinct attributes of program namely data structure" software architecture" interface representation and procedural details. The design process translates re%uirements into a representation of the software that can be assessed for %uality before code
generation begins. The design is documented and is part of the software configuration. Code =eneration The design must be translated into a machine readable form. The code generation steps perform this task. Testing The testing process focuses on the logical internals of the software assuring that all statements have been tested and on the functional e$ternals that is conducting tests to uncover errors and ensure that defined input will produce actual results that agree with re%uired. Maintenance Software will undoubtedly undergo changes after it is delivered to the customer. Change Change will occur because errors have been
Chapter 9 ')T)B)S! '!SI= Table-availablebooks fdISB fdBOOKNA fdAUTH fdPUBLICATIO fdAMOU fdC fdPRI fdDATE N ME OR N NT P CE 112
java
sachin
tech max
5
5 $250.0 30/8/201 06
113
c
ram
technical
17 100 $300.0 30/8/201 06
113
c++
sumit
swami publicatin
18
5 $!50.0 30/8/201 06
Table-emploee id
!ame
add"ess
mobile!o
emailid
s#a#$s
da#e
"mp1 sham
cha#an
133555555
sham%mail
&es
30/08/2016
"mp2 ram
shi#rapur
5! 5!56!56!56!
s'ssas
&es
30/08/2016
Table-pass%o"d fd$se"!ame
fdpass%o"d
sachin
sachin
Table-Emploee Table-Emploee pass%o"d fd$se"!ame sachin
fdpass%o"d sachin
Table-p$"&'ase fdIS fdBOOK fdAUT fdPUBLIC fdAMO fd fdPR fdD fdMO fd( fdDAT BN NAME HOR ATION UNT CP ICE A( NTH EAR E 112 java
sachin
tech max
10
5 $250. 00
30
8 2016 30/8/2 016
Table-p$"&'ase fdIS fdBOOK fdAUT fdPUBLIC fdAMO fd fdPR fdD fdMO fd( fdDAT BN NAME HOR ATION UNT CP ICE A( NTH EAR E 113 c
ram
technical
20 10 $300. 0 00
30
8 2016 30/8/2 016
113 c++
sumit
swami publicatin
20
30
8 2016 30/8/2 016
5 $!50. 00
Table-sellbooks fdI fdi!v fd&$s fdboo fda$ fdp$bl fdam fd&os fdselli fdda# SB oi&e!o #ome" k!ame #'o" i&a#io! o$!# #p"i&e !)p"i&e e N
fdid
1 sa%ar
java
112 sachi tech n max
2
5
!!0 30/08/ ('minis 2016 tratr
1 sa%ar
c
113 ram
3
1 00
8!0 30/08/ ('minis 2016 tratr
2 x)*
java
112 sachi tech n max
3
5
675 30/08/ "mp1 2016
3 sa%a sa%arr
c++
113 sumit mit swam wami publicat in
2
5
810 30/08/ ('minis 2016 tratr
technic al
Table-se##i!) fds'op fddis& fddis& fddis& fddis& fdAd fdmobile fds' fdemail !ame o$!#* o$!d+ o$!#, o$!# d"ess !$mbe" op!o anish ,# -hp
10
15
20
!0 ,aile) m#htma 123!5678 a' il.cm 0 atna 1!
100
Chapter I*6T! )' ?6T*6T! ,?MS 1. /ogin
. )dmin dmin /og /ogin
5. )vaila ailabl blee Book Bookss
<. !mpl !mploy oyee ee lis listt
:. Sale book
9. *orc *orcha hase se book book
. Budget
Chapter A eports
1. !mploy !mployee ee progre progress ss report report
. !mploy !mployee ee selin seling g progre progress ss repor repor
5. *urc *urcha hase se rec recor ord d
<. Sale Sale rec record ord
:. Invoice
Chapter @
/IMIT)TI?S Though the system has been designed according to the re%uirements r e%uirements of the users it has its own limitation. Thus the limitation of system are3 o facility to create new new users with different different roles
?b+ect oriented )pproach has been not been fully utili&ed
Chapter 1;
,6T6! !()C!M!T This software has demands in private and public area. This software provides a great help in in managing the data in in a well3mannered order. order. This This pro+ect is designed specially to maintain the data in a se%uential manner and to save the tome and efforts of database
Chapter 11
C?C/6SI? This system computeri&es the Book shop management process in any book shop. It manag ma nages es th thee di diff ffer eren entt op oper erat atio ions ns in bo book ok
shop sh op su such ch as ma maint intai ain n re reco cord rd of av avai aila labl blee
books")vailable books")v ailable !mployee" Keeps records of sales# purchase and view progress of employee . and. It has the searching option along with the managing capability. ew features and modules can be added into the system as per user re%uirement.
Chapter 1
BIB/?=)*(F Books 0isual 0isual Basic 9.; Black Book 0isual Basic 9.; *rogramming 7 0ision *ublication 4ebsites =oogle.com ,reetutes.com ,reevbcode.com