Chapter 1 INTRODUCTION 1. Intr Intro odu duct ctio ion n 1.2 Introduction Through Through this new Jewellery Jewellery management system, shop managers can easily handle their
shop and business transactions by accessing a single window This system will ha!e Utilities, Transactions and Report generations menus Utilities section will deal with bac"ing up databases either on daily basis, timely basis, monthly basis etc as set by the admin, adding new employee, deleting new employee, managing e#isting employee details, adding new customer, adding and deletions o$ new supplier, changing the password, categori%e di$$erent Jewellery items etc Transaction will deal with $inancial accounting part o$ this business scenario It will pro!ide in$ormation on sales, purchase, Cash In and Cash Out associated with this business process &enerating report by accessing in$ormation stored in database is another important $eature o$ this system This system will able to generate as per user re'uirement in user $riendly manner User does not re'uire any technical details to generate reports They ha!e to submit their re'uirements by using di$$erent options a!ailable This section will able to generate reports on sales, purchase, Cash In and Cash Out between a gi!en time inter!al I$ the date option will not be used, it will generate report $rom the starting date o$ business to the current date (owe!er user can re$ine their 'uery by using any speci$ic date and time In the modern era, computers ha!e made e!ery thing under one root and ha!e "nit the world together )!en the complicated and time consuming wor"s are made nothing by the computers *ecause o$ the technological IT re!olution computer has been made as th e core element element in e!ery place Computeri Computeri%ation %ation has become become an essential one, one, $or the people who pre$er speedy and an d ease o$ access (uman (u man beings are liable to ma"e mista"es and the output usually depends upon the e$$iciency o$ the persons in!ol!ed *ut computers could usually generate error output and highly e$$icient e$$icient which !aries depending on the per p er so n operating Je w e ll a r y ma na g e me n t s ys te m he lp s th e re ta il er to ma in ta in their their recor records ds proper properly lyand and accura accuratel tely y This This syst system em pro!id pro!ides es a user user $rie $riendl ndly y inter$ace $or controlling +urchaseand sales management systemThe proect entitled
-Jewellary .anagement /ystem0 is de!eloped with an aim o$ aut automat omatiing the the wor wor" " o$ Retailer The proect is de!eloped using .icroso$t isual isual *asic 2345ront )nd Tool Tool • .s46ccess 73334*ac" end tool • The proect is broadly di!ided into $ollowing modules • • • • • •
Details /upplier Details Item Details Order Details /ales Details *illing Details
6ll the abo!e modules are designed to meet the re'uirements o$ a Retailer Theinter$ace is de!eloped with a $eature rich inter$ace in ter$ace and user4$riendly )n!ironment
Scope This so$tware pro!ides solution $or database bac" up which will help to store old
records 6dmin has uni'ue user name and password $or using this so$tware (e can change password delete records, add new records )asy to analy%e sales and transaction details using report generation module 6dmin can generate monthly and yearly reports
Chapter 2 SYSTEM OVERVIEW 1. Exis Existi ting ng Syst Systee The e#isting system is handled han dled manually The system has a $ormatted accoun tingsystem
$or +urchase and /ales The indent is prepared when items are to be purchasedand bill is generated $or sale o$ items The system $ollows the predetermined purchaseand sales procedures 2. !ro" !ro"#e #e $ith $ith Exist Existin ing g syste syste
• • • • • • • • •
.anual systems are more time consuming 8arge number o$ ledger boo"s has to be maintained $or each transaction /ince the data are entered manually there are possibilities $or errors Data security is !ery minimal There is a possibility $or double entries /ince the transaction are mainly !i% paperwor" pape rwor" updating o$ data is !eryhard &enerating the reports in the desired $ormat is a tedious process Reporting to the higher o$$icials is not done through the proper channel Data stored on papers is subect to loss due to physical damage
%. So#u So#uti tion on on pro" pro"#e #e
The aim o$ this proect is to e!aluate the e$$icient and e$$icacy o$ de!eloping Jewellery shop so that business transactions are easy To do this a simple set o$ tables will be identi$ied $rom those in use at a database These tables will be e#plored and mapped 9ueries will be aimed at accessing data in its nati!e en!ironment
Chapter % &'R(W'RE ')( SO*TW'RE RE+,IREME)TS Techno#ogies ,sed in !ro-ect • •
* 23 as $ront end .icroso$t 6cess 6cess as bac" end
&ard$are Reuireents
+rocessor : +entium III or higher !ersion Ram : 7;3 .*
(ard Dis" : ;33 .* .onitor
=indows > isual isual studio 733? .icroso$t 6cess
Chapter 0 RE+,IREME)T ')'YSIS *easi"i#ity Study
One o$ the many stages in the system de!elopment li$e cycle is determining the $easibility o$ a proect 6 measure o$ how bene$icial or practical the de!elopment o$ a so$tware system will be to an organi%ation This analysis recurs, and how that technology can be o$ bene$it These studies can include policy recommendations $or imaging systems, document management, and wor"$low applic applicati ations ons $or an intera interacti cti!e !e proces processs o$ collect collecting ing and analy% analy%ing ing throug through h the li$e li$e cycle cycle 5easibility studies e#amine the organi%ation data with the client and searching $or cost4e$$ecti!e, !iable technical and non technical solutions
Econoic *easi"i#ity
The economic analysis o$ one proect counts $or the cost e$$ecti!eness o$ the proect The economic $easibility study @)5/A should demonstrate the net bene$it o$ the proposed application in light o$ the bene$its and costs to the agency, other state agencies and the general public as a
whole )conomic $easibility is generally the -bottom4line0 consideration $or most o$ the systems )conomic usti$ications includes a broad range on concerns that include cost4bene$it analysis, long term corporate incomes strategies, impact on other pro$it centres or products, cost o$ resources needed $or the de!elopment etc )conomic $easibility is measured under the $ollowing headsB 1 The proect $its in the proposed budget 7 The proect satis$ies the economic constraints =eather =eather the e#isting hardware will meet the budget proposed =eather =eather new so$tware is re'uired $or its wor"ing
Technica# *easi"i#ity
The technical $easibility o$ the system counts $or the technical acceptance o$ the system It re$ers to the ability o$ the process to ta"e ad!antage o$ the current state o$ the technology in pursing $arther impro!ement The technical a!ailable technology should be considered The criteria $or technical $easibility is 1 )asy to useB the the users users were assume assumed d to be normal normal ordinary ordinary people people ha!ing ha!ing "nowledge "nowledge o$ simple computer operation, so ease o$ use is a !ery essential $actor i$ we want to get the ob actually done 'uic"ly 7 ReliableB ReliableB we assume assume that the de!ice de!ice will recei!e recei!e a lot o$ shoc", shoc", $rom mishandl mishandling, ing, !ibration !ibrations, s, etc
)asy mainte maintenanc nancee o$ in$orm in$ormati ation on /ince the records o$ all the acti!ities per$ormed by the !arious sites are stored digitally and with the use o$ so$tware it becomes east to retrie!e and maintain data It is also easy to bac"up the data /a!e /a!e tim timee and and e$$o e$$ort rt /ince the entire data management tas" is done by the system, it sa!es lot o$ time, e$$ort and energy o$ the user to get the wor" done
; arious rious proces processes ses runnin running g The !ariou !ariouss proces processes ses that will will be runnin running g through through the proect proect e#ecution e#ecution time time can be summari%ed as $ollowsB 1 User lo login 7 Chan Changi ging ng pas passw swor ord d 6ddi 6dding ng new new ite item m 6dding 6dding new copies copies o$ o$ e#is e#isti ting ng item item ; iew an item tem 2 /ear /earch chin ing g an item item > )ntry )ntry o$ transact transaction ion detail detail@re @rentE ntEpurc purchas haseA eA ? Retu Return rn o$ o$ item items, s, i$ i$ rent rented ed F /ear /earch chin ing g a custo custome mer r 13 8oo"ing 8oo"ing at transactions transactions and incomes incomes 2 /ecureB the the system system should should be secure secure enough to pro!ide pro!ide access access to only authori%ed authori%ed users users In our proect the technical $easibility is considered up to a greater e#tent The so$tware is build using !isual basic 23 Thus the problem o$ non a!ailability o$ so$tware is eradicated The bac"end o$ the system is ./ access, which is $reeware database application +roposed system can be e#panded in $uture i$ re'uired +roposed system also pro!ides data security by password protecting
Chapter 3 SYSTEM (ESI4) ')( MO(EI)4 Entity Re#ationship (iagra
Login Password
Login Name
Login
Login Id
Item Id
Item Name Item
Item Weight
Jewelry Type Type Present Item Id
Purchase
Price/Quantity
#a$e
Item Quantity C. o!ile No. Customer
C. Phone No. C. Name
C. Id C. "ddress
Bill
Bill No. C. Id Item Id
(ata *#o$ (iagra !,RC&'SE MO(,E )
(alidate %upplier &etails
%upplier SUPPLIER
Details
(alidated %upplier &etails
%*PPLI'+
IT'
&'T"IL%
, (alidate Item &etails Item &etails
(alidated Item &etails
- %*PPLI'+
%upplier &etails
Indent Indent Details
IN&'NT
Indent eneration Indent %*PPLI'+
-
IT'
Item &etails
1
Indent &etails - IN&'NT &'NT eneration o2 (eri0cation +eport IN&'NT (eri0ed %*PPLI'+
Bill &etails
Item &etails
-
BILL
(eri0ed -
BILL
Item &etails
3 %toc4 *pdation*pdated Item -
IT'
&etails -
IT' Item &etails
S'ES MO(,E
6 (alidate Customer &etails Customer (alidated
customer Customer
customer
Customer &etails
C*%T5'+
7 Item &etails (alidate 5rder &etails (alidated
5rder &etails
5rder
5rder &etails
- C*%T5'+
Customer
8
&eli$ery
Billing &etails &eli$ery Bill eneration 5rder - - order
5rder &etails
&eli$ery Challan
&C#"LL"N
Customer
- C*%T5'+ -5rder -
IT' &C#"LL"N
Customer &etails 5rder &etails 9 %ales %ales Bill enerationBill
C*%T5'+
Bill &etails
Item &etails
%BILL
&eli$ery Challan &etails
Item &etails - &C#"LL"N ): %toc4 *pdation *pdate %upplier &etails -
%BILL
+eport Item &etails
-
IT'
eneration Quotation &etails Item &etails +eports
"N"''NT
-
IT'
-
%*PPLI'+
Item &etails
- Q*5T"TI5N
- C*%T5'+
-
Customer &etails
%ales 5rder &etails
5+&'+
Customi;ed Bill -
BILL
-
%BILL
Details %ales Bill &etails
Chapter 5 (ata"ase (esign
Table-cash In Date
GivenBy
ReceivedBy Amount
Remars
!R
8/))/,::3
cm<
3::
sample cash in amount
),
8/))/,::3 Carlo Brian
CJ
)3::
Payment o2 Credit
),3
Table-"ash!UT Date
"ate#or ReceivedB GivenBy Amount y y
8/):/,::3 '=penses CJ
Carlo
)3::
Remars >ood "llowance ?e=ample@
Table-"ash!UT"ate#ory "ate#ory Business Transaction '=penses iscellaneous
Table-"ate#ory Ty$e J'W'L+A J'W'L+A
Descri$tion Jewelry
B>B
!!gng
%
"
Table-"ustomer "ust "ust% "u "ust%L "ust%St "us "ust% "us "ust%"o "ust% "us "ust%R %(u &irstn st% ast(a reetAdd t%"i Provi t%)i ntact(u Birthd t%S emar mbe ame 'I me ress ty nce $ mber ate e* s r Carlo Brian
Pin Laid e
36 +am Isa!el ) :9,83) Pagrang on a ) 61, ayan
7/)1/) al %ample C) 98: e +ecord o2 Custom er
2!!g
u
2dgd2
g2dhg2g2 !$n $n$cn 316 1631666 !$n 113 73
/,,/) al 989 e
C,
ra<
<
ram
44 tower 4n4 iui
8/8/)9 al 88 e
C
rahe
4olar
"#'% 44 #
879 9811786 676 378 36
man 4arnat 369 987631 galo a4a 871 ,) re 3
Table-Division Ty$ e
Descri$tion
1/3/)9 al daily C1 86 e custom er
Table-"ustomer "ust "ust% "u "ust%L "ust%St "us "ust% "us "ust%"o "ust% "us "ust%R %(u &irstn st% ast(a reetAdd t%"i Provi t%)i ntact(u Birthd t%S emar mbe ame 'I me ress ty nce $ mber ate e* s r Carlo Brian
Pin Laid e
36 +am Isa!el ) :9,83) Pagrang on a ) 61, ayan
7/)1/) al %ample C) 98: e +ecord o2 Custom er
2!!g
u
g2dhg2g2 !$n $n$cn 316 1631666 !$n 113 73
/,,/) al 989 e
2dgd2
C,
DI& DI& DidE DidEs s &i$i &i$isi sion on L"& LadyEs &i$ision A ' enEs &i$ision N
Table-Em$loyee Em$ %(ic %(a me
Em$ %&irs t(a me
E m $% 'I
E Em$ Em$% Em Em Em$% m %Las Stree $% $%P "onta $% t(a tAddr "it rovi ct(u )i me ess y nce mber $
Em $%Bi rth day
E Em$ Em Em m %Birt $%R $%( $% Em$%Pic hPla em um Se ce ar ber *
J"P5 Juan &e Cru; ru; (icto ictorr %a Isa! 68,:: 7/)1 %anti a D la y %ur nti ela )) :: /)98 ago le ag : City o Cit y
CJ 'mp ,
J"P5 Carlo Pi Laid 36 +a Isa! :9)83 7/)1 %anti a Prog CJ &FGresume D Brian ne Pagra mo ela )) )61 /)98 ago le ram 'mp 4oGcute.! ng n , : City mer ) mp ayan >&
2g2dg H
d2gh d2gd2h d2g d2gd 36 13667 13 83766
"JI
a
"N man 4 * o<
man gg u road
6/6/ h!2g a )98 h le 9
67 :9716 ):/3 4sd )3 67766 /)98 13 7 9
4n
CJ 'mp
a le
CJ 'mp 1
3/8/ 4nhd a )98 le 8
CJ 'mp 3
Table-Em$loyee Em$ %(ic %(a me
Em$ %&irs t(a me
E m $% 'I
E Em$ Em$% Em Em Em$% m %Las Stree $% $%P "onta $% t(a tAddr "it rovi ct(u )i me ess y nce mber $
P'T' pete 4i huds !alma ma da4s 37 98763 + r ng on tta ng hina 1, 1,) alo 4an : re nad a
Em $%Bi rth day
E Em$ Em Em m %Birt $%R $%( $% Em$%Pic hPla em um Se ce ar ber *
1/8/ man a wor CJ )98 agal le 4ing 'mp 6 ore as a 6 acc oun t mai nta nan ce
CFG&ocum ents and %ettingsGs ssG&es4to pGimages.< pg
Table-Pass+ord Pass+ord pass
Table-Product "ate# ory
Unit Unit
Ty$e y$e
Divisi Unit%Pr ,t Item%Descri$tion on ice y
Remars
J'W'L )1DB "NDL DI& +A PP 'T
Dids "n4let )14 Bang4o4 old
,3::.: ) :
This is
J'W'L )1DB +IN L" L"& &A +A PP
Ladys ring )1DBPP
6:::.: : :
Ladies ring.
J'W'L )1DB "NDL DI& +A PP 'T
star
):.::
$eried !y us
:
Table-Purchase "at Divi Item%De , Su$$lier Purcha Ty$ "os Su$$lie Date%Pu Amo e#o Unit sio scri$tio t %Addres se%"od e t r%(ame rchased unt ry n n y s e J'W' )1D "ND DI& Dids L+A L+A BP L'T "n4let P )14
3 ,3: CJ :.:: ain
anila anila City
7/):/,:: ),3 ), 3 ::.: :
Table-Purchase "at Divi Item%De , Su$$lier Purcha Ty$ "os Su$$lie Date%Pu Amo e#o Unit sio scri$tio t %Addres se%"od e t r%(ame rchased unt ry n n y s e Bang4o4 old
anila ::::
J'W' )1D "ND DI& Dids , ,3: CJ L+A L+A BP L'T "n4let :.:: ain P )14 Bang4o4 old
anila anila City anila ::::
8/))/,:: 3:: ), 3 :.::
Table-Sales , !R%( Date "ustome "ustomer "ate Ty$ Divi Item%De Unit% Amo Unit t umber %Sold r%(ame %Address #ory e sion scri$tion Price unt y ),
7/3/, Carlo 36 ::3 Brian Pagrang Pine Laid ayan +amon Isa!ela ))
J'W' )1DB "ND DI& Dids L+A L+A PP L'T "n4let )14 Bang4o4 old
3 ,3:: ),3: .:: :.::
),1
8/))/ Carlo 36 ,::3 Brian Pagrang Pine Laid ayan +amon Isa!ela ))
J'W' )1DB "ND DI& Dids L+A L+A PP L'T "n4let )14 Bang4o4 old
) ,3:: ,3:: .:: .::
Table-Su$$lier Su$%S Su$%P Su Su$%"on Su$%"ont Su$%R Su$% Su$%"ont Su$%(a treetA Su$% rovinc $%) tactPers act(umb emar (umb act(umbe me ddres "ity e i$ on er s er r s CJ ain
ani anila la ani anill anila ::: Japo4 a : City
!2d!dg
2dg2
!aanu
4n4 4
ra<
44
:9,83) 61,
dh!d d2hgd 311 13616676 1363131 2 3 3 ytuu
786 97163667 768761 777 67
man 4arnat 371 4iran
%)
%,
31631
%
67678376
987631, diamo %1
789136),
Table-Su$$lier Su$%S Su$%P Su Su$%"on Su$%"ont Su$%R Su$% Su$%"ont Su$%(a treetA Su$% rovinc $%) tactPers act(umb emar (umb act(umbe me ddres "ity e i$ on er s er r s road
galor a4 e
3 36
)
nd seller
Table-Ty$e Ty$e
Descri$tion
"NDL'T
"n4let
B"NL'%
Bangles
B+"C'L'T
Bracelet
'"++IN
'arring
L55P
Loop
N'CDL "C'
Nec4lace
P'N&"NT
Pendant
+IN
+ing
Table-Unit Ty$e
Descri$tion
)1DBPP
)14 Bang4o4 old Per Piece
)1D%I
)14 %ingapore old
)1DW
)14 White old
)8DB
)84 Bang4o4 old
)8DC
)84 Chinese old
)8DJ
)84 Japan old
)8D%"
)84 %audi old
)8D%I
)84 %ingapore old
)8DW
)84 White old
,)D%
,)4 %audi old
,,DB
,,4 Bang4o4 old
,1DC
,14 Chinese old
Chapter > IN+UT) 6ND OUT+UT) 5OR./
Chapter ? R)+ORT/
Chapter F 8I.IT6TION/ 6s we are also student according to our !iews we ha!e tried our best o$ $ul$ill the Re'uirement about the proect inspire other awareness may be le$t some important things 6s we ha!e reali%ed later a$ter discussion in our $riends 1 isua isuall /tudio /tudio can can ma"e ma"e syste system m slower slower 7 6ny 6ny Une#pec Une#pected ted bug bug can be be cause cause the data data $ail $ailure ure
Chapter 13 5UTUR) )N(6NC).)NT This system is de!eloped such a way that additional enhancement can be done without much di$$iculty The reno!ation o$ the proect would increase the $le#ibility o$ the system 6lso the $eatures are pro!ided in such a way that the system can also be made better and e$$icient $unctionality The programs were coded in an easier and more structured manner so that may $urther modi$ications may be incorporated easily The processing time in this system is !ery lesser compared to e#isting system This system has good $le#ibility o$ accommodating any more changes that might arise in the $uture also In this system, data integrity is maintained and data redundancy is a!oided and it increase system system e$$ici e$$iciency ency The databas databasee is designed designed in such a way that it will be also also help$ul help$ul $or enhancement o$ the system
Chapter 11 CONC8U/ION The system -Jewellary .anagement system0 deals with purchase and sales processing o$ a Jewellary shop This system has been de!eloped to satis$y all the proposed re'uirements The process o$ recording details about supplier, item, *illing and customers is more simple simple and easy The system reduces the possibility o$ errors to a great e#tent and maintains the data in an e$$icient manner User $riendliness is the uni'ue $eature o$ this system The system generates the reports as and when re'uired The system is highly interacti!e and $le#ible $or $urther enhancement The coding is done in a simpli$ied and easy to understandable manner so that other team trying to enhance the proect can do so without $acing much di$$iculty di$$iculty The documentation will also assist in the process as it has also been carried out in a simpli$ied and concise way
Chapter 17 *I*8O&R6+(G 1 isual isual *asic *asic 23 $rom the the &round &round up, &ary Cornell Cornell,, Tata Tata .c&raw .c&raw (ill )ditio )dition n 7 The Complete Complete Re$erence Re$erence is isual ual *asic *asic 23 , Noel Jer"e, Tat Tataa .cgraw (ill (ill )dition )dition
isual isual *asic *asic 23 +rogrammin +rogramming g *lac" *oo", /ten /ten (ol%ner, (ol%ner, Dream tech tech +ress, +ress, Dreamtech Dreamtech +ress, New Delhi4733 ./4O$$ice ./4O$$ice 7333, 7333, .ichael .ichael *usy and and Rossell Rossell a /tult%, /tult%, *+* +ublicat +ublication, ion, New Delhi Delhi ; .icro .icro so$t so$t O$$i O$$ice ce 6cces 6ccesss *ible *ible by &roh &roh 2 /o$tware )ngineering a practionerHs approach4 Roger / +ressman, Tata Tata .c&raw (ill )dition > =or"ing =or"ing with 6ccess by RON .ans$ield, Tata .c&raw (ill +ublication