TABLE OF CONTENTS Sr. No. 1. 2.
3.
Page No.
Page Title List Of Figures And Tables Introduction 2.1. Inventory 2.2. Types of inventories 2.3. Inventory control 2.!. Advantagesofinventorycontrol 2.5. #ole of sales analysis in profit $a%i$i&ation #evie( Of Literature 3.1. *cope of t+e pro,ect 3.2. -ro$inent features of our soft(are pro,ect 3.2.1. ill generation 3.2.2. Accuraterecordingofdailysales 3.2.3. /alculation of reorder level and reorder
3 5 5 6 " ' 1) 1) 11 11 11 12
0uantity 3.2.!. 3.2.5. 3.3.
!.
A/ analysis feature for product classification ffective and user friendly grap+ical user
interface esignanddevelop$ent$et+odology 3.3.1. icrosoft4isualasic.T 3.3.2. /rystal #eports 3.3.3. icrosoft*L*erver2)))
7or8 -lan Of !.1. atabase *c+e$a !.2. Ad$inistrator9s:serInterface !.2.1. Analysis !.2.1.1. A/Analysis
!.2.2. !.2.3.
!.2.!.
!.2.5.
!.2.6.
13 1 1" 1' 21 22
2! 25 2 2' 2'
!.2.1.2. -roduct/o$parison !.2.1.3. Ti$elineAnalysis /+ec8 Alerts /lient#egistration !.2.3.1. /reatee(:ser !.2.3.2. dit:seretails -roductInfor$ation !.2.!.1. Adde(-roduct !.2.!.2. -roduct*earc+ !.2.!.3. -roduct:pdate !.2.!.!. -roductelete #eorder*trategy
31 35 3" 3' 3' !) !1 !1 !2 !! !6 !
!.2.5.1. Add*upplyInfor$ation !.2.5.2. *earc+ *upply Infor$ation 4endorInfor$ation !.2.6.1. Adde(4endor !.2.6.2. 4endor*earc+
! !" 5) 5) 51
1
5. 6. .
!.2.6.3. 4endor:pdate !.2.6.!. 4endorelete !.3. /lient*ide:serInterface !.3.1. illing odule !.3.1.1. Login*creen !.3.1.2. illingFor$ !.3.1.3. -rintedill !.3.1.!. /+angeof-ass(ord Testing And #esults /onclusion #eferences
53 5! 55 55 55 56 5 5" 5' 66 6
2
1. LIST OF FIGURES AND TABLES: Sr. No. 1. 2.
ar ;rap+ s+o(ing A/classification e%a$ple A/classificatione%a$pletables
3. !. 5. 6. . ". '. 1). 11. 12. 13. 1!. 15. 16. 1. 1". 1'. 2). 21. 22. 23. 2!. 25. 26. 2. 2". 2'. 3). 31.4 32. 33. 3!. 35. 36. 3. 3".
atabase *c+e$a Ad$inistrator9s =o$eFor$ enu ite$s provided by t+e ad$inistrator +o$e for$ A/ Analysis for$ s+o(ing product classification report A/Analysisfor$s+o(inganalysisreport esign and (or8ing of -roduct /o$parison for$ esignof/o$parison#eportfor$ ar ;rap+ #epresentation of /o$parison #eport -ie /+art #epresentation of /o$parison #eport etailed /ubic 4ie( #epresentation of /o$parison #eport Ti$e>line*ales*tudyfor$design Ti$e>line report (it+ daily co$parison line grap+ Ti$e>line report (it+ sales co$parison over $ont+s Alertsfor/lass?A9and/lass?9products /lient #egistration For$ essagebo%esin/lient#egistrationFor$ For$foreditingclientdetails essage bo%es s+o(n (+ile editing client details e(-roductInfor$ationFor$ -roduct *earc+ For$ -roduct*earc+#esultFor$ Alert(+ileupdatingt+e-roduct essage bo% indicating t+at t+e :pdate (as successful Alert(+ileeletingt+e-roduct e(*upplyInfor$ationFor$ *upplyInfor$ation*earc+For$ *upplyInfor$ation*earc+#esultFor$ e(4endorInfor$ationFor$ endor *earc+ For$ 4endor*earc+#esultFor$ Alert(+ileupdatingt+e4endor Alert(+ileeletingt+e4endor LoginFor$oft+eillingodule illing For$ -rinted ill /+ange of -ass(ord For$
List of Figures
Page No. 1! 15<16 25 2 2" 2' 3) 31 32 33 3! 3! 35 36 3 3" 3' 3' !) !) !1 !2 !3 !! !5 !6 ! !" !' 5) 51 52 53 5! 55 56 5 5"
3
Sr. No. 1. 2. 3. !. 5.
List of Tales Testprocedure@Forvalidad$inistratorlogin Test procedure@ For invalid ad$inistrator login Testprocedure@ForA/analysis Test procedure@ For -roduct co$parison option selection Test procedure@ For Ti$e span selection in ti$eline
Page No. 5' 5' 5' 6) 6)
6.
co$parison report Test procedure@ For c+ec8ing accuracy of co$parison ti$eline
6)
.
reports Test procedure@ For c+ec8ing alerts for /lass ?A9 and ?9
61
". '. 1). 11. 12. 13. 1!. 15. 16. 1. 1". 1'.
products Testprocedure@Forvalidclientregistration Test procedure@ Forinvalid clientregistration Testprocedure@Forsearc+ingproduct Test procedure@ For updating or deleting product Test procedure@ For searc+ing supply infor$ation Test procedure@ For updating or deleting supply infor$ation Testprocedure@Forsearc+ingvendor Test procedure@ For updating or deleting vendor Testprocedure@Forvalidclientlogin Testprocedure@Forinvalidclientlogin Test procedure@ For bill generation ite$ re$oval Test procedure@ For bill generation ite$ addition
61 61 62 62 62 63 63 63 6! 6! 6! 65
4
!. INTRODUCTION !.1. IN"ENTOR# Inventory can be defined in several (ays as follo(s as given belo(@
•
Inventory is t+e stoc8 of p+ysical ite$s suc+ as $aterials< co$ponents< (or8>in>progress< finis+ed goods< etc.< +eld at a specific location at a specific ti$e.
•
Inventory is t+e $erc+andise t+at is purc+ased andor produced and stored for eventual sale.
•
Inventory is a list of (+at you +ave. In co$pany accounts< inventory usually refers to t+e value of stoc8s< as distinct fro$ fi%ed assets. An inventory (ould include ite$s (+ic+ are +eld for sale in t+e ordinary course of business or (+ic+ are in t+e process of production for t+e purpose of sale< or (+ic+ are to be used in t+e productio n of goods or services (+ic+ (ill be for sale.
•
Inventory is a list of na$es< 0uantiti es andor $onitory value s of all or any group of ite$s.
•
Any 0uantifiable ite$ t+at you can +andle< buy< sell< store< consu$e< produce< or trac8 can be considered inventory. T+is covers everyt+ing fro$ office and $aintenance supplies< to ra( $aterial used for $anufacturing< to se$i>finis+ed and finis+ed goods< to fuel used to po(er e0uip$ent used in t+e business.
5
!.!. T#PES OF IN"ENTORIES epending up on t+e type of organi&ation t+e inventory can be classified into t(o basic types. T+ey are as follo(s@
1.
$a%ufa&turi%g I %'e%tor(:
It is t+e inventory $aintained by a $anufacturing organi&ation.
anufacturing Inventory consists of follo(ing t+ree parts@
a. #a( aterials B#C (+ ic+ are proc essed to $anufacture t+e final product. b. 7or8 In -rog ress B7I-C (+ic + refers to t+e inter $ediate product (+ic+ is obtained by processing t+e ra( $aterial but is not fully converted into final product. c. Finis+ ;oods BF;C t+a t are t+e fully pro cessed final products t+at are being $anufactured and are ready to be dispatc+ed.
!.
Tra)i%g I %'e%tor(:
It is t+e inventory $aintained by a trading organi&ation (it+ a purc+ase and sale business.
Trading Inventory consists of goods t+at are purc+ased fro$ a supplier or $anufacturer and sold to custo$ers (it+ a certain $argin of profit.
In t+is case< t+e purc+ased goods do not undergo any furt+er processing and are sold directly (it+out any c+ange of for$.
T+e Trading Inventory is also referred as t+e ter$ ?*toc89.
6
!.*. IN"ENTOR# CONTROL T+e c+ief $otive of an organi&ation is +Profit $a,i-iatio%/. Inventory is an essential part of an organi&ation since it is one of t+e $a,or factors t+at affect t+e profit earned by t+e organi&ation. =ence controlling or $anaging inventory is one of t+e $ost i$portant tas8s necessary to ac+ieve organi&ational goal of earning $a%i$u$ profit and reducing costs and e%penses.
Inventory Control is a technique of maintaining and monitoring the size of the inventory at appropriate level, so that the production and distributions take place effectively.
T+e $ain ob,ective of inventory control is to ac+ieve $a%i$u$ efficiency in production and sales (it+ t+e $ini$u$ invest$ent in inventory.
Inventory /ontrol is ac+ieved by@
-urc+asing ite$s at proper ti$e and price< and in rig+t 0uantity.
-rovision of suitable storage locations (it+ sufficient space.
aintaining proper level of stoc8s.
Ade0uate inventory identification syste$.
:p>to>date and accurate record 8eeping.
Appropriate re0uisition procedures.
7
!.0. AD"ANTAGES OF IN"ENTOR# CONTROL Inventory control or $anage$ent +as several advantages as stated belo(@
1.
-rovides protection against fluctuations in d e$and and supply by $onitoring t+e trends in de$and and supply.
2.
nsures a better service to t+ e custo$ers by avoiding t+e out of stoc8 situations by 8eeping a c+ec8 on t+e $ini$u$ stoc8 levels.
3.
=elps to reduce ris8 of loss on account of obsolescence or deterioration of ite$s.
!.
=elps to re duce ad$inistrative (or8 load in r espect of purc+asing< inspection< store>8eeping< etc. t+us in turn reducing $anpo(er re0uire$ents< and conse0uently costs.
5.
=elps to $a8e effective utili&ation of (or8ing capital by avoiding its bloc8age in e%cess inventory.
6.
nsures to $aintain a c+ec8 against loss of $aterials t+ roug+ carelessness or pilferage.
.
Facilitates cost accounting activities.
li$inates t+e possibility of duplication in ordering or in replenis+ing stoc8s by centrali&ing t+e source fro$ (+ere t+e purc+ase orders are issued.
8
!.. ROLE OF SALES ANAL#SIS IN PROFIT $A2I$I3ATION Inventory control is not all about $anaging stoc8s and ordering goods. ut inventory control co$bined (it+ efficient analysis tools can be truly effective as it can +elp us identify t+e trends in t+e de$and for various products by carrying out various types of analysis.
T+is includes co$parative study of sales as (ell as sales analysis concentrated on a single product.
/arrying out suc+ analysis at regular intervals can +elp t+e s+op $anager to decide upon t+e future reordering strategies and ta8ing so$e $a,or decisions regarding purc+ase of goods.
9
*. RE"IE4 OF LITERATURE: *.1. SCOPE OF T5E PRO6ECT APPLICATION OF IN"ENTOR# CONTROL OR STOC7 $ANAGE$ENT IN OUR SELECTED DO$AIN 8 A SUPER9$AR7ET Inventory $anage$ent or inventory control is a very useful tec+ni0ue for $anaging t+e stoc8s and sales records of a Suer9-ar;et (+ic+ is our selected do$ain of i$ple$entation for t+e soft(are.
T+e super>$ar8et stores and sales various products (+ic+ includes pac8ed foodstuffs and drin8s< $il8 products< glossary< decorative ite$s< cos$etics and $any ot+er products of day to day use. It also stores so$e costly ite$s li8e (rist (atc+es< s$all electronic goods< artificial ,e(elry etc. Also t+ere are so$e +ouse+old goods li8e (as+ing po(ders< cleaning e0uip$ents< gas8ets etc. anaging all t+ese products< sufficient stoc8s< sales records< also analy&ing sales and reordering fro$ ti$e to ti$e is a difficult ,ob. To do it $ore effectively and correctly a better
i%'e%tor( &o%trol or sto&;
-a%age-e%t is re0uired. T+is is provided by our soft(are ensuring an efficient inventory control and rigorous sales analysis facility.
Our soft(are +elps to $anage t+e daily sales records and assist in billing process as (ell. It also includes reordering level and reordering 0uantity and gives appropriate alerts< t+us $aintaining a safe stoc8.
T+e soft(are also provides aut+ori&ed users to perfor$ sales analysis of various products. y providing t+is facility< our soft(are (ill prove to be e%tre$ely useful to ad,ust t+e purc+ase and sales strategies leading to an increase in profit.
10
*.!. PRO$INENT FEATURES OF OUR SOFT4ARE PRO6ECT
ill generation
Accurate recording of daily sales
/alculation of reordering 0uantity and reordering level
A/ analysis feature for product classification
ffective and user friendly grap+ical user interface
*.!.1. Bill ge%eratio%
T+is (ill be useful for carrying out daily transactions of t+e super> $ar8et.
A bill of ite$s selected by t+e custo$er (ill be $ade and available stoc8 count (ill be ad,usted.
A receipt of sold ite$s (ill be printed and given to t+e custo$er.
*.!.!. A&&urate re&or)i%g of )ail( sales
T+e soft(are records an entry for eac+ unit of a product sold on daily basis by $aintaining a separate sales table.
T+e table contains t+e infor$ation about t+e nu$ber of units of a particular product sold on a given date.
aintaining suc+ a database enables easy analysis of past sales and studying t+e trends in $ar8et.
11
*.!.*. Cal&ulatio% of reor)er le'el a%) reor)er
T+e inventory level R in (+ic+ an order is placed is called as reorder level.
R = D.L
7+ere< D D de$and rate in units per days$ont+s L D lead ti$e in days$ont+s
Anot+er (ay calculation is<
R = >$a,i-u- reor)er erio)? @ >$a,i-u- usage? T+e reorder quantity is t+e nu$ber of units of t+e product (+ic+ $ust be ordered. It is denoted by .
#eorder 0uantity depends upon various factors li8e $a%i$u$ capacity of inventory< reorder period etc.
= $a,i-u- le'el of i%'e%tor( 8 Reor)er le'el 8 >$i%i-u- reor)er erio)?@>$i%i-u- usage?
7+en t+e inventory level of a particular ite$ falls belo( t+e t+res+old #< t+e soft(are (ill generate an alert $essage.
12
*.!.0. ABC a%al(sis feature for ro)u&t &lassifi&atio%. ABC a%al(sis also referred to as t+e Pareto a%al(sis is a $et+od of classifying ite$s< events< or activities according to t+eir relative i$portance. It is also 8no( as Ala(s Better Co%trol a%al(sis since it provides t+e $ost opti$u$ (ay of controlling inventory. It is fre0uently used in inventory $anage$ent (+ere it is used to classify stoc8 ite$s into groups based on t+e total annual e%penditure< or total stoc8+olding cost of eac+ ite$. It e%ercises discri$inating control over different ite$s of stores classified on t+e basis of invest$ent involved. Organi&ations can concentrate $ore detailed attention on t+e +ig+ valuei$portant ite$s. -areto analysis is used to arrive at t+is prioriti&ation. T+e first step in t+e analysis is to identify t+ose criteria (+ic+ $a8e a significant level of control i$portant for any ite$. T(o possible factors are t+e usage rate for an ite$ and its unit value. T+e general A/ classification goes as follo(s@
A Class of ite$s consist of only a s$all percenta ge about 91 of total nu$ber of units +andled by t+e stores but re0uire +eavy invest$ent about 9 of total inventory usage value because of t+eir +ig+ prices or +eavy re0uire$ent or bot+.
-aying $ore attention to A class ite$s using sop+isticated stoc8 control syste$ can give control of about )>")E of total stoc8 invest$ent. =ence A /lass ite$s are controlled closely to avoid overstoc8ing as (ell as s+ortage (+ic+ $ay lead to a considerable loss.
T+ese ite$s can be ordered fre0uently in s$aller 0uantities.
13
B Class ite$s are relatively less i$portant t+ey $ay be * of total nu$ber of units $anaged by t+e stores. T+e percentage of invest$ent re0uired is about 1 of t+e total invest$ent in inventory.
In case of class ite$s as t+e su$ involved is $oderate< t+e sa$e degree of control as applied in A class ite$s is not (arranted.
T+e orders of t+e ite$s belonging to t+is category can be placed after revie(ing t+eir situations periodically.
Fig. 1: Bar Graph showing ABC classification example C Class ite$s do not re0uire $uc+ invest$ent. It $ay be around 91 of t+e total inventory usage value but t+ey are nearly 9 of t+e total nu$ber of units +andled by t+e stores.
For / /lass ite$s t+ere is no need of e%ercising constant control. Orders for / /lass ite$s can be placed after a relatively larger period of ti$e (it+ large 0uantities after ascertaining t+e consu$ption re0uire$ents.
14
ABC Classifi&atio% e,a-le
Part 1 ! * 0 H 1 Fig. !.A
U%itCost * * * ! 1 *! 1 !
A%%uaU l sage H 0 1* 1 1 1 1!
Fro$ above infor$ation follo(ing para$eters are calculated
Part H ! 1 0 * 1 Total Fig. !.B
"alue i% Rs. * 1 10 0 0 *H * * !0 1 Rs.0
of
of
Total
Total
"alue *.H 1. 1.0 .* . 0. 0.! *. !. !.
ua%tit( . . 0. H. . 1. 1. 1*. 1!. 1.
Cu-ulati'e . 11. 1. !0. *. 0. . 1. *. 1.
Class
A
B
C
Finally usin g t+e A/ analysis $et+od t+e ite$s are classified as s+o(n belo(
A Class B Class CClass Fig. !.C
H! 10* 1
1. 1. 1!.
1. !. .
15
A)'a%tages of ABC a%al(sis
T+e invest$ent needed is $ini$i&ed.
T+e $aintenance cost is $ini$i&ed.
anage$ent ti$e is saved.
7or8 connected (it+ t+e purc+ases is syste$ati&ed.
16
*.!.. Effe&ti'e a%) user frie%)l( graJi&al user i%terfa&e
T+e soft(are provi des t+e user (it+ an effective and easy to use grap+ical user interface.
It also +as t+e feature of generating co$parative sales reports in t+e for$ of pie>c+arts< bar grap+s etc. for facilitation of t+e sales analysis.
17
*.*. DESIGN AND DE"ELOP$ENT $ET5ODOLOG# 7e +ave used icrosoft 4isual asic.et for developing our front>end i.e. our ;rap+ical :ser Interface B;:IC (+ile our bac8end consist of icrosoft *L *erver.
T+e 4isual asic.et is used for progra$$ing t+e :ser Interface G coding.
/rystal #eports for analysis report generation.
*L *erver is used for database $anage$ent.
T+e soft(are +as client>server arc+itecture. In (+ic+ *L *erver is running on t+e server and t+e client +as For$s for $a8ing t+e ill for t+e products purc+ased by t+e consu$er.
T+e data Bproduct info.C collected fro$ client is transferred to *L *erver database. T+is data is processed on server and proper output Bbilling infor$ationC is given to t+e respective client. very effort is $ade to $a8e t+e soft(are a :ser>friendly Application.
18
*.*.1. "ISUAL BASIC.NET
4J( "isual Basi&.NetK
"isual Basi& .NET< t+e ne%t generation of 4isual asic< is designed to be t+e easiest and $ost productive tool for creating .T applications< including 7indo(s applications< 7eb *ervices< and 7eb applications.
All t+e :ser Interfaces of our pro,ect are developed using 4isual asic .T. 4isual asic .T uses fe(er G less co$ple% constructs Bli8e pointersC. 4isual asic .T e$ploys 7indo(s environ$ent for t+e :ser Interface. 4isual asic .T uses co$$on dialog bo%es so t+at users can access t+e typical features t+ey e%pect in a 7indo(s application. 4isual asic .T progra$s are easier to $aintain .If any part of t+e soft(are is to be altered in t+e near future< t+en it can be done easily due to t+e use of 4isual asic .T.
4aried atabase Tec+nology can be incorporated into 4isual asic .T progra$s. It possible to provide e%ternal ActiveH controls.
eveloping ;:IB;rap+ical :ser InterfaceC in 4isual asic .T is very easy because it $a8es $any aspects of progra$$ing as si$ple as dragging grap+ic ob,ectsBli8e buttons< te%t bo%< etcC onto screen using a $ouse.
19
Features of "isual Basi& .NET
Full support for Ob,ect Oriented -rogra$$ing.
*tructured rror +andling capabilities.
Access to .T Fra$e(or8.
-o(erful unified Integrated evelop$ent nviron$ent BIC.
In+erent support for HL G 7eb *ervices.
etter (indo(s applications (it+ 7indo(s For$s.
e( /onsole capabilities of 4.T.
I$$ense po(er of tools G controls Bincluding *erver /ontrolsC.
Interoperability (it+ ot+er .T co$plied languages.
etter database progra$$ing approac+ (it+ AO.T.
*i$plified eploy$ent of 7indo(s applications.
n+anced security for t+e 7indo(s Applications
I$proved versioning support.
BT+ese are so$e of t+e $a,or features of 4isual asic.T t+ere are additional features also.C
20
*.*.!. Cr(stal Reorts
/rystal #eports for 4isual *tudio .T provides a co$pre+ensive reporting solution for .T developers t+at is t+oroug+ly integrated (it+ bot+ t+e 4isual *tudio .T I and t+e .T Fra$e(or8. It integrates sea$lessly (it+ t+e 4isual *tudio .T *erver %plorer< toolbo%< and design environ$ent. It +as a ric+ progra$$ing $odel and fle%ible options for custo$i&ing and deploying reports.
/rystal reports can be used effectively for tas8s suc+ as generating Acrobat B-FC docu$ents fro$ your reports< building reports on para$eteri&ed *L *erver stored procedures< and passing reports using t+e current users database security credentials.
/rystal reports can be used effectively to generate accurate bar grap+s< te%t reports< pie c+arts and $any ot+er types of grap+ical reports suc+ as area grap+s and 3>di$ensional grap+s.
21
*.*.*. SL SER"ER !
4J( SL SER"ER !K
icrosoft *L *erve r 2))) is a co$plete database and analysis solution for rapidly delivering t+e ne%t generation of scalable 7indo(s and 7eb applications. *L *erver 2))) is a 8ey co$ponent in supporting e>co$$erce< line>of>business< and data (are+ousing applications< (+ile offering t+e scalability necessary to support gro(ing< dyna$ic environ$ents.
T+e *L *erver $anages t+e entire database part of our pro,ect. 7e are using *L *erver in our pro,ect instead of Oracle because it is c+eaper t+an Oracle and gives all t+e features re0uired for our pro,ect. *L *erver 2))) includes ric+ support for %tensible ar8up Language BHLC and ot+er Internet language for$ats perfor$ance and availability features to ensure upti$e and advanced $anage$ent and tuning functionality to auto$ate routine tas8s and lo(er t+e total cost of o(ners+ip.
*L *erver can +andle $any re0uest at a ti$e< +ence $any clients can uery t+e *L *erver si$ultaneously.
22
Features of SL Ser'er !
:ser>defined functions and *tored procedures.
Inde%ed vie(s.
istributed partitioned vie(s.
e( datatypes and :ser efined atatypes.
/ascading #eferential IntegrityB#IC constraints.
ultiple *L *erver instances.
HL support.
Log s+ipping.
*L *erver 2))) includes several co$ponents t+at i$prove t+e capability to build data (are+ouses t+at effectively support decision support processing needs.
*upport for .T platfor$.
Online bac8up.
I*TA OF and AFT# triggers.
23
0. PLAN OF 4OR7: T+e soft(are is divided into t+ree parts@ •
atabase
•
Ad$inistrator9s :ser Interface
•
/lient *ide :ser Interface
24
0.1. DATABASE SC5E$A:
Fig. *: Dataase S&Je-a
Above figure gives t+e sc+e$atic representation of t+e pro,ect database. It s+o(s various data tables (+ic+ represent various entities and t+eir relations+ips. T+e tables along (it+ t+eir attributes are e%plained as follo(s@
1.
Pro)u&t: It stores t+e general infor$ation about eac+ product in t+e inventory. ac+ entry is uni0uely ident ified by t+e pri$ar y 8ey i). Product names and brand na$es are stored. Also< for better retrieval
and for facilitation of analysis process t+e products are classified at several stages into main group < sub group and type. T+is table also stores valua ble attributes li8e reorder level, reorder quantity < stoc8 related attributes< maximum reorder period and
minimum reorder
period etc. (+ic+ are essential for e%ercising inventory control. -roduct
25
table also records infor$ation about t+e nature of product suc+ as peris+able< seasonal etc.
2.
"e%)or: It is used to store t+e general infor$ation about t+e various vendors t+at supply products to t+e inventory. ac+ entry is uni0uely identified by t+e pri$ary 8ey 'i). It includes attributes li8e 4endor na$e< contact person etc. along (it+ a co$posite attribute address consisting of several si$ple attributes t+at can be used as criteria to searc+ a vendor fro$ t+e table.
3.
Sul(: T+is table represents t+e relations+ip bet(een t+e tables Product and Vendor. ac+ tuple is uni0uely identified by t+e union of foreign 8eys i) and 'i). It stores i$portant attributes na$ely< cost price< order 0uantity< order ti$e and 0uality rating.
4.
Sol): It is t+e data table (+ic+ records daily sales for every product and serves as a basis for sales analysis. ac+ entry represents t+e nu$ber of units of a particular product sold on a particular date. Its pri$ary 8ey consists of i) and a date attribute na$ed )ateto)a(.
5.
Custo-er: T+is table is used to record custo$er details. -ri$ary 8ey is &usti).
6.
Bill: It is used to store t+e basic data about a bill entity. -ri$ary 8ey is illID.
7.
Bill Ite -s: It is t+e relations+ip table bet(een $ain tables ill and -roduct. -ri$ary 8ey is for$ed by union of illID and i). T+is table stores t+e nu$ber of units of a particular product sold (it+in a particular bill. It also stores t+e custid to identify t+e custo$er.
26
0.!. AD$INISTRATOR/S USER INTERFACE:
Fig. 0: A)-i%istrator/s 5o-e For-
7+en t+e ad$inistrator enters t+e valid userna$e and pass(ord in t+e login for$ +e (ill be directed to t+e for$ called ?7elco$e Ad$inistrator9. T+e layout of t+is for$ is as s+o(n in t+e figure and consists of a toolbar +aving dropdo(n buttons< eac+ +aving a $enu consisting of $enu ite$s directing to t+e respective for$s as s+o(n in t+e figure belo(. T+is for$ is a I /ontainer and e%ploits ultiple ocu$ent Interface property provided by 4.net.
27
Fig. : $e%u ite-s ro'i)e) ( tJe a)-i%istrator Jo-e for-
28
0.!.1. A%al(sis:
!.2.1.1. ABC A%al(sis:
Fig. : ABC A%al(sis for- sJoi%g ro)u&t &lassifi&atio% reort
T+e design of for$ +a&/ consists of a crystal report vie(er and t(o pus+ buttons.
T+e (or8ing $ainly consists of t(o parts. Firstly< (+en t+e ad$inistrator (ants to recalculate t+e classes for t+e products +e clic8s on ?/lassification9 button to get t+e ne( A/ classification calculated using t+e data fro$ t+e sales record database. T+is report is loaded in t+e crystal report vie(er as s+o(n in above figure. T+is report gives t+e product I< na$e and respective class of every product.
29
*econdly< t+e A/ analysis report docu$ent can be loaded in t+e report vie(er by clic8ing on ?A/ analysis report9 button. T+is +elps in studying t+e sales value distribution of A< and / classes< (+ic+ follo(s t+e -areto rule.
Fig. : ABC A%al(sis for- sJoi%g a%al(sis reort
Area grap+ is used to display t+e sales value distribution effectively. T+is is s+o(n in above figure (+ere t+e grap+ s+o(s t+e sales value distribution by $eans of t+e area s+o(n by blue color.
30
0.!.1.!. Pro)u&t Co-ariso%:
Fig. : Pro)u&t Co-ariso% for- )esig% a%) or;i%g
T+e for$ ?-roduct Co-ariso%/ allo(s t+e user to select products categorically to co$pare t+e sales (it+in a specified period of ti$e. A product category suc+ as a main group< a sub group or a type is selected using t+e 3 co$bo>bo%es (+ic+ provide t+e user (it+ appropriate
values
fro$ t+e database for selection.
*i$ilar co$bo>bo%es are used to select t+e span of co$parison by getting t+e start and end date fro$ t+e user.
7+en t+e user $a8es t+e necessary selections and clic8s on ?/o$pare9 button< t+e application s+o(s t+e +Co-ariso% Reort/ for$ as s+o(n in t+e figure belo(.
31
T+e co$parison report for$ basically includes a /rystal #eport 4ie(er co$ponent and a flat toolbar to select t+e type of report docu$ent.
/rystal #eport 4ie(er allo(s t+e user to vie( t+e report docu$ent t+at is loaded. It also provides t+e facilities suc+ as searc+< e%port< &oo$ etc. 7+en t+e for$ is loaded t+e crystal report vie(er is loaded (it+ t+e te%tual report as s+o(n in t+e figure belo(.
Fig. H: Desig% of Co-ariso% Reort for-
32
:sing t+e buttons provided on t+e toolbar t+e user can select t+e type of report +e (ants to vie(. It $ay be a te%t report< a bar grap+ representation< a pie c+art vie( or a detailed 3 vie( displaying t+e 0uantity sold of a particular product on a particular day. Follo(ing figures s+o( t+e various types of t+e reports available.
T+ese reports are generated using t+e /rystal reports (+ic+ are provided (it+ t+e 4isual *tudio.T (+ic+ facilitates generation of reports using t+e database or t+e AO.net datasets used as a pro,ect data.
Fig. 1: Bar GraJ Rerese%tatio% of Co-ariso% Reort
33
Fig. 11: Pie CJart Rerese%tatio% of Co-ariso% Reort
Fig. 1!: Detaile) Cui& "ie Rerese%tatio% of Co-ariso% Reort
34
T+ese reports can be stored by e%porting t+e$ into a non $odifiable file for$ats suc+ as a ?pdf9 file.
0.!.1.*. Ti-e Li%e A%al(sis: T+is feature is provided to study t+e trends in t+e sales of a particular product over a period of ti$e. To start (it+< t+e user is s+o(n t+e for$ in t+e figure belo(.
Fig. 1*: Ti-e9li%e Sales Stu)( for- )esig% T+e for$ +as ! co$bo>bo%es for facilitating t+e user to select t+e product for (+ic+ +e (ants to analy&e t+e sales. *econdly< t+e user is also as8ed to select t+e ti$e period to be considered. A group of radio buttons is used to get a c+oice a$ong daily< $ont+ly and yearly sales co$parison. 7+en ?OJ9 button is clic8ed t+e 0ueries are fired at t+e sales database and t+e reports are generated using t+eir results.
T+e reports are displayed in t+e ne%t for$ na$ed ?Ti$e line report9. It +as a /rystal #eport 4ie(er in (+ic+ t+e report docu$ent is loaded. T+e follo(ing
35
figures s+o( t+e generated reports in t+e for$ of a daily sales line grap+ and a $ont+ly report.
Fig. 10: Ti-e9li%e reort itJ )ail( &o-ariso% li%e graJ
36
Fig. 1: Ti-e9li%e reort itJ sales &o-ariso% o'er -o%tJs
37
0.!.!. CJe&; Alerts:
Fig. 1: Alerts for Class +A/ a%) Class +B/ ro)u&ts
Ad$inistrator can c+ec8 for t+e alerts regarding /lass ?A9 and /lass ?9 products (+ose current stoc8 +as gone belo( t+eir currently assigned reorder level. T+ese alerts are fired by a trigger at t+e bac8>end (+ic+ continuously $onitors t+e current stoc8 of all t+e products. Alerts for /lass ?/9 products are not given since t+ese products can be dealt (it+ auto$atically by t+e soft(are and do not need intervention of t+e ad$inistrator.
Ad$inistrator can $odify reorder strategy for suc+ products< if desired. 7+en ad$inistrator selects a product fro$ t+e alert grid< +es+e is redirected to t+e supply infor$ation for$ (+ere +es+e can $odify t+e reorder strategy of t+at particular product (it+ respect to various vendors.
38
0.!.*. Clie%t Registratio%: 0.!.*.1. Create Ne User:
Fig. 1: Clie%t Registratio% ForIn client registration for$< t+ere are 3 te%tbo%es for entering userna$e< pass(ord and confir$ing t+e typed pass(ord. After validating t+e entered te%t< a $essage bo% is displayed to confir$ t+e registration activity.
Once< ad$inistrator confir$s it< a $essage bo% is displayed to indicate t+at ne( user +as been registered successfully. o(< t+e sales person can logon at t+e client side using t+e ne( userna$e and pass(ord and access t+e billing $odule.
Fig. 1: $essage Bo,es i% Clie%t Registratio% For-
39
0.!.*.!. E)it User Details:
Fig. 1H: For- for e)iti%g &lie%t )etails
Ad$inistrator +as aut+ority to edit client login details. Ad$inistrator can per$anently delete a particular client user account< so t+at< +encefort+< a sales person cannot logon at t+e client side using t+at userna$e and corresponding pass(ord.
Ad$inistrator can also c+ange pass(ord for a particular client user account< (it+out deleting t+at account. T+is $ay be t+e case (+en t+e sales person re0uests ad$inistrator to c+ange +is pass(ord if +es+e +as lost or forgotten +is+er current pass(ord.
Fig. !: $essage Bo,es sJo% Jile e)iti%g &lie%t )etails
40
0.!.0. Pro)u&t I%for-atio%:
0.!.0.1 A)) a Ne Pro)u&t:
Fig. !1: Ne Pro)u&t I%for-atio% For-
T+e e( -roduct Infor$ation For$ contains $any te%tbo%es (+ic+ are used to enter t+e infor$ation of t+e product in t+e database. T+e first te%tbo% is of -roduct>I (+ic+ is uni0ue for every product. A te%tbo% for arcode u$ber is also 8ept (+ic+ can be used if t+ere is a arcode reader. T+e product is classified under ain group< *ub>group< type< and brand na$e. T+ere are fields for /urrent *toc8< ini$u$ *toc8< a%i$u$ *toc8< #eorder level< and *elling -rice. Also t+ere are c+ec8bo%es to indicate (+et+er auto$atic re> order is possible and (+et+er t+e product is peris+able orand seasonal.
41
0.!.0.!. Pro)u&t Sear&J:
Fig. !!: Pro)u&t Sear&J For-
T+e -roduct can be searc+ed in $any different (ays. T+e -roduct can be searc+ed using its -roduct I< ain ;roup< *ub ;roup< Type or -roduct a$e in a +ierarc+ical $anner. T+e user +as to press ?OJ9 button to see t+e results of t+e *earc+. %a$ple of a *earc+ @ 7+en t+e user selects t+e ?;adgets G evices9 fro$ t+e ain ;roup t+en all t+e *ub ;roups under t+at ain ;roup are s+o(n in t+e list>bo% of t+e *ub ;roup. If (e select t+e *ub ;roup ?/a$era9 t+en (e (ill see t(o ele$ents vi&. igital< -las$a in t+e ?Type9 list>bo%. If (e select Type of t+e /a$era as ?igital9 t+en (e (ill see all t+e /a$eras (+ic+ are of type igital Bone of t+e$ is /annon A53) as s+o(n aboveC.o( t+e user can searc+ by $ain ;roup or by *ub ;roup or Type or -roduct a$e by selecting t+e ad,acent radio>button.
42
Fig. !*: Pro)u&t Sear&J Result For-
T+e -roduct *earc+ #esult For$ displays t+e infor$ation about t+e productBsC (+ic+ are searc+ed fro$ t+e previous for$. T+e entire searc+ result is s+o(n in a ata ;rid (+ic+ contains -roduct I< -roduct a$e< etc. T+ere are t(o buttons ?:pdate9 and ?elete9 (+ic+ are used to update and delete t+e infor$ation of t+e -roduct fro$ t+e database. T+e te%tbo%es present ad,acent to t+e update and delete buttons s+o( t+e -roduct I of t+e product to be updated or deleted respectively.
43
0.!.0.*. Pro)u&t U)ate:
Fig. !0: Alert Jile u)ati%g tJe Pro)u&t
7+en t+e user +as updated a data field of a product and t+en +e presses t+e ?:pdate9 button to save t+e c+anges. An alert $essage is s+o(n to t+e user to confir$ t+e update. If t+e user does not (ant to save t+e c+anges t+en +e can select t+e ?o9 button or else press ?Kes9.
44
Fig. !: $essage o, i%)i&ati%g tJat tJe U)ate as su&&essful
After pressing t+e ?Kes9 button< t+e soft(are $a8es t+e c+anges for t+e respective -roduct in t+e database. After t+at a $essage bo% is s+o(n (+ic+ says t+at t+e :pdate (as successful.
45
0.!.0.0. Pro)u&t Delete:
Fig. !: Alert Jile Deleti%g tJe Pro)u&t
7+en t+e ad$inistrator (ants to delete a particular product9s infor$ation fro$ t+e database< +es+e can delete t+at product by selecting t+at particular product and pressing t+e ?elete9 button< and t+en an alert $essage is s+o(n to +i$+er. If t+e ad$inistrator doesn9t (ant to delete t+e product< t+en +e can select t+e ?o9 button or else press ?Kes9 and t+en t+e selected product (ill be deleted. After pressing t+e ?Kes9 button t+e soft(are deletes t+e respective product fro$ t+e database. After t+at a $essage bo% is s+o(n (+ic+ says t+at t+e product (as successfully deleted.
46
0.!.. Reor)er Strateg(:
0.!..1. A)) Sul( I%for-atio%:
Fig. !: Ne Sul( I%for-atio% For-
T+e *upply Infor$ation For$ contains $any te%tbo%es (+ic+ are used to enter t+e infor$ation in t+e database about (+ic+ product is supplied by (+ic+ vendor. T+ere are t(o co$bo>bo%es (+ic+ allo( t+e ad$inistrator to select vendor na$e and product na$e fro$ t+e available list. T+e vendor I and product I of t+at vendor and product respectively are auto$atically displayed in t+e te%tbo%es. T+en< t+e ad$inistrator can fill in t+e appropriate supply infor$ation< na$ely< cost price< order 0uantity and ti$e< and t+e 0uality rating of t+e product supplied by t+at vendor.
47
0.!..!. Sear&J Sul( I%for-atio%:
Fig. !: Sul( I%for-atio% Sear&J For-
T+e e%isting supply infor$ation can be searc+ed in t(o different (ays. T+e supply infor$ation can be searc+ed for a particular vendor eit+er by entering its vendor I or by selecting t+e vendor na$e fro$ t+e co$bo>bo% as s+o(n in figure above. T+e user +as to press ?OJ9 button to see t+e results of t+e *earc+.
48
Fig. !H: Sul( I%for-atio% Sear&J Result For-
T+e supply infor$ation searc+ result for$ displays t+e supply infor$ation about t+e productBsC (+ic+ are supplied by t+e searc+ed vendor. T+e entire searc+ result is s+o(n in a ata ;rid (+ic+ contains 4endor I< 4endor a$e< -roduct I< -roduct a$e< Order uantity< Ti$e< etc. T+ere are t(o buttons ?:pdate9 and ?elete9 (+ic+ are used to update and delete t+e supply infor$ation of a particular product supplie d by t+e searc+ed vendor fro$ t+e database. T+e te%tbo%es present ad,acent to t+e update and delete buttons s+o( t+e 4endor I of t+e searc+ed vendor to be updated or deleted respectively.
49
0.!.. "e%)or I%for-atio%:
0.!..1. A)) a Ne "e%)or:
Fig. *: Ne "e%)or I%for-atio% For-
T+e 4endor Infor$ation For$ contains $any te%tbo%es (+ic+ are used to enter t+e infor$ation of t+e vendor in t+e database. T+e first te%tbo% is of 4endor>I (+ic+ is uni0ue for every vendor. T+ere are fields for 4endor /o$pany9s na$e< /ontact person9s na$e< address< telep+one nu$bers< FAH nu$ber and e>$ail I of t+e vendor9s co$pany. 7+en t+e ad$inistrator clic8s on t+e ?Insert9 button and confir$s it< t+e ne( vendor9s infor$ation is stored in t+e database.
50
0.!..!. "e%)or Sear&J:
Fig. *1: "e%)or Sear&J For-
T+e 4endor infor$ation can be searc+ed in $any different (ays. T+e 4endor can be searc+ed using its 4endor I< 4endor a$e BAlp+abeticallyC< /ountry and /ity and a$e in a +ierarc+ical $anner. T+e user +as to press ?OJ9 button to see t+e results of t+e *earc+. %a$ple of a *earc+@ 7+en t+e user selects ?India9 fro$ t+e /ountry< t+en all t+e cities under t+at /ountry are s+o(n in t+e list>bo% of t+e /ity. If (e select t+e /ity ?u$bai9 t+en (e (ill see all vendors fro$ u$bai region in t+e ?a$e9 list>bo%. o( t+e user can searc+ by /ountry or by /ity or 4endor a$e by selecting t+e ad,acent radio>button.
51
Fig. *!: "e%)or Sear&J Result For-
T+e 4endor *earc+ #esult For$ displays t+e infor$ation about t+e vendorBsC (+ic+ are searc+ed fro$ t+e previous for$. T+e entire searc+ result is s+o(n in a ata ;rid (+ic+ contains 4endor I< 4endor a$e< etc. T+ere are t(o buttons ?:pdate9 and ?elete9 (+ic+ are used to update and delete t+e infor$ation of t+e 4endor fro$ t+e database. T+e te%tbo%es present ad,acent to t+e update and delete buttons s+o( t+e 4endor I of t+e vendor to be updated or deleted respectively.
52
0.!..*. "e%)or U)ate:
Fig. **: Alert Jile u)ati%g tJe "e%)or 7+en t+e user +as updated a data field of a vendor and t+en +e presses t+e ?:pdate9 button to save t+e c+anges< an alert $essage is s+o(n to t+e user to confir$ t+e update. If t+e user does not (ant to save t+e c+anges t+en +e can select t+e ?o9 button or else press ?Kes9.
After pressing t+e ?Kes9 button< t+e soft(are $a8es t+e c+anges for t+e respective 4endor in t+e database. After t+at a $essage bo% is s+o(n (+ic+ says t+at t+e :pdate (as successful.
53
4.2.6.4.
"e%)or Delete:
Fig. *0: Alert Jile Deleti%g tJe "e%)or
7+en t+e ad$inistrator (ants to delete a particular vendor9s infor$ation fro$ t+e database< +es+e can delete t+at vendor by selecting t+at particular vendor and pressing t+e ?elete9 button< and t+en an alert $essage is s+o(n to +i$+er. If t+e ad$inistrator doesn9t (ant to delete t+e vendor< t+en +e can select t+e ?o9 button or else press ?Kes9 and t+en t+e selected vendor (ill be deleted. After pressing t+e ?Kes9 button t+e soft(are deletes t+e respective vendor fro$ t+e database. After t+at a $essage bo% is s+o(n (+ic+ says t+at t+e vendor (as successfully deleted.
54
0.*. CLIENT SIDE USER INTERFACE: 0.*.1. BILLING $ODULE: 0.*.1.1. Logi% S&ree%:
Fig. *: Logi% For- of tJe Billi%g $o)ule T+e above for$ contains t(o te%t bo%es for entering :serna$e and -ass(ord. T+e sales person +as to enter +is appropriate :serna$e and -ass(ord. T+e sales person (ill not be logged>in unless +e specifies correct :serna$e and pass(ord.
After t+e sales person enters +is :serna$e and -ass(ord +e +as to press t+e ?LO;I9 utton in order to login. =is+er :serna$e and -ass(ord are co$pared (it+ t+e :serna$e and -ass(ord present in t+e ?userlogin9 Table of t+e database. If bot+ t+e fields $atc+ t+en t+e user is aut+enticated and t+e illing for$ opens.
55
0.*.1.!. Billi%g For-:
Fig. *: Billi%g ForT+e illing For$ contains a te%tbo% Btop>leftC t+at s+o(s t+e userna$e of t+e user (+o is logged>in. T+e te%tbo% besides t+e Label field ?Total9 s+o(s t+e total price of t+e goods purc+ased by t+e custo$er. T+ere is a te%tbo% ne%t to t+e button ?A TO /A#T9. In t+at te%tbo% (e +ave to enter t+e -roduct I B-IC of t+e product purc+ased by t+e consu$er. 7+en t+e sales person enters t+e -I in t+at te%tbo% and presses t+e ?A TO /A#T9 button t+at product is added in t+e bill. T+e bill s+o(s t+e details of follo(ing fields@ -roduct I< -roduct a$e< -rice per :nit< u$ber of :nits and Total -rice for t+e product purc+ased. T+e ?#O4 F#O /A#T9 button is used to re$ove a particular product fro$ t+e bill. 7+en t+e bill is $ade t+e sales person s+ould press t+e ?-#IT#9 icon to print t+e bill. T+e sales person can c+ange +is pass(ord by clic8ing t+e ?/=A; -A**7O#9 button. T+e sales person can logout by pressing t+e ?LO;O:T9 button.
56
0.*.1.*. Pri%te) Bill
Fig. *: Pri%te) Bill T+e bill is printed (+en t+e sales person clic8s t+e ?-#IT#9 icon. T+e printed bill contains t+e ate and ti$e of purc+ase< a$e of t+e super$ar8et< -roduct I< -roduct a$e< #ate per :nit< uantity Bu$ber of unitsC and Total Bfor eac+ productC. It also s+o(s Total A$ount to be paid by t+e custo$er.
57
0.*.1.0. CJa%ge of Passor):
Fig. *: CJa%ge of Passor) For-
T+e sales person can c+ange +is -ass(ord by clic8ing t+e ?/=A; -A**7O#9 button on t+e billing for$. After clic8ing t+at button t+e above for$ pops up and t+ere are t+ree te%tbo% fields vi&. current pass(ord< ne( pass(ord< re>type ne( pass(ord. T+e sales person +as to fill t+ese te%tbo%es in order to c+ange +is pass(ord and t+en clic8 t+e ?/=A; -A**7O#9 button on t+is for$.
58
. TESTING AND RESULTS: Test ro&e)ure: For 'ali) a)-i%istrator logi% Test /ase
Ad$in login (it+ valid user na$e and pass(ord
Input
4alid ad$in user na$e and pass(ord B-ass(ord $ust be si% c+aracters or $oreC
%pected Output
*yste$ redirects to ad$inistrator9s +o$e page
Obtained output
As per e%pected
#e$ar8s
oeviation
Test ro&e)ure: For i%'ali) a)-i%istrator logi% Test /ase
Ad$in login (it+ invalid user na$e and pass(ord
Input
Invalid ad$in user na$e and pass(ord
%pected Output
*yste$ generates an error $essage
Obtained output
As per e%pected
#e$ar8s
oeviation
Test ro&e)ure: For ABC a%al(sis Test /ase
A/ analysis and classification
Input
ata sa$ple fro$ a t+eoretical e%a$ple
%pected Output
*yste$ perfor$s classification in t+e sa$e (ay as t+at of t+e t+eoretical $et+od
Obtained output
As per e%pected
#e$ar8s
oeviation
59
Test ro&e)ure: For Pro)u&t &o-ariso% otio% sele&tio% Test /ase
:ser leaves a $andatory selection blan8
Input
utton is clic8ed (it+out selecting an option Bcarried out for all controls li8e radio bo%es and drop do(n list
%pected Output
bo%esC *yste$ pops up a $essage indicating t+at a necessary selection is not $ade
Obtained output
As per e%pected
#e$ar8s
oeviation
Test ro&e)ure: For Ti-e sa% sele&tio% i% ti- eli%e &o-ariso% reort Test /ase
:ser leaves a $andatory field blan8.
Input
utton is clic8ed (it+out selecting an option Bcarried out for all controls li8e radio bo%es and drop do(n list bo%esC
%pected Output
*yste$ pops up a $essage indicating t+at a necessary selection is not $ade
Obtained output
As per e%pected
#e$ar8s
oeviation
Test ro&e)ure: For &Je&;i%g a&&ura&( of &o-ariso% ti-eli%e reorts Test /ase
/o$parison reports generate inaccurate data
Input
*a$ple database is attac+ed to t+e database
%pected Output
#eport s+ould be g enerated s+o(ing calculated results fro$ t+e sa$ple data
Obtained output
As per e%pected
#e$ar8s
oeviation
Test ro&e)ure: For &Je&;i%g alerts for Class +A/ a%) +B/ ro)u&ts Test /ase
lan8 product I field
Input
/lic8ing ? odify r eorder s trategy9 button ( +en n o product I is selected
60
%pected Output
*yste$ pops up a $essage indicating t+at t+e product I field is blan8
Obtained output
As per e%pected
#e$ar8s
oeviation
Test ro&e)ure: For 'ali) &lie%t registratio% Test /ase
/lient registration (it+ valid user na$e and pass(ord
Input
4alid user na$e and pass(ord B-ass(ord $ust be si% c+aracters or $oreC
%pected Output
*yste$ registers t+e ne( client
Obtained output
As per e%pected
#e$ar8s
oeviation
Test ro&e)ure: For i%'ali) &lie%t registratio% Test /ase
/lient registration (it+ invalid user na$e and pass(ord
Input
Invalid userna$eand pass(ord
%pected Output
*yste$ generates an error $essage
Obtained output
As per e%pected
#e$ar8s
oeviation
61
Test ro&e)ure: For sear&Ji%g ro)u&t Test /ase
Invalid searc+ option or blan8 searc+ field
Input
1. *earc+ by product I (+en product I field is blan8 2. *earc+ by $ain group< subgroup< type or product
%pected Output
na$e (+en appropriate option is not selected *yste$ generates an appropriate error $essage
Obtained output
As per e%pected
#e$ar8s
oeviation
Test ro&e)ure: For u)ati%g or )eleti%g ro)u&t Test /ase
o ro( available or blan8 product I
Input
/lic8ing ? :pdate9 o r ? elete9 b utton ( +en n o r o( i s
%pected Output
available or product I field is blan8 *yste$ generates an appropriate error $essage
Obtained output
As per e%pected
#e$ar8s
oeviation
Test ro&e)ure: For sear&Ji%g sul( i%for-atio% Test /ase
lan8 searc+ field
Input
*earc+ by vendor I (+en vendor I field is blan8
%pected Output
*yste$ generates an appropriate error $essage
Obtained output
As per e%pected
#e$ar8s
oeviation
62
Test ro&e)ure: For u)ati%g or )eleti%g sul( i%for-atio% Test /ase
o ro( available or blan8 vendor I
Input
/lic8ing ? :pdate9 o r ? elete9 b utton ( +en n o r o( i s available or vendor I field is blan8
%pected Output Obtained output
*yste$ generates an appropriate error $essage As per e%pected
#e$ar8s
oeviation
Test ro&e)ure: For sear&Ji%g 'e%)or Test /ase
Invalid searc+ option or blan8 searc+ field
Input
1. *earc+ by vendor I (+en vendor I field is blan8 2. *earc+ by country< city or vendor na$e (+en
%pected Output
appropriate option is not selected *yste$ generates an appropriate error $essage
Obtained output
As per e%pected
#e$ar8s
oeviation
Test ro&e)ure: For u)ati%g or )eleti%g 'e%)or Test /ase
o ro( available or blan8 vendor I
Input
/lic8ing ? :pdate9 o r ? elete9 b utton ( +en n o r o( i s available or vendor I field is blan8
%pected Output
*yste$ generates an appropriate error $essage
Obtained output
As per e%pected
#e$ar8s
oeviation
63
Test ro&e)ure: For 'ali) &lie%t logi% Test /ase
/lient login (it+ valid user na$e and pass(ord
Input
4alid client user na$e and pass(ord B-ass(ord $ust be si% c+aracters or $oreC
%pected Output
*yste$ redirects to client9s +o$e page Bi.e. illing pageC
Obtained output
As per e%pected
#e$ar8s
oeviation
Test ro&e)ure: For i%'ali) &lie%t logi% Test /ase
/lient login (it+ invalid user na$e and pass(ord
Input
Invalid client user na$e and pass(ord
%pected Output
*yste$ generates an appropriate error $essage
Obtained output
As per e%pected
#e$ar8s
oeviation
Test ro&e)ure: For ill ge%eratio% ite- re-o'al Test /ase
#e$oving ite$ fro$ cart (+ic+ is not present
Input
7+ile i te$ s elected i s n ot p resent i n t +e c art< c lient clic8s on ?#e$ove fro$ cart9 button
%pected Output
*yste$ pops up a $e ssage indicating t+at t +e it e$ is not present in t+e cart
Obtained output
As per e%pected
#e$ar8s
oeviation
64
Test ro&e)ure: For ill ge%eratio% ite- a))itio% Test /ase
Adding an ite$ to t+e cart (+ile its already present
Input
/lient selects suc+ an ite$s (+ic+ is already present and adds it
%pected Output
*yste$ s+ould increase its 0uantity (i t+out $a8ing a separate entry
Obtained output
As per e%pected
#e$ar8s
oeviation
65
. CONCLUSION: T+us< (e +ave successfully co$pleted our pro,ect on ?Inventory /ontrol *yste$ of *uper$ar8et9. 7e +ave included $any features t+at are necessary for an Inventory /ontrol *yste$ of *uper$ar8et.
T+e features are as follo(s@ 1. etailed *ales Analysis •
A/ Analysis
•
-roduct /o$parison
•
Ti$e Line Analysis
2. /+ec8ing of Alerts 3.
-roduct Infor$ation anage$ent
!. #eorder *trategy 5. 4endor Infor$ation anage$ent 6. illing odule
7+ile $a8ing t+e soft(are< every effort +as been ta8en to $a8e a very easy to use ;rap+ical :ser Interface B;:IC. 7e +ave tried our best to includ e as $uc+ features as (e can in t+e available ti$e li$it.
*o$e additional advance features can also be i$ple$ented li8e •
:sing a barcode syste$
•
#ecording of custo$er infor$ation for t+e study of buying +abits
ut t+ese features are 8ept for future develop$ent.
66
. REFERENCES: T+e follo(ing oo8s (ere used as references for t+e -ro,ect and preparing t+is -ro,ect #eport@
1. /ost Accounting >oard of studies< T+e Institute of /+artered Accountants of India 2. anage$ent and -roduction -lanning > y ic+ael 4a&< 4inaya8 -arali8ar 3.
eginning 4.T 2))3 BT+ird ditionC > y T+earon 7illis< #ic+ard lair
4.
4isual asic .T 2))3 -rogra$$ing lac8 oo8 > y *teven =ol&ner
5. *L *erver 2))) ible > y -aul ielsen 6. *L *erver 2))) :nleas+ed > y -aul ertucci< #ay #an8ins
T+e follo(ing 7ebsites (ere used as references for t+e -ro,ect and preparing t+is -ro,ect #eport@
1. (((.startvbdotnet.co$ 2. (((.s0l>server>+elper.co$
67
