Bookshop Management 2018-2019

CHAPTER 1

INTRODUCTION
The main objective of engineering college details is to automate all functionalities of a
college using this system you can manage all college details we can update or view the
information about the college.

The engineering college details system is software has the perspective of attaining attraction
of those colleges .this system provides one attractive environment where you can manipulate
data and information about college details.
It is simple yet powerful one joint integrated platform that connects all the various
department of an institution like administration.

Dept. Of ISE Page 1

Bookshop Management 2018-2019

CHAPTER 2

SYSTEM ANALYSIS
The act, or profession of studying an activity (such as a procedure, a business, or a
physiological function) typically by mathematical means in order to define its goals or
purposes and to discover operations and procedures for accomplishing them most efficiently.
The development of a new information system involves several different, but related
activities. These activities, or phases, usually include planning, analysis, design,
implementation, and maintenance/support.
In other words, SDLC is a conceptual model that guides project management in information
system development.
System analysis or study is an important phase of any system development process. The
system is studied to minutest detail and analyzed. A system analysis plays the role of an
integrator and dwells deep into the working of the present system. The system is studied and
viewed as a whole and the input to the system are identified. Then the output from the
organization are traced to the various process. System analysis is concerned with becoming
aware of the problem. Identifying the relevant and decisional variables, analyzing and
synthesizing the various factors and determining and optional or at least a satisfactory
solution or program of action. A detailed study of the process must be made by various
techniques like interviews, questionnaires etc. The data collected by this source must be
scrutinized to arrive to a conclusion. The conclusion is an understanding of how the system
functions. This is called the existing system.

Dept. Of ISE Page 2

Bookshop Management 2018-2019

Existing System
In the existing system the bookshop details are maintained manually but in the proposed
system we have computerized the details using this application.

 Lack of security of data.

 More man power.
 Time consuming.
 Consumes large volumes of paperwork.
 Needs manual calculation.

Proposed System
The aim of the proposed system is to develop a system of improved facilities. The proposed
system can overcome all the limitations of the existing system. This system provides security
and reduces the manual work.

 Security of data.
 Ensure data accuracy’s.
 Minimize manual data entry.
 Minimum time needed for various processing.
 Greater efficiency.
 Better service.
 User friendliness and interactive.
 Minimum tome required.

Dept. Of ISE Page 3

Bookshop Management 2018-2019

CHAPTER 3

SYSTEM REQUIREMENTS
3.1 Software Requirements
It contains the complete software requirements for the bookshop management and describes
the design decisions, architectural design and the detailed design needed to implement the
system. It provides the visibility in the design and provides information needed for software
support.

This project is done in Netbeans with Java as front end and files are stored. Netbeans
is software that connects information people system and devices. It spans client, server and
developer tools. Windows 10 is nothing but an operating system, which has been initiated and
developed, by Microsoft and it can be used on several computer system that are general
purpose, including desktops at home and business, media centers and notebook computers.

Operating System: WINDOWS 10

Front End : NetBeans (java)

Back End : Filesystem

Dept. Of ISE Page 4

Bookshop Management 2018-2019

3.2 Hardware Requirements:

The selection of hardware is very important in the existence and proper working of any
software. When selecting hardware, the size and requirements are also important.

The proposed System is developed on:

Processor : INTEL CORE i5

RAM : 512 MB

Hard Disk Drive : 40 GB

Keyboard : Standard 101/102 or Digi Sync family

Monitor : Display Panel (1024 X 764)

Display Adapter : Trident Super VGA

Mouse : Logitech Serial Mouse

Dept. Of ISE Page 5

Bookshop Management 2018-2019

CHAPTER 4

SYSTEM DESIGN
4.1 Database Design:

 System Architecture:
A system architecture is the conceptual model that defines the structure, behavior, and
more views of a system. A system architecture comprises of system components, the
expand system developed that will work together to implement the overall. The figure 3.1
shows the system architecture.

System Admin

Update Record Login System

Delete Record
View Books

Generate Bill

Figure 4.1. System Architecture

Dept. Of ISE Page 6

Bookshop Management 2018-2019

 Use case diagram:

A use case diagram is a graphic depiction of the interactions among the elements of the
system. A use case is a methodology used in the system analysis to identify, clarify and
organize system requirements. The figure 3.2 shows the use case diagram.

Login

USER View Books

Update
Record

Delete
Record

Generate
Bill

Figure 4.2. Use Case Diagram

Dept. Of ISE Page 7

Bookshop Management 2018-2019

 Activity Diagram:
The activity diagram is used to describe the flow of activity through a series of action.
Activity diagram is an important diagram to describe the system. Activity Diagram shows
an overflow of control. These are the graphical representation of activities and action with
support for choice, iteration and concurrency. The figure 3.3 shows the activity diagram.

Admin login using login ID

System displays entire information of the book shop

Admin modifies, generate bill, and search on required fields

Click on submit and record is updated in files

Figure 4.3. Activity Diagram

Dept. Of ISE Page 8

Bookshop Management 2018-2019

 Flow Chart:
The flow chart is a type of diagram that represents workflow or process. The flowchart
shows the steps as boxes of various kinds and their order by connecting the boxes with
the arrows. This diagrammatic representation represents, illustrates a model to the given
problem. The flowcharts are used in analyzing, designing, documenting or managing a
process in various fields. The figure 3.4 represents flowchart.

START

LOGIN
YES

NO
PASSWORD

INSERT

VIEW

SEARCH

DELETE

GENERATE BILL

LOGOUT

STOP

Figure 4.4. Flow Chart

Dept. Of ISE Page 9

Bookshop Management 2018-2019

4.2 Implementation:
Implementation is the realization of an application or execution of a plan, idea, model,
design, specification, standard, algorithm or policy. In other words an implementation is a
realization of technical specification or algorithm as a program, software component or other
computer system through programming and deployment. Many implementations may exist
for a given specification or standard.

The phase of system is conducted with the idea that whatever is designed should be
implemented keeping in mind that it fulfills user requirements, objective and scope of the
system. The implementation phase produces the solution to the user problem.

The project “BOOKSHOP MANAGEMENT SYSTEM” has been developed using Netbeans
IDE 8.21.Which enables organization of every size to rapidly create more secure, manageable
and reliable application that take advantage of windows professional and the 2010 office
system.

Netbeans IDE 8.21 provides advanced development tools, debugging features, debugging
functionality and innovative features for quickly creating tomorrow’s cutting edge application
across a variety of platforms. Netbeans IDE 8.21 provide developer with all the tools and
framework support provides developers with all the tools and framework support required to
create compelling, expressive web applications. Developers will be able take advantage of
these rich client and server side, frameworks to easily build client centric web applications
that integrate with any back-end data provider, run within any modern browser and the
Microsoft platform. These tools help to integrate database professionals and graphic
designers into the development process.

Dept. Of ISE Page 10

Bookshop Management 2018-2019

 Module Description:
There are five modules present in the project “BOOKSHOP MANAGEMENT SYSTEM”.
These modules are:

1. Insert Record

2. Update Record

3. Search Record

4. Delete Record

5. Generate Bill

1. Insert Record: Here records of the customer are inserted and can retrieve the data easily.

2. Update Record: Here the records are updated if there is any changes.

3. Search Record: Here we can search the records.

4. Delete Record: Here we can delete the record if there is any need.

5. Generate Bill: Here the bill is generated for the customer.

Dept. Of ISE Page 11

Bookshop Management 2018-2019

CHAPTER 5

TESTING
Introduction:
Testing is a process, which reveals errors in the program. It is the major quality measure
employed during software development. During software development, testing the program is
executed with a set of test cases and the output of the program for the cases is evaluated to
determine if the program is performing as it is expected to perform. There are three types of
testing:

1. Unit testing
2. Integration testing
3. System testing

 Unit Testing:
Unit testing is a process verification effort on the smallest unit of software that is module.
Using the detailed design and the process, specification, testing is done to uncovered error
with in the boundary of the module. All modules must be successful in the unit test before
the start of the integration testing. In this project each service can be thought of a module.
Giving different set of inputs has tested each module. When developing the module as
well as finishing the development so that each module works without any errors. The
inputs are validated when accepting from the user. In this application developer test the
program up as system. Software units in a system are modules and routines that are
assembled and ignored to form a specific function. Unit testing is first done on modules,
independent of one another to locate errors. This enables to locate address. Through this
error resulting from interaction modules initially avoided.

Dept. Of ISE Page 12

Bookshop Management 2018-2019

 Integration Testing:
After the unit testing we have to perform integration testing. The goal here is to see if
modules can be integrated properly, the emphasis being on testing the design and hence the
emphasis on testing the design and hence the emphasis on testing module interactions.

In this project integrating all the modules from the main system. When integrating all the
modules we have checked whether the integration effects on working of any of the services
by giving different combination of inputs with which the two services are perfectly before
integration.

 System Testing:
The entire project system is tested. The reference document for this process is the
requirements document, and the goal as to see if software meets its requirements.

Testing is the last phase of the project. This is the stage where it shows whether the system
and database is working as desired. Otherwise, further rectification is required.

Dept. Of ISE Page 13

Bookshop Management 2018-2019

CHAPTER 6
SNAPSHOTS
The snapshot gives the details idea of how the page will look. Each and every pages
functioning will be provided here. The snapshots of the “bookshop management” are given
below:

WELCOME PAGE:

Figure 6.1

Figure 6.1, is the first page obtained as the user runs the application.

Dept. Of ISE Page 14

Bookshop Management 2018-2019

Figure 6.2

Figure 6.2, shows the login page.

Figure 6.3

Figure 6.3, shows the login page of admin. Here the admin gets the logged in with the user
name and password.

Dept. Of ISE Page 15

Bookshop Management 2018-2019

Figure 6.4

Figure 6.4, the admin gets the various options from the options so preset.

Figure 6.5

Figure 6.5, shows the insert option of the admin

Dept. Of ISE Page 16

Bookshop Management 2018-2019

Figure 6.6

Figure 6.6, shows the delete option of the record.

Figure 6.7

Figure 6.7, shows the record is deleted.

Dept. Of ISE Page 17

Bookshop Management 2018-2019

Figure 6.8

Figure 6.8, shows the bill generation.

Figure 6.9

Figure 6.9, shows the file.

Dept. Of ISE Page 18

Bookshop Management 2018-2019

Figure 6.10

Figure 6.10, shows the empty file when the record is deleted.

Dept. Of ISE Page 19

Bookshop Management 2018-2019

CONCLUSION
Simplicity is never simple. As we have seen in this project, the process of creating a user-
friendly and straightforward platform that facilitates the administrator's job is one filled with
complexity. From understanding user requirements to system design and finally system
prototype and finalization, every step requires in-depth understanding and commitment
towards achieving the objectives of the project.
Although the student database management module is not fully integrated to the system and
used on real time, the system prototype demonstrates easy navigation and data are stored in a
systematic way. Overall, efficiency has improved and work processes simplified.
Although all the objectives have been met, the system still has room for improvement. The
system is robust and flexible enough for future upgrade using advanced technology and
Devices. We have tried to develop a system that can be a great help to the modern
technological world to register the requirements and needs from people. We have left all the
options open so that if there is any other future requirement in the system by the user for
enhancement of the system then it is possible to implement them.

Dept. Of ISE Page 20

Bookshop Management 2018-2019

FUTURE ENHANCEMENTS
Due to lack of time, design part is not so effective. Further enhancements can be made in
designing the screen. Some more forms can also be added so as to better retrieve the details.
Various other options can also be added for the better usability of the application. A number
of directions can be followed as an extension for this project. Online selling facility can be
added. Free delivery facility can be added. Credit cash facility can be provided in this
application. It can improve the efficiency and effectiveness in administration.

Dept. Of ISE Page 21