Book Shop Management System Introduction:
In today’s era computers have become a vital component of any enterprise for giving it proper directions and extensive control of the various activities to attain business objectives. objectives. Computer applications applications have affected affected scientific scientific & commercial knowledge. The information ystem of the old times totally differs from the todays. It is automation system of a book shop or any information system. In the previous ages the process of maintaining data and record seemed very difficult. !ow days" computer is very essential component. The implementation of computer based Information ystem can be depicted as the ease in handling and maintaining the data bank of any si#e. $ur project is on Book Shop Management System whichdeals with almost all the information information of %ook hop .It keeps the database database of customer customer records records and publishing records. It also also keeps the author list" charges charges and %ooktitle list. list. The business of %ook hop is spread all over the world. ' large record should should be maintained in a proper manner for running of %ook hop.The hop .The proposed system is a window based menu driven system. It reduces the paper works" works " time needed for doing various tasks etc. $ur project upholds the accuracy of data.
Project Objective:
The main objective of this work is to reduce the difficulties that are found in the present system. The present system re(uires a lot of paper works" manual works etc. The accuracy is less in the present system. The details must have to be stored manually in the present system. In the present system" the details of a particular book)transaction are stored in different registers by different persons* this often leads to data isolation and inconsistency. There is always an objective behind every innovation and behind every work. +e did have many objectives for our project which are described as follows, I. II.
To search records of a book efficiently. -rocessing a large amount of data effectively and efficiently.
III.
To provide better service.
IV.
It keeps database of publishing details" price and Customer record.
V.
In such a huge project where the amount of data to handle was tremendous" there was strong demand for greater accuracy and consistency.
VI.
ince the system is subjected to be accessed by number users" the system must safeguard sensitive and important data in a form that is accessible only to the authori#ed personal.
VII.
Input validation features to make sure that only correct information has been provided.
VIII. I.
It is easiest way to maintain publishing record data. It can generate knowledge about books.
.
It elps to /eep the entire information of the book shop in a systematic way so that it becomes easier to know about the books and sale)purchase.
I.
It also generates the reports like sales)purchase.
!"#$I%&"%M: 2name# 2mpid
-ay
3ob
-1addres s
-ublishi d
Supp(ier
-ublisher
-urchas e %1title
%id
-ublishid
$rder !o.
ha s Book
01id $rder !o
-rice
I%! !$
Bi((
$istributor
ell -rice C1id
%id
01id
ha s
-rice
01name eee
Cid 2mp1i d
'ustomer
01addres s
Book#cata(og
C1id %ook Type Cname Caddress
%ook Type
'omp(ete Structure which inc(udes Main Project
)ser
'reate )ser
'ustomer
)ser *ype Save )ser
View
Supp(ier
$etai(s
View
Product
View
'hange Password
Subject
View
Purchase Order
Sa(es Invoice Sp(ash
View
+umber o, modu(es and their descriptions: # -.
)ser: It is used to create a user along with its profile. It is also used to filter
an authori#ed user" in order to access the system. .
'ustomer: # This module of the system gathers customer’s information and inserts it into the database.
/.
Supp(ier: # This module gathers supplier’s information and inserts into the database.
0.
BOO1: # This module manages the insertion of product specific information into the system.
2.
Subject: # This module manages the various subject related details.
3.
Purchase Order: # This system generates the purchase order.
4.
Sa(es Invoice: # This system generates the sales invoice.
5.
%ttractive )ser Inter,ace: # This module creates user interface for the
customer" so that" the interaction with the system can be made easy" powerful" and effective.
$ata Structures ,or a(( the modu(es: #
*ab(e +ame : # Books $escription : # )sed to maintain Books records *erms )sed
$ata *ype
6idth
'onstraint
%ook1I0 %ook1!ame
!umber 6archar7 6archar7 6archar7 6archar7 6archar7 !umber 6archar7
45 85 85 85 85 85 45"7 455
-rimary /ey
Category1!ame 'uthor I%! !o of -ages 9nit-rice 0escription
*ab(e +ame : # Supp(ier $escription : # )sed to maintain Supp(ier records *erms )sed
$ata *ype
6idth
'onstraint
upplier1I0
!umber
45
-rimary /ey
Company!ame Contact -erson 'ddress -hone :ax 2mail
6archar7 6archar7 6archar7 6archar7 6archar7 6archar7
85 85 455 48 48 ;5
*ab(e +ame : # 'ustomer $escription : # )sed to maintain 'ustomer records *erms )sed
$ata *ype
6idth
'onstraint
CustomerI0
!umber
45
-rimary /ey
Contact:irst!ame Contact
6archar7 6archar7 6archar7 6archar7 !umber 6archar7 6archar7
85 85 455 48 8 48 ;5
*ab(e +ame : # Purchase7Order $escription : # )sed to maintain Purchase order records *erms )sed
-urchase$rderI0 0eliveary1'ddress -urchase$rder0ate
$ata *ype
6idth
'onstraint
!umber
45
-rimary /ey
!umber 0ate
45
:oreign /ey
*ab(e +ame : # Purchase7Order7$etai(s $escription : # )sed to maintain Purchase order detai(s records *erms )sed
$ata *ype
6idth
'onstraint
-urchase$rder I0
!umber
45
-rimary /ey
-urchase$rderI0 -urchase-roductI0 -urchase=uantity -urchase9nit-rice -urchase0iscount !et6alue
!umber !umber !umber !umber !umber !umber
45 45 45 45 45 45
:oreign /ey
*ab(e +ame : # Payment7$etai(s $escription : # )sed to maintain order records *erms )sed Invoice1!o $rder1I0 -ayment 0ues 0ate of -ayment 0iscount tatus
$ata *ype
6idth
'onstraint
!umber
45
-rimary /ey
!umber 0ate 6archar7 !umber !umber !umber
45
:oreign /ey
85 8 45"7 85
*ab(e +ame : # Stock7$etai(s $escription : # )sed to maintain Purchase order detai(s records *erms )sed
$ata *ype
6idth
'onstraint
%ook1I0
!umber
45
-rimary /ey
!o1 of1 Copies 0ate $f >atainces
!umber !umber
45 75
:oreign /ey
*ab(e +ame : # Supp(ay7$etai(s $escription : # )sed to maintain Purchase order detai(s records
*erms )sed
$ata *ype
6idth
'onstraint
upplay1I0
!umber
45
-rimary /ey
%ook1I0
!umber
45
:oreign /ey
*ab(e +ame : # Purchase7$etai(s $escription : # )sed to maintain Purchase order detai(s records *erms )sed
$ata *ype
6idth
'onstraint
upplier1I0
!umber
45
%ook1I0 =uantity Cost 0ate 1$f1 -ayment
!umber !umber !umber 0ate
45 75 45 45
"eports &eneration: # This system generates some reports" which are as follows, i.
'ustomer "eport: # It Collects customer id and generates various details
related to the customer like first name" last name" address" phone number" email address etc.
ii.
Purchase "eport: # It collects order id and generates information such as
supplier id" order date" product id (uantity" unit price" discount and net value.
iii.
Sa(es "eport: # It collects order id and generates information such as order
date" book name" (uantity" unit price" and amount.
iv.
It collects customer code and generates total annual transaction report of the customers.
*oo(s8P(at,orm9 ardware and So,tware "e;uirement Speci,ications %"$6%"! "!<)I"!M!+* Processor : # -entium I6 -rocessor
"%M
: # 4 ?% @'>
ard $isk: # 8 ?% Support
: # 6?')6?' supported >onitor AI? @2$<9TI$!B
SO=*6%"! "!<)I"!M!+* Operating System
: # +I!0$+ D)>2)E-)F)D
=ront !nd >anguage
: # 6isual %asic.!2T
Back !nd >anguage : # =<)-<=< "$BMS So,tware : # $racle 45?
Security Mechanisms: ecurity mechanisms mean different things to different people. The term GsecurityG is somewhat vague unless it is discussed in some context. ere are some points that could clarify what actually Hecurity >echanisms means, i. afe from malevolent programs. ii. !onintrusive. iii.
'uthenticated.
iv.
2ncrypted.
v. vi. vii. viii. i?.
'udited. +elldefined. 6erified. +ellbehaved. C7 or %4 certified
%ased on the above definition" the security mechanisms provided in our project are as follows,
I. )se o, +et@#comp(iant ,irewa(( on the server Aboth 6eb and $atabase: #
it basically separates a protected network from an unprotected one" on the Internet)Intranet. It screens and filters all connections coming from the Internet)Intranet to the protected AcorporateB network" and vice versa" through a single" concentrated security checkpoint. II. )se o, user id and password be,ore entering high(y secured areas on
the site i.e. %dministrative !ntry. III. )se o, O"%'>!: # O"%'>! provides extensive features to safeguard
our information from both unauthori#ed viewing intentional or inadvertent damage. This security is provided by granting or revoking privileges on a personbyperson and privilegesbyprivileges basis" and is in addition to any security our computer system already has.
The use of oracle lets us to implement the following security mechanisms, i.
+e have used create user" create ro(e" and grant commands to control data access.
ii.
+e have used =ine#grained access contro( A=&%'. It’s a new feature in $racleD i that allows us to implement security policies with functions and then use those security policies to implement rowlevel security on tables and views.
iii.
+e have used O"%'>! >%B!> S!')"I*C. It allows us to assign security labels to rows.
IV. )se o, D%V% techno(ogy: # It provides simple mechanisms for protecting
our computer Ai.e. database and filesB from evil programs like viruses. +e have used policytool utility to create a policy file that contains the appropriate permission.
=uture Scope and ,urther enhancement o, the project. =uture Scope o, the Project, ince the ystem is capable of generation historical data as well in date +are ouse. There is a further scope in improving the performance ystem to enhance the management of the customers with a goal to increase profitability of the company.
=urther !nhancement: # The project can be extended to make it 6%P# !nab(ed so that it can be accessed using a >icro%rowser build within a >obile.
*he c(ient o, the project ,
This ystem is capable enough to customi#e it as
per need of the specific organi#ation.
>imitation o, the Project
, This is the demo project so it can’t be use in
real world. %ecause" when the project is running it may produce some errors.
'nd the database is restricted because the upplier can’t add the records more than hundred records. This project can use more memory and more C-9. :inally" we can say that this project is made for the supplier but they can’t use in real. ?uidelines in writing the scope and delimitation. The scope and delimitation should include the
following,
4. ' brief statement of the general purpose of the study. 7. The subject matter and topics studied and discussed. ;. The locale of the study" where the data were gathered or the entity to which the data belong. J. The population or universe from which the respondents were selected. This must be large enough to make generali#ations significant. 8. The period of the study. This is the time" either months or years" during which the data were gathered.
