bookstore system
Post on 17-Feb-2018
229 Views
Preview:
TRANSCRIPT
-
7/23/2019 Bookstore System
1/69
BOOK STORE SYSTEM
1) INTRODUCTION TO SYSTEM
1.1) DEFINITION
Page 1 of 69
-
7/23/2019 Bookstore System
2/69
BOOK STORE SYSTEM(1) INTRODUCTION TO SYSTEM
Roopal Book Store is located at Mota Bazar, Anand (Gujarat). Mr. Bipin
Panchal is the owner of this Book tore. !he "ain reason for settin# up the Roopal
Book Storewas that there was no such $ook tore in that area that pro%ided all the
t&pes of $ooks to the students with #ood discount.
!he 'oopal tore deals with "an& thin#s i.e. Purchase, ales of the Books,
Maintenance of Books, etc. !he Book tore $rin#s the Books fro" its #o down and
sales the Books at their Book tore.
!he Book tore "aintains the record of the current rate of the Books. t also
"aintains the records of their endors (uppliers). t updates re#ularl& da& * to * da&.
(1.1) DEFINITION
Book store s&ste" will co"puterized the process like in+uir& of the $ooks,
selectin# the particular supplier for the order, placin# the order either $ased on in+uir&
or direct, recei%in# the order, "aintainin# the stock of order.
Page 2 of 69
-
7/23/2019 Bookstore System
3/69
BOOK STORE SYSTEM
2) INTRODUCTION TO EXISTING SYSTEM
Page 3 of 69
-
7/23/2019 Bookstore System
4/69
BOOK STORE SYSTEM
(2)
INTRODUCTION TO EXISTING MANUAL SYSTEM
-istin# s&ste" is $ased on "anual work and all the process are done
"anuall&, so the& "aintain re#isters and files for recordin# all the details of the
s&ste".
!he& "aintain se%eral re#isters for recordin# the entr& of dail& transactions
such as Purchase of Books fro" the endors as well as ales of the Books to the
custo"ers, etc.
!he& "aintain the record of the Books so the& keep each and e%er& infor"ation
re#ardin# the Books in the Book "aster file. n the si"ilar fashion the& "aintain the
records of their %endors so the& keep each and e%er& infor"ation re#ardin# their
%endors in the %endors "aster file.
!he& keep the $ill $ook or cash$ook to "aintain the record for each sale of the
Book or transaction in the Book tore.
!he& "aintain the re#ister or $ook for their %endors so the& can pa& the "one&
to the" after so"e ti"e.
!hus "aintainin# part& infor"ation, Book infor"ation, part& transaction,
usto"er transaction and all the thin#s are done "anuall&.
Page 4 of 69
-
7/23/2019 Bookstore System
5/69
BOOK STORE SYSTEM
3) REGUIREMENT OF ANALYSIS
3.1) NEED TO DEVELOP SUCH SYSTEM
3.2) SCOPE OF SYSTEM
3.3) BOUNDARIES OF PROPOSED SYSTEM
3.4) OBJECT OF PROPOSED SYSTEM
Page 5 of 69
-
7/23/2019 Bookstore System
6/69
BOOK STORE SYSTEM 3.) FACT GATHERING TECHNI!UES
() RE!UIREMENT OF ANALYSIS
(.1) Nee" to "e#elop $%&' $$te
(/) Answer the +uestion whether a new s&ste" is to $e installed or not0
(1) 2eter"ine the potential of the e-istin# s&ste".
(3) "pro%e the e-istin# s&ste".
(4) 5now what should $e e"$edded in the new s&ste".
(6) 2efine the pro$le"s and o$jecti%e in%ol%ed in a project.
(7) A%oid costl& repairs at a later sta#e when the s&ste" is i"ple"ented.
(8) A%oid crash i"ple"entation of a new s&ste".
(8) A%oid the 9:ardware Approach; i.e. #ettin# a co"puter first and then
decidin# how to use it.
(.*) SCO+E SYSTEM
As a part of the preli"inar& stud&, the scope of the s&ste"(a $road perspecti%e
of what the s&ste" is #oin# to do ) has to $e clearl& outlined. !his is useful for
esti"atin# the a"ount of effort re+uired, the cost in%ol%ed etc.
n an& Book tore Purchase and ales depart"ent pla& an i"portant role to
produce #reat i"a#e in "arket.
-
7/23/2019 Bookstore System
7/69
BOOK STORE SYSTEM
(.) BOUNDARIES OF +RO+OSED SYSTEM
!he $oundar& of the s&ste" is the $oundar& of the Book tore which encloses
the different depart"ents includin# the purchase and sale depart"ent which interact
with the e-ternal entities as endor and usto"ers.
(.,) OB-ECT OF +RO+OSED SYSTEM
!o pro%ide +uick and efficient "eans for perfor"in# sales related acti%ities and
to effortlessl& #enerate report of the s&ste".
!o pro%ide +uick and efficient "eans of perfor"in# Purchase related acti%ities
and to effortless #enerate report of the s&ste".
!o auto"ize the work such as $illin#, Book record, endor record, etc.
!o auto"ize the different t&pes of reports.
+ROBLEM IDENTIFICATION/
Page 7 of 69
-
7/23/2019 Bookstore System
8/69
BOOK STORE SYSTEM!he phase of s&ste" anal&sis process deals with pro$le"s, which are affectin#
in the current "anual s&ste". !he pro$le"s are those, which are affectin# the Roopal
Book Storein its dail& routine work.
As the #rowin# trend in nfo!ech
-
7/23/2019 Bookstore System
9/69
BOOK STORE SYSTEM!he pro$le" occurs when the sale of Book is "ore and when the "onthl&
report or $ill is #enerated then the owner has to #o throu#h lots of records and which
is %er& tedious task.
T0e Co2$%024 3
t is %er& ti"e consu"in# process to write each and e%er& entr& in the data$ase
re#ister. Also it takes a lot of ti"e if all the entries are repeated. n the s&ste"
processes such as "akin# different t&pe of reports, $illin#, tedious calculations are
e-a"ples of ti"eDconsu"in# process in the s&ste".
t is also ti"e consu"in# process to know the total nu"$er of sale done or the
total purchase of $ooks done $& the 'oopal Book tore when written "anuall& $ut
throu#h co"puterized s&ste" it takes less ti"e as it is speed& and accurate.
E"0t024 o Data3
Manual written data cannot $e chan#ed or edited once written. f there is a
"istake and if we tr& to ru$ and write it a#ain it "akes the re#ister %er& dirt& and
untid&, which crates a $ad i"pression of the $usiness. f data is entered incorrect
whole docu"ent #ets incorrect while errors cannot $e easil& sol%ed $& editin# wron#l&
entered data.
f one had done so"e wron# entr& then to edit the data one has to #o throu#h
lots of records and, a#ain and a#ain editin# the record "akes it difficult to read.
Data I2$e&%r0t3
As the data is stored in files or re#isters, it is not in a secure place. As the
stora#e "edia here are files and $ooks or re#isters there are chances of #ettin# these
stora#e "edia lost, torn, or it "a& #o in the hand of wron# person, which can destro&
the data$ase, or it can also $e destro&ed accidentall&. Also in the s&ste" data should
$e shown to the person accordin# to his position and post in the office, e%er&$od&
should not $e allowed to use all the data.
f the data #oes in the hand of wron# person then heEshe "a& take the
ad%anta#e of the data and the Book tore "a& #o in loss. o securit& is the "ajor
aspects of the Book tore.
Page 9 of 69
-
7/23/2019 Bookstore System
10/69
BOOK STORE SYSTEM Report Ge2erat0o23
After a certain ti"e period if the user wants to checks his total sales or total
profit or total e-penditure or "onthl& sale and si"ilar is the case with purchase than it
$eco"es %er& tedious for the owner to check all the respected date and accordin# to
the data creatin# respecti%e reports for the transactions. A co"puterized s&ste"
ha%in# report "akin# facilit& can do this jo$ easil& and also the owner can draw
different t&pes of charts and dia#ra"s to "ake hi" understand the ups and downs of
his Book tore.
504' Data Re"%2"a2&3
As "entioned in the current s&ste", due to "aintenance of so "an& re#isters there is
a hi#h redundanc& of data i.e. sa"e data is recorded repeatedl&.
Data I2&o2$0$te2&3
:ere as "entioned in the a$o%e step the sa"e infor"ation is written in "ore than
one place that creates the pro$le", when there is a chan#e or deletion in the recorded
data.
(.6) FACT GAT5ERING TEC5NI!UES
nfor"ation #atherin# in an& or#anization is not an eas& task.
it has to $e #athered in an or#anized wa& so that
(a) No $$te "eta0l$ are let o%t.
(7) R04't pro7le$ are 0"e2t00e".
(&) Repet0t0#e 8ork 0$ a#o0"e".
(") 9ro24 or 02&oplete "eta0l$ are 2ot &olle&te".
!o do this, a proper search strate#& "ust $e decided first, search
strate#& includes selectin# infor"ation sources and search "ethods.
Page 10 of 69
-
7/23/2019 Bookstore System
11/69
BOOK STORE SYSTEM t also includes "odelin# "ethods to "ake sense out of infor"ation so
collected.
:ere an o%erall idea a$out the search "ethods or fact #atherin#
techni+ues which are used while #atherin# the infor"ation, the& are=
(1) I2ter#0e8024.
(*) Re&or" 02$pe&t0o2.
() O7$er#at0o2.
!hese techni+ues are used in s&ste" anal&sis and desi#n sta#e.
ha%e %isited a "an& ti"es at the or#anization to #et infor"ation as well as the
$asic pro$le"s which are occurrin# in the current e-istin# "anual s&ste". As each
and e%er& person in the or#anization has different t&pes of jo$ to $e done so "et
so"e of the people of the or#anization.
(1) I2ter#0e8$3
nter%iew allows the anal&st to collect or #ather the infor"ation fro" the
indi%idual or #roup who are #enerall& the current user of the e-istin# s&ste" or
potential user of the proposed s&ste".
!he& "a& $e "ana#ers or e"plo&ee of the fir" itself who pro%ide the data for
the proposed s&ste" and who will $e affected $& it.
As far as inter%iew is concerned, it is a ti"e consu"in# process.
t is a $asic source of +ualitati%e infor"ation.
t allows the anal&st to disco%er areas of "isunderstandin#, indication of
resistance to the proposed s&ste".
Page 11 of 69
-
7/23/2019 Bookstore System
12/69
BOOK STORE SYSTEM nter%iew could $e (a) tructured ($) Fnstructured.
(/) Str%&t%re"3
:ere, it uses standardized +uestions as far as response of the +uestions is
concerned the& are di%ided into two for"ats=
(a) ?pen response for"at=
:ere the +uestions are answered in ones own words.
($) losed response for"at=
:ere set of prescri$ed answers is used.
(1) U2$tr%&t%re"3
:ere the +uestions are worded to suit the respondent that pro%ide the infor"ation
a$out the areas o%erlooked or not thou#ht to $e i"portant.
Ad%anta#es and 2isad%anta#es of structured and unstructured inter%iewin#=
AD:ANTAGES3
(/) Str%&t%re"3
nsures unifor" wordin# of +uestions to all respondents.
as& to ad"inister and e%aluate.
Cess inter%iew trainin# re+uired.
'esult in shorter ti"e.
(1) U2$tr%&t%re"3
Huestions can $e worded to suit the respondent.
Ma& produce the infor"ation a$out the areas o%erlooked or not thou#ht
to $e i"portant.
DISAD:ANTAGES3
Page 12 of 69
-
7/23/2019 Bookstore System
13/69
BOOK STORE SYSTEM(/)Str%&t%re"3
ost of preparation is hi#h.
uch hi#h le%el of structure "a& not alwa&s $e suita$le.
o"e respondent "a& resist to such structure.
(1) U2$tr%&t%re"3
nefficient use of inter%iewer and respondent ti"e.
'esults take a lon#er ti"e.
-tra ti"e re+uired for the collection of essential facts.
!he success of the inter%iew depends on the skill of the inter%iewer and
hisEher preparation for the inter%iew.
Anal&sts "ust also $e aware of the kinds of difficulties at so"e inter%iew,
and "ust know how to deal with the potential pro$le"s.
Fser inter%iews were conducted to deter"ine the +ualitati%e infor"ation. !hese
inter%iews which were unstructured inter%iews pro%ided opportunit& to #athered
infor"ation fro" respondents who are in%ol%ed in the process for a lon# ti"e.
!hese inter%iews pro%ided infor"ation such as
Acti%ities in%ol%ed in process of purchase.
Acti%ities in%ol%ed in process of sales.
Ci"itation of e-istin# s&ste".
!&pes and fre+uenc& of purchase.
!&pes and fre+uenc& of ales.
Problems faced by the user i the e!istig system"
Page 13 of 69
-
7/23/2019 Bookstore System
14/69
BOOK STORE SYSTEM
(*) Re&or" Re#0e83
t is said to $etter $elie%e in records than in people.
!hus a #ood anal&st alwa&s #ets facts fro" docu"ents.
An e-istin# s&ste" can $e $etter understood $& e-a"inin# e-istin# docu"ents,
for"s and files.
n record re%iew anal&st e-a"ine infor"ation that has $een recorded a$out the
s&ste" and users.
'ecords inspection can $e perfor"ed at the $e#innin# of stud& as an
introduction or later in stud& as a $asis for co"parin# actual operations with
what the records indicate should $e happenin#.
'ecords "a& include=
/)
-
7/23/2019 Bookstore System
15/69
BOOK STORE SYSTEM 'ecords do not show how tasks are perfor"ed or what acti%ities are actuall&
occurrin# and where decision "akin# power lies.
Anal&st throu#h #ood anal&sis can #et answers to +uestions like=
/)
-
7/23/2019 Bookstore System
16/69
BOOK STORE SYSTEM t is not the +uantit& of ti"e o$ser%ed is i"portant $ut the unorthodo- an#les of
o$ser%ation of the work content and "ethods are #oin# to $e rewardin#.
?$ser%ation #i%es anal&st the opportunit& to #o $ehind the scenes in an
or#anization to learn inside stor& to disco%er how thin#s work in new areas of
infor"ation.
?$ser%ation can look for=
(a) ?perational inefficiencies.
($) Alternate routes and procedures.
(c) nterruptions in the nor"al flow of work.
(d) !he usa#e of files and docu"ents.
(e) nfor"al co""unication channels, etc.
?n site o$ser%ation pro%ides close %iew of the workin# of the real s&ste".
:e can o$ser%e people, o$jects, docu"ents and occurrences of e%ents.
Page 16 of 69
-
7/23/2019 Bookstore System
17/69
BOOK STORE SYSTEM
Page 17 of 69
-
7/23/2019 Bookstore System
18/69
BOOK STORE SYSTEM
4) INTRODUCTION TO PROPOSED SYSTEM
(,) INTRODUCTION TO +RO+OSED SYSTEM
!he "anual s&ste" of Roopal Book Store is to $e co"puterized in order to
o%erco"e the pro$le"s, which affects the e-istin# "anual s&ste". o"puterizin# the
e-istin# s&ste" with the help of so"e pro#ra""in# lan#ua#e, data$ase packa#e
ease the work of the s&ste" up to a #reat e-tent.
Generall&, there has $een a criterion to work on an& jo$ or task for a specific
purpose. >o$od& works without specific detailed infor"ation a$out the particular task
he is perfor"in#. !hus, an& transaction can $e perfor"ed such as Purchase, ales
and Maintenance of Books. n the new co"puterized s&ste" the $asic and the initial
first step is to ask for a specific user lo#in na"e and password for it, thus it can also
take care of data securit&, now after when the user enters the necessar& details in the
lo#in na"e and password it checks for the correct password and allows the user of
the s&ste" to enter the "ain pa#e.
Page 18 of 69
-
7/23/2019 Bookstore System
19/69
BOOK STORE SYSTEMAs the user is inside the s&ste", the first screen of the s&ste" would $e a
welco"e "essa#e and a list of "enus.
n the usto"er Master screen the user can Add, dit, 2elete, a%e and
search an& particular record just $& selectin# the usto"er >u"$er fro" the list.
n the Author Master screen the user can Add, dit, 2elete, a%e and search
an& particular record just $& selectin# the Author >u"$er fro" the list.
n the Pu$lisher Master screen the user can Add, dit, 2elete, a%e and search
an& particular record just $& selectin# the Pu$lisher >u"$er fro" the list.
n the Book Master screen the user can Add, dit, 2elete, a%e and search an&
particular record just $& selectin# the Book >u"$er fro" the list.
n the endor Master screen the user can Add, dit, 2elete, a%e and search
an& particular record just $& selectin# the endor >u"$er fro" the list.
n the Purchase screen the user can Purchase the particular Books and the
screen will #i%e the a"ount as well as the total a"ount of these Books.
n the ales screen the user can sales the particular Books and the screen will
#i%e the a"ount as well as the total a"ount of these Books.
n the si"ilar wa& the ale of Books is perfor"ed. !he user can sale the
particular Books and the screen will #i%e the a"ount as well as the total a"ount of the
ite"s.
!he user can easil& find all the data an& ti"e with out wasta#e of ti"e throu#h
selectin# specific "enu used for specific purpose.
After the transaction is co"pleted the user can lo# off fro" the s&ste" $&
si"pl& +uittin# fro" the s&ste". A#ain if the user wants to enter in the s&ste" he "ust
Page 19 of 69
-
7/23/2019 Bookstore System
20/69
BOOK STORE SYSTEMinput the specific userna"e and password to enter. !he s&ste" will not allow an&
wron# password and will not allow to enter the s&ste", thus it is safe fro"
unauthorized access of the Book tore;s data.
TOOLS INFORMATION
M0&ro$ot :0$%al Ba$0& ;.< Fro2t=E2"/3
!o de%elop an& s&ste" alon# with the $ackDend tools which pro%ide access to
the data$ase and also sol%es the data$ase +ueries like oracle, to "ake a s&ste"
interacti%e with the user the use of frontDend tools co"es into the picture. !he frontD
end tools "ake the user interface with the s&ste" easier and also pro%ide a userD
friendl& en%iron"ent to the s&ste".
!his rich lan#ua#e ena$les &ou to de%elop "an& different t&pes of applications.
Kou can create &ou can create pro#ra"s that intersect with the hardware.
t is a pro#ra""in# lan#ua#e used to create window $ase application. isual
Basic is an old BA (Be#inners AllDpurpose &"$olic instruction code) lan#ua#e. t
"akes it %er& eas& to #et the user interface portion of &our application up and runnin#.
:undreds of functions and latest technolo#ical ad%ances ha%e $een added to
the lan#ua#e to "ake it an industrial * stren#th de%elop"ent en%iron"ent suita$le for
al"ost "& t&pe of windows application. !his is especiall& true with the ad%ent of
internet pro#ra""in# and o$ject oriented pro#ra""in#.
Microsoft isual Basic 7.L is one of the frontDend tool pro%ided $& Microsoft
nc. Microsoft isual Basic 7.L pro%ides a fast wa& to de%elop applications for
Microsoft
-
7/23/2019 Bookstore System
21/69
BOOK STORE SYSTEMo"e of the "ain eat%re$of :0$%al Ba$0& ;.
-
7/23/2019 Bookstore System
22/69
BOOK STORE SYSTEM isual Basic allows &ou to adopt "ore of parallel approach, with
independent sections of code for each option that the user "a& select.
!his is known as %ent dri%en pro#ra""in# lan#ua#e.
isual data tools (2!).
A2? 2ata ontrol (A2?2).
2ata report desi#n and 2ata for" wizards.
t also helps the user with the HC editor.
B& connectin# it with ?racle, HC state"ents can $e run and ter"inated
throu#h isual Basic 7.L.
isual Basic o"ponent creation.
!he lan#ua#e is %er& eas& and it pro%ides a %er& userDfriendl&
en%iron"ent while pro#ra""in# in isual Basic 7.L.
Packa#in# and 2eplo&"ent wizard.
Allows for the creation of pDcode and nati%e code files. pDcode is a
tokenized fro" of &our source code that will $e $roken down at runti"e
into "achine code, which is wh& isual Basic will create this
inter"ediatel& for"s.
an $e e-tended easil& throu#h the use of windows AP calls, hundreds
of third part& controls and 2CCs, and inte#ration with other windows
applications throu#h ?M and 2?M.
:as a shorter learnin# cur%e and de%elop"ent ti"e than ENN, 2elphi,
and e%en Power Builder.
Page 22 of 69
-
7/23/2019 Bookstore System
23/69
BOOK STORE SYSTEM Fsed $& "ost of the office suite tool as "acro lan#ua#e.
-
7/23/2019 Bookstore System
24/69
BOOK STORE SYSTEM isual Basic is %er& useful in desi#nin# and de%elopin#, effecti%e and
efficient windows $ased pro#ra"s
B helps in "akin# &our pro#ra" look +uite effecti%e and $eautiful.
Kou can add "enus, tool $ars, status $ars, te-t $o-es, etc. to $lank
window.
t is less ti"e consu"in# and "ore users friendl&. Also userDfriendl&
pro#ra"s can $e de%eloped %er& easil&.
DISAD:ANTAGES OF :ISUAL BASIC ;..< are l0$te" 7elo83
Page 24 of 69
-
7/23/2019 Bookstore System
25/69
BOOK STORE SYSTEM entral, eas& DtoDuse GF, distri$uted data$ase "ana#e"ent usin#
?racle nterprise Mana#er. Also ?racle O pro%ides %arious tools for
"ana#in# different task.
Pro%ides o$jectDrelation features such as a$stract data t&pe, o$ject
%iews etc.
t eli"inates all parentDchild relationships and instead represented all
data in the data$ase as si"ple rowEcolu"n ta$les of data %alues.
as& access to all data.
'educe data stora#e and redundanc&.
Professional ?'AC starts the 2BM (data$ase "ana#e"ent s&ste")
in the e-tended "e"or&, so "ore "ain "e"or& is a%aila$le for other
applications.
'elational "odel of data "ana#e"ent is $ased on ! theor&. BuiltDin
+uer& lan#ua#e is desi#ned in the '2BM, so that it can "anipulate
sets of data (one or "ore tuples).
Fser interface used with relational "odels is nonDprocedural $ecause
onl& what needs to $e done is specified and not how it has to $e done.
Fsin# an& of the other "ethods, &ou ha%e not onl& to specif& what need
to $e done $ut how it has to $e done as well.
ach ta$le is an independent entit& and there is no ph&sical relationship
$etween ta$les.
Fser re+uests for ta$le data are si"pl& not entertained, unless the
'2BM en#ine in oracle is loaded.
Page 25 of 69
-
7/23/2019 Bookstore System
26/69
BOOK STORE SYSTEM ?racle has special features of updatin# the data$ase, retrie%in#
infor"ation fro" data$ase, enforcin# securit& specifications, enforcin#
transaction consistenc&, data sharin#, opti"izin# HC state"ents i.e.
+ueries, and it also enforces securit& specifications.
FEATURES OF +RO+OSED SYSTEM
!he Book Store S$te of the Book tore is de%eloped to o%erco"e the
"ost of the pro$le"s occurrin# in the "anual s&ste" $& co"puterizin# the e-istin#
s&ste". !he features of the newl& proposed co"puterized s&ste" are descri$ed in
$rief as $elow=
After co"puterizin# the s&ste", the owner of the Book tore or the user of the
s&ste" can finish their work in least a"ount of ti"e and efforts. !he co"puterized
s&ste" has "an& #ains and efforts, which the "anual s&ste" can;t #i%e, in an& t&pe of
situations.
n an& "anual s&ste" if we take, the "ain pro$le" arisin# is to "aintain the
nu"$er of records and findin# a particular record. !he user here ha%e to calculate the
a"ount of particular ite" dependin# on the rate and +uantit& of ite"s sale or
purchase, $ut in the case of co"puterized s&ste" the user just has to enter the
Page 26 of 69
-
7/23/2019 Bookstore System
27/69
BOOK STORE SYSTEM+uantit& and rate the co"puter will auto"aticall& will $e calculatin# the a"ount of a
particular ite" and the #rand total also will $e calculated.
o"puterized s&ste" helps the user $& pro%idin# the accountin# details of the
current ti"e period and also pro%ides the facilit& of producin# the "onthl& reports for
"onthl& sale or "onthl& purchase so the owner can check whether the co"pan& is
doin# loss or profit.
-
7/23/2019 Bookstore System
28/69
BOOK STORE SYSTEM
Page 28 of 69
-
7/23/2019 Bookstore System
29/69
BOOK STORE SYSTEM
) SYSTEM DESIGNING
.1) DATA FLO" DIAGRAM
.2) DATA DICTIONARY
.3) I#O SCREEN OF PROPOSED SYSTEM
(6) SYSTEM DESIGNING
(6.1) DATA FLO9 DIAGRAM($) D. F. D./ @ CONTEXT LE:EL
DIAGRAM
!he data flow dia#ra"s are pictorial or #raphical representation of the outline of
the s&ste" stud&. !he data flow dia#ra" co%ers all the processes and data stora#e
area, which takes place durin# an& transaction in the s&ste". !he data flow dia#ra"s
are functionall& di%ided into conte-t le%el, ero le%el and first le%el data flow dia#ra"s.
S7ol$ %$e" 02 DFD$3
(/) Process= :ere flow of data is transfor"ed. e.#. Purchase of Books,
update in%entor& file, etc.
Page 29 of 69
-
7/23/2019 Bookstore System
30/69
BOOK STORE SYSTEM(1) -ternal ntit&= A source or destination of data, which is e-ternal to the
s&ste". .#. Part&, lient etc.
(3) A data flow= t is packet of data. t "a& $e in the for" of docu"ent, letter
etc.
(4) 2ata store= An& store data $ut with no reference to the ph&sical "ethod
of storin#.
Page 30 of 69
-
7/23/2019 Bookstore System
31/69
BOOK STORE SYSTEM
Page 31 of 69
-
7/23/2019 Bookstore System
32/69
BOOK STORE SYSTEM
DATA FLO" DIAGRAM
Page 32 of 69
-
7/23/2019 Bookstore System
33/69
BOOK STORE SYSTEM
DATA FLO" DIAGRAM
Page 33 of 69
-
7/23/2019 Bookstore System
34/69
BOOK STORE SYSTEM
DATA FLO" DIAGRAM
(6.*) DATA DICTIONARY
Page 34 of 69
-
7/23/2019 Bookstore System
35/69
BOOK STORE SYSTEM!he data dictionar& of an& s&ste" is an inte#ral co"ponent of structure
anal&sis, since data flow dia#ra"s $& the"sel%es do not full& descri$e the su$ject
under in%esti#ation a$out the s&ste".
A data dictionar& is a catalo# * a repositor& * of the ele"ents in the s&ste".
!hese ele"ents center on data and the wa& the& are structured to "eet user
re+uire"ents and or#anization needs. !his step of creatin# a data dictionar& is
si"ultaneous with the process of "akin# data flow dia#ra"(s). :ere all the data fields
in their respecti%e ta$les are allotted so as to access these data in the s&ste". !he
data ta$les are created in a $ackDend tool like Microsoft Access, ?racle, Io-Pro,
etc. :ere in the Book tore &ste" we are usin# ta$les created in ?racleO.L, as it is
the $ackDend tool used in the s&ste".
!he data dictionar& consists of different "ajor ele"ents like 2ata le"ents,
2ata tore @!a$les Fsed, 2ata Ilow, Processes and other -ternal entities used in
the s&ste". !he data dictionar& stores details and description of these ele"ents.
t is de%eloped durin# data flow anal&sis and assists the anal&sts in%ol%ed in
deter"inin# the s&ste" re+uire"ents. Anal&sts use data dictionar& for the followin#
i"portant reasons=
!o "ana#e the details in lar#e s&ste".
!o co""unicate a co""on "eanin# for all s&ste" ele"ents.
!o docu"ent the features of the s&ste".
!o facilitate anal&sis of the details in order to e%aluate the characteristics
and deter"ine where s&ste" chan#es should $e "ade.
!o locate errors and o"issions in the s&ste".
Page 35 of 69
-
7/23/2019 Bookstore System
36/69
BOOK STORE SYSTEM
!he data dictionar& contains different t&pes of descriptions for the data flowin#
throu#h the s&ste"=
Data Elee2t$is the "ost funda"ental le%el, which is also considered as the
$uildin# $lock for all other data in the s&ste". t refers to all the different data used like
fields, data ite", etc. to "ake the s&ste" full& functional irrespecti%e to the ta$le used
in the s&ste". :ere all the different t&pe of fields used to "ake ta$le are written
se+uentiall& without referrin# to the ta$les. !his process helps in the process of
Noral0at0o2 of ta$les.
>e-t to 2ata le"ents co"es the Data $tora4ewhich pro%ides the infor"ation
of where and how each data ele"ent is stored in which ta$le and it also #i%e
infor"ation of an& constraints if there. !his step also #i%es knowled#e of different data
t&pes used for different field and their size. All the nor"alized ta$les are showed in
data stora#e.
Data Flo8sta#e shows the flow of data in the s&ste". !his step is can $e
alread& seen in the data flow dia#ra"s a$o%e in this docu"ent. !his step refers to all
the data flow paths were transactions are done in the co"puterized s&ste".
!he data flow step also includes different processes used in the s&ste" and it is
followed $& Eter2al E2t0t0e$used in the s&ste".
Page 36 of 69
-
7/23/2019 Bookstore System
37/69
BOOK STORE SYSTEM DATA STORE TABLE USED/
2escri$ed $elow in detail.
!he a$o%e ta$les are descri$ed $riefl& and can $e understand
clearl& fro" $elow. ach ta$le is descri$ed alon# with different fields
used, their data t&pes, their size and constraints if an&.
!he "e$&r0pt0o2 o ta7le$is as follows=
Lo402
O7e&t0#e3!he Co#in ta$le contains the infor"ation a$out the different users and their
passwords, which are used to access the s&ste" as there are "ore than one users in
the Book tore &ste" and the& can access data pri%atel&. !he ta$le stores the data
as userna"e and password and thus pro%ides securit& to the s&ste". !his ta$le also
contains the ad"inistrator user and its password, so all the ri#hts are pro%ided to the
ad"inistrator and so"e ri#hts are not pro%ided $& the s&ste" to so"e local users.
Ta7le$ Reerre"3 Co#in
Ta7le Forat3
F0el" 2ae F0el" "e$&r0pt0o2 Tpe S0e Co2$tra02t
Fser lo#in Fser >a"e archar1 1L >o
Password Password archar1 1L >o
Huestion Fser +uestion archar1 6L >o
Answer Fser answer archar1 6L >o
:al0"at0o2$3
Page 37 of 69
-
7/23/2019 Bookstore System
38/69
BOOK STORE SYSTEM!he ta$le does not allow to the user to enter $lank record as $oth fields are not null
and it will show an error "essa#e if the an& of the field i.e. Co#in or the user while
creatin# new user for the s&ste" keeps password null.
Pro%ides an error "essa#e on #ettin# incorrect userna"e or password with error
"essa#e and does not allow enterin# in the s&ste" without correct userna"e or
password. !he s&ste" owner or ad"inistrator throu#h the s&ste" can create new
user.
+r0ar e3 Fser lo#in
Reere2&e e3 >o reference ke& in this ta$le.
A%t'or Ma$ter
O7e&t0#e3 !he Author Master ta$le contains the infor"ation a$out the different
Authors related to $ooks.
Ta7le$ Reerre"3Author Master
Ta7le Forat3
F0el"
2ae
F0el"
"e$&r0pt0o2
Tpe S0e Co2$tra02t
Acode Author ode archar1 7 Pri"ar& 5e&
Ana"e Author >a"e archar1 3L >ot null
:al0"at0o2$3
!he ta$le does not allow to the user to enter $lank field those are re+uired as those
fields are not null and it will show an error "essa#e if the an& of the field which is
re+uired is kept null $& the user while doin# an& transaction usin# this ta$le. Moreo%er,
in the author na"e cannot $e enterin# an& nu"erical.
+r0ar e3 Acode
Page 38 of 69
-
7/23/2019 Bookstore System
39/69
BOOK STORE SYSTEMReere2&e e3 >o 'eference ke& is there in this !a$le.
+%7l0$'er Ma$ter
O7e&t0#e3!he Pu$lisher Master ta$le contains the infor"ation a$out the different
Pu$lishers related to $ooks.
Ta7le$ Reerre"3 Pu$lisher Master
Ta7le Forat 3
F0el" 2ae F0el" "e$&r0pt0o2 Tpe S0e Co2$tra02t
Pcode Pu$lisher ode archar1 7 Pri"ar& 5e&
Pna"e Pu$lisher >a"e archar1 3L >ot null
:al0"at0o2$3
!he ta$le does not allow to the user to enter $lank field those are re+uired as those
fields are not null and it will show an error "essa#e if the an& of the field which is
re+uired is kept null $& the user while doin# an& transaction usin# this ta$le. Moreo%er,
in the pu$lisher na"e cannot $e enterin# an& nu"erical.
+r0ar e3 Pcode
Reere2&e e3 >o 'eference ke& is there in this !a$le.
Book Ma$ter
O7e&t0#e3!he Book Master ta$le contains the infor"ation a$out the different Books.
Ta7le$ Reerre"3Book Master
Ta7le Forat3
Page 39 of 69
-
7/23/2019 Bookstore System
40/69
BOOK STORE SYSTEM
F0el" 2ae F0el" "e$&r0pt0o2 Tpe S0e Co2$tra02t
Bcode Book ode archar1 7 Pri"ar& 5e&
Bna"e Book >a"e archar1 3L >ot >ull
Pucode Pu$lisher ode archar1 7 Iorei#n 5e&
Pna"e Pu$lisher >a"e archar1 3L >ot >ull
Bprice Book Price >u"$er 4 >ot >ull
s$n ode s$n code archar1 1L D
dition Book dition archar1 1L D
Ana"e Author na"e archar1 3L >ot null
:al0"at0o2$3
!he ta$le does not allow to the user to enter $lank field those are re+uired as those
fields are not null and it will show an error "essa#e if the an& of the field which is
re+uired is kept null $& the user while doin# an& transaction usin# this ta$le.
Moreo%er, in the $ook na"e cannot $e enterin# an& nu"erical.
+r0ar e3 Bcode
Reere2&e e3Acode fro" Author Master ta$le.
Pcode fro" Pu$lisher Master ta$le.
:e2"or Ma$ter
O7e&t0#e3 !he endor Master ta$le contains the infor"ation a$out the different
endors. !hus the ta$le contains the personal infor"ation of different endors.
Page 40 of 69
-
7/23/2019 Bookstore System
41/69
BOOK STORE SYSTEMTa7le$ Reerre"3 endor Master
Ta7le Forat 3
F0el" 2ae F0el" "e$&r0pt0o2 Tpe S0e Co2$tra02t
code endor ode archar1 7 Pri"ar& 5e&
na"e endor >a"e archar1 3L >ot null
Add/ Address of the endor archar1 6L >ot null
Add1 Address of the endor archar1 6L D
it& it& archar1 3L D
Pincode Pincode >u"$er O D
tate tate archar1 1L D
ountr& ountr& archar1 1L D
Phone Phone nu"$er nu"$er /6 >ot null
Ia- Ia- >u"$er archar1 /6 D
"ail "ail address archar1 3L D
:al0"at0o2$3
!he ta$le does not allow to the user to enter $lank field those are re+uired as those
fields are not null and it will show an error "essa#e if the an& of the field which is
re+uired is kept null $& the user while doin# an& transaction usin# this ta$le.
Moreo%er, in the %endor na"e, state, countr& cannot $e enterin# an& nu"erical.
+r0ar e3 ode
Reere2&e e3 >o 'eference ke& is there in this ta$le.
+%r&'a$e Tra2$a&t0o2
Page 41 of 69
-
7/23/2019 Bookstore System
42/69
BOOK STORE SYSTEMO7e&t0#e3!he Purchase transaction ta$le contains the infor"ation a$out the different
Books that are purchased in the $ookstore.
Ta7le$ Reerre"3 Purchase !ransaction
Ta7le Forat 3
F0el" 2ae F0el" "e$&r0pt0o2 Tpe S0e Co2$tra02t
Pcode Purchase code archar1 7 Pri"ar& ke&
Bcode Book code archar1 7 Iorei#n ke&
Bna"e Book na"e archar1 3L D
Acode Author code archar1 7 Iorei#n ke&
Ana"e Author na"e archar1 3L D
Pucode Pu$lisher code archar1 7 Iorei#n ke&
Puna"e Pu$lisher na"e archar1 3L D
Ht& Huantit& of $ook >u"$er 4 D
'ate Book rate >u"$er O,1 D
2iscount Book discount >u"$er 4 D
A"t Book a"ount >u"$er /L,1 D
Pdate Purchase date 2ate O >ot null
:al0"at0o2$3
!he ta$le does not allow to the user to enter $lank field $ecause not all the fields are
null and it will show an error "essa#e if the an& of the field which is re+uired is kept
null $& the user while doin# an& transaction usin# this ta$le.
+r0ar e3 Pode
Reere2&e e3 Bcode fro" $ook Master !a$le
Acode fro" Author Master !a$le
Pucode fro" Pu$lisher Master !a$le
Page 42 of 69
-
7/23/2019 Bookstore System
43/69
BOOK STORE SYSTEM
C%$toer Ma$ter
F0el" 2ae F0el" "e$&r0pt0o2 Tpe S0e Co2$tra02t
code usto"er ode archar1 7 Pri"ar& ke&
na"e usto"er >a"e archar1 3L >ot null
Address Address of the endor archar1 6L D
it& it& archar1 16 D
Pincode Pincode >u"$er /L D
Phone Phone >u"$er >u"$er /6 D
:al0"at0o2$3
!he ta$le does not allow to the user to enter $lank field those are re+uired as those
fields are not null and it will show an error "essa#e if the an& of the field which is
re+uired is kept null $& the user while doin# an& transaction usin# this ta$le.
Moreo%er, in the custo"er na"e cannot $e enterin# an& nu"erical.
+r0ar e3 code
Reere2&e e3 >o 'eference ke& is there in this ta$le.
Sale$ Tra2$a&t0o2
O7e&t0#e3!he ales !ransaction ta$le contains the infor"ation a$out the different
Books that are sales in the $ookstore.
Ta7le$ Reerre"3 ales !ransaction
Ta7le Forat 3
F0el" 2ae F0el" "e$&r0pt0o2 Tpe S0e Co2$tra02t
code ales code archar1 7 Pri"ar& ke&
Page 43 of 69
-
7/23/2019 Bookstore System
44/69
BOOK STORE SYSTEM
Bcode Book code archar1 7 Iorei#n ke&
Bna"e Book na"e archar1 3L D
Acode Author code archar1 7 Iorei#n ke&
Ana"e Author na"e archar1 3L D
Pucode Pu$lisher code archar1 7 forei#n ke&
Puna"e Pu$lisher na"e archar1 3L D
Ht& Huantit& of $ook >u"$er 4 D
'ate Book rate >u"$er O,1 D
2iscount Book discount >u"$er 4 D
A"t Book a"ount >u"$er /L,1 D
date ales date 2ate O >ot null
:al0"at0o2$3
!he ta$le does not allow to the user to enter $lank field $ecause all the fields are not
null and it will show an error "essa#e if the an& of the field which is re+uired is kept
null $& the user while doin# an& transaction usin# this ta$le.
+r0ar e3 Pcode
Reere2&e e3Bcode fro" $ook Master !a$le
Acode fro" Author Master !a$le
Pucode fro" Pu$lisher Master !a$le
Page 44 of 69
-
7/23/2019 Bookstore System
45/69
BOOK STORE SYSTEM
(6.) IO SCREENOF +RO+OSED SYSTEM
!his section refers to the %arious t&pes of interfaces, which the user has to face
durin# operatin# the co"puterized s&ste" of Book tore &ste".
!he section refers with the entire interface @creens a user will ha%e to face
while operatin# the current s&ste". t shows the %arious screens appearin# for
different transactions. All the screens of different transactions in the s&ste" are shown
here. !he different transaction;s screens shown here are in the $elow #i%en order=
Co#in creen.
Main &ste" creen.
Master.
usto"er Master
Author Master
Pu$lisher Master
Book Master
endor Master
!ransaction
Page 45 of 69
-
7/23/2019 Bookstore System
46/69
BOOK STORE SYSTEM Purchase
ales
'eports
Book nfor"ation 'eport
endor nfor"ation 'eport
usto"er nfor"ation 'eport
Pu$lisher nfor"ation 'eport
Author nfor"ation 'eport
urrent tock 'eport
2ail& ales 'eport
Monthl& ales 'eport
Kearl& ales 'eport
ales 'eport
Purchase Cist
A$out 2e%eloper
Add Fser
-it
Page 46 of 69
-
7/23/2019 Bookstore System
47/69
BOOK STORE SYSTEM
SCREENS
LOGIN3
!he a$o%e #i%en screen is the user lo#in screen in which the user can lo#on the
s&ste".
Page 47 of 69
-
7/23/2019 Bookstore System
48/69
BOOK STORE SYSTEM
MAIN SCREEN
!he a$o%e #i%en screen is the "ain screen of the s&ste".
Page 48 of 69
-
7/23/2019 Bookstore System
49/69
BOOK STORE SYSTEMCUSTOMER MASTER
The above given screen is the user login screen in which the user can
logon the system.
!he a$o%e #i%en screen is the custo"er "aster screen in which the user can add
new custo"er, sa%e, edit, delete, search a particular custo"er, cancel the operation,
and finall& e-it fro" the for".
Page 49 of 69
-
7/23/2019 Bookstore System
50/69
BOOK STORE SYSTEM+UBLIS5ER MASTER
!he a$o%e #i%en screen is the pu$lisher "aster screen in which the user can add
new pu$lication, sa%e, edit, delete, search a particular pu$lication, cancel theoperation, and finall& e-it fro" the for".
BOO MASTER
Page 50 of 69
-
7/23/2019 Bookstore System
51/69
BOOK STORE SYSTEM
!he a$o%e #i%en screen is the $ook "aster screen in which the user can add new
$ook, sa%e, edit, delete, search a particular $ook, cancel the operation, and finall& e-it
fro" the for".
:ENDOR MASTER
Page 51 of 69
-
7/23/2019 Bookstore System
52/69
BOOK STORE SYSTEM
!he a$o%e #i%en screen is the %endor "aster screen in which the user can add new
%endor, sa%e, edit, delete, search a particular %endor, cancel the operation, and finall&
e-it fro" the for".
Page 52 of 69
-
7/23/2019 Bookstore System
53/69
BOOK STORE SYSTEM+URC5ASE TRANSACTION
!he a$o%e #i%en screen is the purchase transaction screen in which the user can add
new purchase $ook, sa%e, edit, delete, search a particular purchase $ook, cancel theoperation, and finall& e-it fro" the for".
Page 53 of 69
-
7/23/2019 Bookstore System
54/69
BOOK STORE SYSTEMSALES TRANSACTION
!he a$o%e #i%en screen is the sales transaction screen in which the user can add
new sales $ook, sa%e, edit, delete, search a particular sales $ook, cancel the
operation, and finall& e-it fro" the for"
Page 54 of 69
-
7/23/2019 Bookstore System
55/69
BOOK STORE SYSTEMBOO INFORMATION RE+ORT
!he a$o%e screen displa&s the pu$lisher code, author na"e, $ook na"e,pu$lisher na"e, $ook price, and B> code, $ook edition.
Page 55 of 69
-
7/23/2019 Bookstore System
56/69
BOOK STORE SYSTEM:ENDOR INFORMATION RE+ORT
!he a$o%e screen displa&s the %endor na"e, address, cit&, pin code, state,countr& ,phone nu"$er, fa- nu"$er and e"ail address.
Page 56 of 69
-
7/23/2019 Bookstore System
57/69
BOOK STORE SYSTEMCUSTOMER INFORMATION RE+ORT
!he a$o%e screen displa&s the custo"er code, author na"e, $ook na"e,pu$lisher na"e, $ook price, and B> code, $ook edition.
Page 57 of 69
-
7/23/2019 Bookstore System
58/69
BOOK STORE SYSTEM+UBLIS5ER INFORMATION RE+ORT
!he a$o%e screen displa&s the pu$lisher code, pu$lisher na"e.
Page 58 of 69
-
7/23/2019 Bookstore System
59/69
BOOK STORE SYSTEMAUT5OR INFORMATION RE+ORT
!he a$o%e screen displa&s the author code, author na"e.
Page 59 of 69
-
7/23/2019 Bookstore System
60/69
BOOK STORE SYSTEMCURRENT STOC RE+ORT
!he a$o%e screen displa&s the sales code, author na"e, $ook na"e,
pu$lisher na"e, $ook +uantit&, sales date.
Page 60 of 69
-
7/23/2019 Bookstore System
61/69
BOOK STORE SYSTEMDAILY SALES RE+ORT
!he a$o%e screen displa&s the sales date, author na"e, $ook na"e,pu$lisher na"e, $ook +uantit&, $ook price, and discount of $ook, $ook
a"ount.
Page 61 of 69
-
7/23/2019 Bookstore System
62/69
BOOK STORE SYSTEMMONT5LY SALES RE+ORT
!he a$o%e screen displa&s the sales date, author na"e, $ook na"e,pu$lisher na"e, $ook +uantit&, $ook price, and discount of $ook, $ook
a"ount.
Page 62 of 69
-
7/23/2019 Bookstore System
63/69
BOOK STORE SYSTEMYEARLY SALES RE+ORT
!he a$o%e screen displa&s the sales date, author na"e, $ook na"e,pu$lisher na"e, $ook +uantit&, $ook price, and discount of $ook, $ook
a"ount.
Page 63 of 69
-
7/23/2019 Bookstore System
64/69
BOOK STORE SYSTEMSALES RE+ORT
!he a$o%e screen displa&s the sales code, $ook na"e.
Page 64 of 69
-
7/23/2019 Bookstore System
65/69
BOOK STORE SYSTEM+URC5ASE LIST
!he a$o%e screen displa&s the author na"e, $ook na"e, pu$lisher na"e,$ook +uantit&, $ook price, and discount of $ook, $ook a"ount, and
purchase date
Page 65 of 69
-
7/23/2019 Bookstore System
66/69
BOOK STORE SYSTEMABOUT DE:ELO+ER
!he a$o%e screen displa&s the infor"ation a$out de%eloper, s&ste"
infor"ation.
ADD USER
Page 66 of 69
-
7/23/2019 Bookstore System
67/69
BOOK STORE SYSTEM
!he a$o%e screen &ou can chan#e the ser password, user +uestion, user
answer also add user, edit, sa%e, cancel operation, delete the user, search
the particular user and last e-it the for".
EXIT
Page 67 of 69
-
7/23/2019 Bookstore System
68/69
BOOK STORE SYSTEM
!he a$o%e screen displa&s c the e-it of s&ste".
Page 68 of 69
-
7/23/2019 Bookstore System
69/69
BOOK STORE SYSTEMReere2&e$
Masterin# isual Basic 7
%an#elos Petroutsos
top related