CHIT FUND MAINTENANCE
ABSTRACT
The project,” Chit Fund Maintenance system” is a VB application, that permits the user to register into the VB and receive the description regarding the chits and the auction sum associated to their chits. It also permits a newly recorded individual to unite with a new chit ased on their needs. The administrator plays a pivotal part in this project as he has the entire authority on the wesite and can alter the data, wherever it!s re"uired in the dataase. The #Chit Fund Maintenance system” project e$plains chit description, consumer description, chit amount description etc. The chit management will digiti%e the several operations e$ecuted in the chits and also o&&ers user to respond and view the description. It &acilitates the users to update or alter the description i& re"uired. ' chit is a reciprocally pro&itale plan where a association o& persons contriute to the chit and a memer o& that association is granted the pri%e sum and dividends are shared y the remaining memers o& the association. ' chit comprises o& (n! numer o& persons and they ought to pay an amount &or (n! numer o& months. The amount is evenly distriuted amidst those persons. The amount can e paid in cash or via an), within a wee) later to auction. ' memer can ta)e part in auction &rom the eginning only i& he has paid the amount in time.
Page 1
CHIT FUND MAINTENANCE
INDEX
•
•
•
•
•
•
•
•
•
•
Abstract---------------------------------------------------------1 Introduction----------------------------------------------------3 Overview--------------------------------------------------------4 ER Diagram-----------------------------------------------------21 Converting ER Diagram into Tables-----------------------22 ormali!ation--------------------------------------------------23 Code--------------------------------------------------------------14 Table "tructures----------------------------------------------"na#s$ots------------------------------------------------------Conclusion------------------------------------------------------
•
"co#e o% En$ancement---------------------------------------
SYNOPSIS Page 2
CHIT FUND MAINTENANCE
This application basically deals with the Chit fund companies which will have the tansactions li!e statin" chit "oups# $oinin" subscibes to those "oups# conductin" monthly# by monthly# wee!ly and daily auctions# accodin" to that auction bid amount which is bid by auction winne this bid amount should be divided to all the subscibes in that "oup% Then installments collections could collect fom subscibes evey month o dependin" on the type of auction% Evey month payments should be pay to the pi&ed subscibes accodin" to those chit "oups afte "ettin" pope "uaantees fom the auction winne% The title chit fund mana"ement softwae is as pe chit fund companies
but
functionality of it can be "eneali&ed fo multiple puposes li!e% '( Company )e"istation by Foeman with Diectos* +As pe companies act Company will e"iste with diectos% ,( -tatin" New .oups*+ Afte e"isteed the company as pe companies act# Foeman will stat new Chit .oups% /( )ecuitin" 0usiness 1omotes 2A"ents(* + As pe Company business development -tate"y Company will appoint a"ents to pomote new subscibes fo Chit "oups% 3( Ceatin" New Membes fo New .oups* +Afte "ettin" 1-4 Numbe fo chit "oup Company will ecuit -ubscibes in that .oup% 5( Collection of subsciptions# 1enalty and othes 2)eceipts(*+-ubsciptions will collect fom subscibes in diffeent modes li!e cash# che6ue# D%D# ad$ustments and "eneal eceipts% 7( 0usiness 1omotes 8ouches Dependin" on business* +Afte "ettin" defined instalment numbe fom subscibes% 7) Reports: -After entered data according to customer needs reports should be generate .
This volume pesents the manne in which the softwae was developed and howthe vaious poblems ae tac!led at the diffeent levels to convince the use% Page 3
CHIT FUND MAINTENANCE
9e hope that this pac!a"e would pove to be an e:cellent envionment fo chit fund companies%
INTRODUCTION Page 4
CHIT FUND MAINTENANCE
8isual 0asic is an inteestin" topic# which has diffeent types% It has all the methods have thei won featues with each havin" meits and demeits which help in data pocessin"% The topic includes thei achitectue epesentin" the elements involved in it and thei action is also specified% 8isual 0asic 7%; allows ceatin" ob$ect+oiented applications% 8isual 0asic 7%; pofoundly concentates on the Intenet development featues# Active < technolo"y# enhanced contols# enhanced featues of e:istin" contol# client=seve# new lan"ua"e featues development# data access# a few desi"n enhancement etc%# )elational databases ae lo"ical collection of inte+elated data in tabula fom elational databases have always been coe to any mana"ement system% Its elevance is pofound and hence the need to incopoate new functionalities# utilities becomes impotant% These ae cuently the pedominant choice in stoin" financial ecods manufactuin" and lo"istical infomation# pesonnel data and much moe% )elational databases ae used in hu"e mana"ement systems li!e 1ost 4ffice# 0an!in"# )ailway# Defense# and >o"istics% Databases petainin" to Educational Institutions and othe la"e collection of elated data% )elational databases have la"ely eplaced hieachical databases and netwo! databases because they ae easy to undestand and use even thou"h they ae much less efficient% They have been howeve challen"ed by 4b$ect Databases and databases%
OVERVIEW O !"E #RO$E%!
&'&!E( E&%RI#!IO** Page 5
CHIT FUND MAINTENANCE
The poposed system is fo ma!in" easie to mana"e chit holde details# a"ent details# policy details# claimant details and payment details% -o this will be developed fo mana"in" the insuance mana"ement system% The oveall system is contol thou"h the main menu% (O+,E&:
The main menu contains 7 pats% '% Chit desciption% ,% Chit amount desciption% /% Custome >o"in% 3% Administato >o"in% 5% About us% 7% Contact us%
(O+,E E&%RI#!IO*:AE*! ,OI*
The a"ent lo"in fom lin!s to+ '% 0asic a"ent infomation li!e contact details and addess which will be shown in custome insuance infomation window% ,% All the infomation elated to insuances which he has made to his clients% /% Commission eceived by him fo each insuance made by him espectively% 3% 4ption to ceate a new policy to any e:istin"=new client% 5% 4ption to edit the contact infomation of its client% 7% 4ption to delete a policy of any client in case of policy lapse%
%+&!O(ER ,OI*:Page 6
CHIT FUND MAINTENANCE
The fom contains the a"ent infomation li!e+ '% 1esonal infomation e6uied by insuance a"ency% ,% Ne:t pemium due of espective insuances by the client alon" with matuity date#a"ent info etc% A(I*I&!RA!OR ,OI*:-
Administato has i"hts to+ '% Ceate new a"ent ,% Edit a"ent?s infomation and its commission pecenta"e% /% Delete an a"ent?s database and all its policies espectively% AO+! +&:-
It contains infomation about the o"ani&ation?s histoy and its achievements%
%O*!A%! +&:-
It contains the contact details of the o"ani&ation?s vaious banches located in diffeent pats of a county% RE#OR!&: •
-ales epot
•
Claimant infomation epot
•
A"ent infomation epot
•
Client infomation epot
"ARWARE RE/+IRE(E*!&
The hadwae that is needed fo ou system is*
1ocesso2C1U(
*
1entium1ocesso Page 7
CHIT FUND MAINTENANCE
1imayMemoy2)AM( HadDis!Dive
*
73M0
*
Display-i&e
,;.0 *
'3??Monito
Te:t )esolution
*
ey0oad
*
@; Columns by ,5 )ows Total';3!eyswith', Functions !eys
Contol
*
Ameican-tandad
1inteAvailable
*
H1>aseBet7l
1owe)e6uiement
*
,,;,5;8olts
0.1 &O!WARE RE/+IRE(E*!&
The softwae that is needed fo ou system is* Micosoft 8isual 0asic 7%; •
Micosoft Access ,;;;
O$E%!IVE O !"E #RO$E%!
The main ob$ective while implementin" the po$ect Telephone 0illin" -ystem was to minimi&e the wo! and at the same time incease the speed of the wo! done% Page 8
CHIT FUND MAINTENANCE
This new system is built with the following objective:
'( ,(
Infom ation etiev al will become easy% Maintenance of dat abase as wel l as ove all po $ect will bec ome easy%
/(
-ecuity measue will be adopted# by maintainin" the lo"in of usename and the passwod%
3(
Data
edundancy
will
be
"eatly
educed
because
this
new
system is built usin" 8isual 0asic 7%; as font+end% It entails loo!in" into duplication of effots# bottlenec!s and inefficient e:istin" pocedues%
I*!RO+%!IO*
-ystem analysis is the pefomance mana"ement and documentation of activities elated to the fou life cycle phases of any softwae namely*
Page 9
CHIT FUND MAINTENANCE •
The -tudy 1hase
•
The Desi"n 1hase
•
The Development 1hase
•
The 4peatos 1hase
-ystem analysis is a vast field of study thou"h which system analyst puts his thou"hts and seaches fo the solution of poblem% He has to "et a clea idea of what he has in hand and what he has to poduce% He has to e:tact the essence of e:pectations% He has to satisfy the use in the vey possible way% -ystem analysis needs and should include the followin" steps of study*
-tudy of cuent methods# the basic inputs available and output desied%
The splittin" of a vaiable inputs into 2%dbf( files so as to educe edundancy and incease consistency%
.ive the idea of !ey field 2if any( %
Ideas e"adin" code "eneation%
-oftwae Analysis stats with a peliminay analysis and late switches on to a detailed one% Duin" the peliminay analysis the Analyst ta!es a 6uic! loo! at what is needed and whethe the cost benefits% Detailed analysis studies in depth all the coneed factos# which builds and sten"thens the softwae% A system study is a step+by+step pocess used to identify and then developed the softwae needed to contol the pocessin" of specific application% -ystem study is also !nown as -D>C 2-oftwae Development >ife Cycle(%
Steps of SDLC are: Page 10
CHIT FUND MAINTENANCE
'% 1oblem Definition ,% Feasibility -tudy /% -ystem Analysis 3% -ystem Desi"n 5% Implementation 7% 1ost Implementation % Maintenance
E2I&!I* &'&!E(
E:istin" system efes to the system that is bein" followed till now% The e:istin" system e6uies moe computational time# moe manual calculations# and the comple:ity involved in -election of featues is hi"h% The othe disadvanta"es ae lac! Page 11
CHIT FUND MAINTENANCE
of secuity of data# Deficiency of Data accuacy# Time consumin" etc% To avoid all these limitations and ma!e the wo!in" moe accuately the system needs to be computei&ed% Hee in the Chit fund Maintenance# a detailed study of e:istin" system is caied alon" with all the steps in system analysis%
3.1.0 ra4 bac5s of e6isting sstem.
Hee in the Chit Fund Maintenance# a detailed study of e:istin" system is caied alon" with all the steps in system analysis% An idea fo ceatin" a bette po$ect was caied and the ne:t steps wee followed%
>ac! of secuity of data%
Moe man powe%
Time consumin"%
Consumes la"e volume of pae wo!%
Needs manual calculations%
No diect ole fo the hi"he officials%
Dama"e of machines due to lac! of attention%
To avoid all these limitations and ma!e the wo!in" moe accuately the system needs to be computei&ed%
Page 12
CHIT FUND MAINTENANCE
3.8
#RO#O&E &'&!E(
The aim of poposed system is to develop a system of impoved facilities% The poposed system can ovecome all the limitations of the e:istin" system% The system povides pope secuity and educes the manual wo!% The e:istin" system has seveal disadvanta"es and many moe difficulties to wo! well% The poposed system ties to eliminate o educe these difficulties up to some e:tent% The poposed system will help the use to educe the wo!load and mental conflict% The poposed system helps the use to wo! use fiendly and he can easily do his $obs without time la""in" 3.8.0 Ad9antages of #roposed &ste m
The system is vey simple in desi"n and to implement% The system e6uies vey low system esouces and the system will wo! in almost all confi"uations% It has "ot followin" featues
Ensue data accuacy%
Minimi&e manual data enty%
Minimum time needed fo the vaious pocessin"
.eate efficiency
0ette -evice
Minimum time e6uied Page 13
CHIT FUND MAINTENANCE
This would help the copoation pepae and o"ani&e its schedules moe efficiently on the basis of taffic demand%
It would povide data on concessions "iven to vaious sections%
O#ERA!I* &'&!E( - WI*OW& ; Page 14
CHIT FUND MAINTENANCE
Assotment of appopiate 4peatin" system and 1o"ammin"
lan"ua"e
fo any po$ect is vey impotant% 0asically it depends upon the natue of po$ect and its system e6uiements% 9indows povides a Multitas!in" Envionment# enablin" use to un vaious applications at a time% 9indows offe many advanta"es to both the use and the po"amme besides .UIs such as point+and+clic! capabilities and multitas!in"%
1.3 RO*! E* - (I%RO&O! VI&+A, A&I% <.=
Micosoft 8isual 0asic development system is the most poductive tool fo ceatin" fast business solutions fo 9indows and the 9eb% A compehensive# apid application development envionment helps development envionment help developes 6uic!ly ceate and deploy client =seve applications# plus easily po"am fo the Intenet usin" familia 8isual 0asic po"ammin" tools and techni6ues%
The impotant e6uiements fo a apid# application+development client=seve tool include* •
Compehensive esouces necessay fo successful 9indows ,;;; development%
•
Hi"h+pefomance# scalable application and component ceation%
•
Inceased data application development poductivity contol%
•
.eate sevice application development suppot%
•
A obust e:tensibility model fo thid paty suppot availability of components and add in technolo"y% Page 15
CHIT FUND MAINTENANCE •
Entepise application development%
9ith the intoduction of 8isual 0asic 7%;# Micosoft builds upon its citically acclaimed )AD entepise development platfom with the featues that e:tended and enhance the cuently obust development envionment% These featues ae based on five desi"n themes# in tun deived fom these custome e6uiements%
Windows 2 Development with !isual "asic:
The Micosoft 8isual 0asic development system now povides the compehensive esouces necessay fo successful 9indows ,;;;development% Fom buildin" e+commece 9eb technolo"ies# such as netwo! and component load balancin"# to scalable data diven business applications# 8isual 0asic 7%; has what you need% •
9indows ,;;; Developes )eadiness it
•
8isual studio installe%
•
M-DN >ibay -ubsciption% Micosoft Data En"ine.
High Performance, Scalable Application and Component Creation
The "oal of any development tool is to facilitate the developes need fo 6uic! and efficient ceation and deployment of hi"h pefomance# scalable applications% 8isual 0asic 7%; wo!s to addess these needs thou"h the delivey of a 6uic!+e:ecutin"# native+code envionment% Tens of millions of 8isual 0asic based Page 16
CHIT FUND MAINTENANCE
applications in use today stand as a testament to the success of 8isual 0asic in this aea% 9ith 8isual 0asic 7%;# Micosoft made impovements in the followin" aeas* •
Delive native+code compiled pefomance
•
Acceleated Micosoft 9in /, A1I based foms%
•
1ovide scalable solutions%
•
Facilitate the development of thead+safe# pesist able components%
Data#Centric $pplication Development
Ninety+five pecent of developes usin" 8isual 0asic ceate solutions that access eithe local o emote database and the vast ma$oity of all copoate applications ae data+centic% In fact# a ecent tac!in" study evealed that 8isual 0asic is the most popula development tool used in Con$unction with Micosoft -G> -eve and 4acle -eves% Clealy# developes e6uie moe poductive ways to connect to and manipulate data with educed comple:ity and open to access to a wide vaiety of data souces% 9hile developin" 8isual 0asic 7%;# Micosoft addessed these impotant needs by focusin" on the followin" data+poductivity ob$ectives* •
1ovide faste and moe compehensive data access%
•
1ovide an inte"ated set of data base desi"n and po"ammin" tool%
•
-implify the ceation of data+centic application fo the mobile use%
•
1ovide suppot fo the latest data base mana"ement technolo"y usin" Active< Data 4b$ects 2AD4( and 4>ED0%
•
1ovide easie access to moe data types% Page 17
CHIT FUND MAINTENANCE •
-implify the ceation of eusable data consumes%
Server $pplication Development and Deployment
In ecent yeas# 1C+based entepise client =seve development has "ained widespead acceptance% At the cente of these installations is 9in /, o Intenet based seve applications% In esponse to this# Micosoft has enhanced 8isual 0asic with the e:istin" new seve application featues% Micosoft focused on the followin" ob$ectives to optimi&e 8isual 0asic 7%; fo seve application development% •
Enable the ceation of HTM> based 9eb applications%
•
Utili&e 9eb sites both inside and outside the copoate fiewall as a measue to educe deployment costs%
•
Debu" middle tie components unnin" unde Micosoft Tansaction -eve%
•
1ac!a"e and deploy middle+tie components with ease and peace of mind%
Client Development Support
At the heat of the success 8isual 0asic has en$oyed is the ability it "ives develope to 6uic!ly ceate obust# poweful# and pofessional client applications# components and use intefaces% 8isual basic 7%; povides the followin" impovements that enhance client application development* •
Active< Contol ceation that "ives developes the ultimate in
9in/, fle:ibility% •
Ceation of bowse+independent applications%
Page 18
CHIT FUND MAINTENANCE
%nterprise $pplication Development
As the use of infomation technolo"y chan"es to meet new business needs# the vey definition of entepise applications is evolvin"% 9hile entepise infastuctue and applications vay widely acoss o"ani&ations# common attibutes of entepise applications include*
•
0ein" component based fo fle:ibility and scalability%
•
)e6uiin" life cycle suppot# includin" desi"n# development# mana"ement and analysis%
•
)e6uiin" moe sophisticated database achitectues%
•
0ein" developed by teams%
•
0ein" distibuted in natue# inte"ated with despeate bac!end system%
Page 19
CHIT FUND MAINTENANCE
ac5 End: (icrosoft Access
Micosoft access delives poweful tools fo mana"in" and analy&in" data% 9ith suppot# developes can ceate hi"hly sophisticated Entepise + wide database solutions that inte"ate easily with the web% 4ne can find compehensive tools that ma!e buildin" databases moe intuitive Featues li!e Micosoft 1ivot table and the Micosoft 1ivot chat "eatly impove data analysis capabilities% Micosoft Access is one of the most vesatile applications% This vesatility is evidenced by the ich set of tools that even the Most e:peienced database use can ta!e advanta"e of# offein" the same level of simplicity fo fist time database use% Access e:tends this vesatility by "ivin" developes and moe e:peienced use?s new functionality# enablin" them to access and analy&e thei impotant data as well as build poweful new data base solution% At same time# access ma!es it easy fo be"innin" uses to discove and use moe of the e:istin" application%
Page 20
CHIT FUND MAINTENANCE
&tud of pro>ect through %lassical (odel
A system model is a systematic appoach towads softwae development% 0efoe any buildin" is built it is necessay to ma!e the dawin" of that buildin"# simila is the case with any softwae% Hee also befoe any codin" of the softwae be"ins# it is necessay to ma!e the model of the softwae%
A model basically specifies all the steps to be followed duin" the system development% This ma!es the tas! of the en"inee 6uite simple and helps him build softwae# which is less eo pone% Tas!s accomplished by system modelin" ae* •
Define the pocesses that seve the needs of the view unde consideation%
•
)epesent the behavio of the pocesses and the assumptions on which behavio is based%
•
E:plicitly define both e:o"enous and endo"enous input to the model%
•
)epesent all lin!a"es that will enable the en"inee to bette undestand the view%
The m!e" #$e! %$ $h&' (e"&)
Page 21
CHIT FUND MAINTENANCE
SYSTEM DEVELOPMENT LIFE CYCLE
A cucial phase in the -ystem Development >ife Cycle 2-D>C( Is the successful implementation of the new system desi"nJ Implementation includes all those activities that ta!e place to convet fom the old system to the new one% The new system may be completely new# eplacin" an e:istin" manual o automated system o it may be ma$o modification to an e:istin" system% In eithe case# pope implementation becomes necessay so that a eliable system based on the e6uiements of the o"ani&ation can be povided% -uccessful Implementation may not "uaantee impovement in the o"ani&ation usin" the new system# but impope installation will pevent it% It has been obseved that even the best system cannot show "ood esults if the analyst mana"in" the implementation does not attend to evey impotant detail% This is the aea whee the system analyst needs to wo! most caefully The poposed system is vey simple to implement% As specified pio# the e6uied Hadwae and -oftwae ae sufficient fo implementin" this softwae% The implementation pocess is 6uite simila to most softwae?s% -o the implementations of this softwae become easy%
Page 22
CHIT FUND MAINTENANCE
I*!RO+%!IO*
-ystem desi"n is the second step in the system life cycle# in which oveall desi"n of the system is achieved% The functionalities of the system is desi"ned and studied in this phase% The fist step is desi"nin" of po"am specification% This detemines the vaious data inputs to the system# data flow and the fomat in which output is to be obtained% Desi"n phase is a tansmission phase because it is a tansition fom use oiented document to compute data% The activity in the desi"n phase is the allocation of functions to manual opeations# e6uipment and compute po"ams% Flow chats pepaed in the study time eceived and decomposed until all functions in the system pefom evidently% Desi"n is a multistep pocess that focuses on data stuctues# softwae achitectue# pocedual details 2 al"oithms etc( and lin!s between the modules% The desi"n pocess "oes thou"h lo"ical and physical sta"es% In lo"ical desi"n eviews ae made lin!in" e:istin" system and specification "atheed% The physical plan specifies any hadwae and softwae e6uiement# which satisfies the local desi"n% Modulai&ation of tas! is made in the mode% The success of any inte"ated system depends on the plannin" of each and evey fundamental module% Usually a po$ect is evised in step by step se6uence% Inte phase mana"ement of such module is also impotant% -oftwae desi"n methodolo"y chan"es continually as new methods# bette analysis and boade undestandin" evolve% 8aious techni6ues fo softwae desi"n do e:it with the availability of citeia fo desi"n 6uality% -oftwae desi"n leads thee technical activities+desi"n# code and test% The techni6ues fo softwae desi"n do e:it with the availability of citeia fo desi"n 6uality% -oftwae desi"n leads thee technical activities+desi"n# code and test Page 23
CHIT FUND MAINTENANCE
that ae e6uied to build and veify softwae% Each activity tansfoms infomation# which validates the softwae% The desi"n system convets theoetical solution intoduced by the feasibility study into a lo"ical eality%
1)?ii) E&I* &!RA!E'
The desi"n state"y is a vital aspect of the system to be developed% The desi"n of the softwae eflects the basic undestandin" of the poblem% Fo desi"nin" a "ood system what we have to be is to "et coect definition of the poblem and analy&e the poblem thoou"hly% The desi"n of a system should be such that if a small potion is chan"ed% The est of the system should be unaffected% This is the fle:ibility of the system% .eate the system fle:ibility "eate will be the system eliability% 9hile cayin" out the $ob of desi"nin" of a new system one has to conside many factos% These factos include the dawbac!s and limitations of the pesent manual system as well as of the featues and advanta"es of the poposed system% It should be desi"ned in such a manne that even a layman can un it without any difficulty%
An impotant 6uality of a softwae must en$oy is use fiendliness% It can be achieved in many ways li!e povidin" menu# "ivin" conte:t sensitive help# doin" automatic validation to input data# etc% Anothe main facto is speed efficiency% In ode to achieve speed efficiency# the po"am should be desi"ned accodin"ly and the use is povided with a compiled copy of the softwae pac!a"e with necessay data file fomat athe than souce code% Desi"n of input and output fomats is e6ually impotant fo any desi"n% The output fomat should be desi"ned in such a way that it must eflect all the e6uied infomation in detail% The desi"n of the database itself such as type of data stoed# si&e of data etc% -ome of the decisions made duin" database desi"n ae* Page 24
CHIT FUND MAINTENANCE
9hich data items ae to be ecoded and in which database%
>en"th of each ecod# based on the chaacteistics of the data items on which it is based%
Data who?s unauthoi&ed chan"e must be pevented%
Data# which must be avoided fom edundancy%
Maintenance of data inte"ity etc% Avoid ove witin"s%
1events invalid data access and chan"es%
Havin" all this# a positive inteaction with clients at evey sta"e of development is the coe aound which the softwae is built%
Page 25
CHIT FUND MAINTENANCE
8.1
A!A ,OW IARA(
Data flow oiented techni6ues advocate that the ma$o data items handled by a system must be fist identified and then the pocessin" e6uied on these data items to poduce the desied outputs should be detemined% The DFD 2also called as bubble chat( is a simple "aphical fomalism that can be used to epesent a system in tems of input data to the system# vaious pocessin" caied out on these data# and the output "eneated by the system% It was intoduced by De Maco 2'K@(# .ane and -ason 2'KK(%The pimitive symbols used fo constuctin" DFD?s ae* &mbols used in
A circle epesents a pocess%
A rectangle epesents e:tenal entity
A square defines a souce o destination of the system data% Page 26
CHIT FUND MAINTENANCE
An arrow identifies dataflow%
Double line with one end closed indicates data stoe
Page 27
CHIT FUND MAINTENANCE
Page 28
CHIT FUND MAINTENANCE
ER DIA*RA+ U$e Ca$e$ ,h%- .#'! I'-e/.a,e
C$it %und management inter%ace
&ain %orm
'ser login
Admin login
Add subscribers
Add new user Admin
Add 'ser
Page 29
CHIT FUND MAINTENANCE
C$it %und inter%ace
&ain %orm
(ogin %orm
C$it %orm
Cancle member #a)ment
Add new subscriber
Da) o% auction Em#lo)ee
installments
Contact "
About '"
Page 30
CHIT FUND MAINTENANCE
*e##elin Reservation Inter%ace
&ain %orm
(ogin %orm
Agent add
+a)ment
bid "tatus ,ield ocer
cancel agent
Contact "
About '"
Page 31
CHIT FUND MAINTENANCE
%O*VER!I* ER IARA( I*!O !A,E& 0. %on9erting strong entit tpes
Each entity type becomes a table Each sin"le valued attibute becomes a column Deived attibutes ae i"noed Composite attibutes ae epesented by components Multi+valued attibutes ae epesented by a sepaate table ey attibutes of the entity type is the 1imay ey
3. %on9erting relationships
)elationships ae based on cadinalities and de"ee of the elation m:n I"'RED +O(IC/
./
m
n
+O(IC/
inar 0:0
C0OO"E" +O(IC/ 0O(DER
C(AI&AT
0 0 Page 32
CHIT FUND MAINTENANCE
1. Relations con9erted
1olicy holde and policy have m*n cadinality which esults in convesion of the elation Linsued by? into a table named as Linsuance?% The insuance table has ph !ey and pol!ey fom policy holde table and policy table espectively #as its composite pimay !ey% Also policy and a"ent table have m*n cadinality esultin" in convesion of elation Lsales?# into a table named as Lsales?% The table sales has ph !ey and pol !ey fom policy holde table and policy table espectively #as its composite pimay !ey and a"ent !ey fom a"ent table as a foei"n !ey%
*OR(A,I&A!IO* O4n table normali@ation
Nomali&ation is a method fo o"ani&in" data elements in a database into tables% It !eeps tac! to !eep the database less vulneable to some types of lo"ical inconsistencies and anomalies% Tables can be nomali&ed to vayin" de"ees li!e fist# second# 0CNF% .eate the de"ee of nomali&ation moe is the potected fom inconsistencies and anomalies% The tables may be nomali&ed unde the followin" "uideline* '% 0* Page 33
CHIT FUND MAINTENANCE
DEFINITI4N* A elation schema is in 'NF if all of its attibutes ae* • • •
-in"le valued )esticted to assumin" atomic values Functionally dependent on the pimay !ey
Domain is atomic if its elements ae consideed to be indivisible units % E:amples of non+atomic domains -et of names# composite attibutes Identification numbes li!eph!ey that can be bo!en up into pats A elational schema ) is in fist nomal fom if the domains of all • •
• •
attibutes of ) ae atomic% All domains in ou database ae atomic since they ae indivisible% No Duplication of data #Inset Anomaly #Delete Anomaly #Update Anomaly found# theefoe ou database cleas the fist nomal fom test%
,% 3* DEFINITI4N* A elational table is said to be in second nomal fom ,NFif it is in 'NF and evey non+!ey attibute is fully functionally dependent upon pimay !ey% The citeia fo second nomal fom2,NF( ae* The table must be in NF% Evey non+!ey attibutes of the table must be dependent upon the entie pimay !ey% Tables a"ent #policy holde #claimant #insuance #sales ae also in ,NF% ou database satisfies all the conditions of ,NF since The tables ae in • •
• •
'NF and Evey non+!ey attibutes of the table must be dependent upon the entie pimay !ey%
Page 34
CHIT FUND MAINTENANCE
/% 1* •
• •
• • •
A elation is in /NF if and only if#it is in ,NF and thee ae no tansitive functional dependencies% Tansitive functional dependencies aise% 9hen one non+!ey attibute is functionally dependent on anothe non+ !ey attibute% Functional Dependency* non+!ey attibuteOnon+!ey attibute% 9hen thee is edundancy in the database% The tables insuance #claimant #policy holde and sales have been conveted into /NF%
0y definition tansitive functional dependency can only occu if thee is moe than one non+!ey field# so we can say that a elation in ,NF with &eo o one non+!ey field must automatically be in /NF%
Page 35
CHIT FUND MAINTENANCE
A!AA&E E&I*
A database is an o"ani&ed mechanism that has the capability of stoin" infomation thou"h which a use can etieve stoed infomation in an effective and efficient manne% The data is the pupose of any database and must be potected% The database desi"n is a two level pocess% In the fist step# use e6uiements ae "atheed to"ethe and a database is desi"ned which will meet these e6uiements as clealy as possible% This step is called Infomation >evel Desi"n and it is ta!en independent of any individual Database Mana"ement -ystem 2D0M-(% In the second step# this Infomation level desi"n is tansfeed into a desi"n fo the specific D0M- that will be used to implement the system in 6uestion% This step is called 1hysical >evel Desi"n# concened with the chaacteistics of the specific D0M- that will be used% A database desi"n uns paallel with the system desi"n% The o"ani&ation of the data in the database is aimed to achieve the followin" two ma$o ob$ectives%
•
Data Inte"ity
•
Data independence
Page 36
CHIT FUND MAINTENANCE
I*#+! E&I*
Input desi"n is the pocess of convetin" use+oi"inate inputs to a compute+ based fomat% The "oal of desi"n input data is to ma!e data enty as easy# lo"ical and fee% The most common souce of data pocessin" eos is inactive input data% Effective desi"n of the input data minimi&es the eo made by data enty opeatos% Catchin" eos on input is fa less costly than coectin" afte data stoa"e is complete% Use+fiendly input desi"n enables 6uic! eo detectin" and coection% 8eification and validation is the most impotant in input desi"n% -ince the system is used inteactively# it has two types of inputs% Inteactive input+which is the point contact of the use with the system and the input to the intenal system i%e% Databases% Fo full efficiency of the system# it is necessay that the input must be accuate% -ince the use of the system may not be a technical peson and may not !now input concepts so it is e6uied that he wan# pevent and coect invalid data enty% Thee ae many ways that can be desi"ned to handle such a situation% 9e can pevent the use entein" invalid data into the databases by wanin"# ne"lectin" o messa"in" appopiately% The use is then allowed to input coect data% -ome help povisions may aid the use to point out the eo% In this system inputs ae collected fom teminals thou"h !eyboad%
Page 37
CHIT FUND MAINTENANCE
O+!#+! E&I*
4utput desi"n has been an on"oin" activity fom the vey be"innin" of the po$ect% The ob$ective of the output desi"n is to convey the infomation of all past activities# cuent status and to emphasi&e impotant events% The output "eneally efes to the esults and infomation that is "eneated fom the system% The output desi"n of the system is accomplished !eepin" in mind the followin" activities*
Detemine what infomation is to display%
Decide whethe to display o pint the infomation etieved# pocessed# "eneated fom the system%
Aan"e the pesentation of infomation in an acceptable fomat%
Decide how to distibute the output to the intended ecipients% In the output desi"n phase one o moe output media can be selected% 4ut of which the most common ones ae C)T displays and pint out% Hee only C)T display has been attempted% A apid en6uiy is obtained fom C)T displays% Fom desi"n is made inteestin" and attactive% Easy undestandin" and effectiveness is made possible%
Page 38
CHIT FUND MAINTENANCE
A!AA&E !A,E E&I*
!able *ame: emo !able #rimar e: #olic*o
!able *ame: #olic #remium !able #rimar e: #olic*o
Page 39
CHIT FUND MAINTENANCE
!able *ame: #olic !able #rimar e: #olic*o
Page 40
CHIT FUND MAINTENANCE
OR( E&I*
1ivate -ub abtClic!2( Fom7%-how End -ub Page 41
CHIT FUND MAINTENANCE
1ivate -ub alldataClic!2( FomK%-how End -ub
1ivate -ub cAddClic!2( Fom@%-how End -ub
1ivate -ub e:itClic!2( End End -ub
1ivate -ub MDIFom>oad2( lo"%-how Fom'%-how Fom5%Cuent< P ; Fom5%>eft P Me%9idth = '%;K Fom5%Hei"ht P Me%Hei"ht = '%, Fom5%Top P ; 1ictue'%Auto-i&e P Tue 1ictue'%9idth P -ceen%9idth Q ' End -ub Page 42
CHIT FUND MAINTENANCE
1ivate -ub MDIFomUnload2Cancel As Inte"e( Unload Me Fom''%-how End -ub
1ivate -ub mnueditClic!2( Fom'3%-how End -ub
1ivate -ub mwindowClic!2( Fom'%-how End -ub
1ivate -ub seachClic!2( Fom,%-how End -ub
1ivate -ub Toolba'0uttonClic!20y8al 0utton As M-Comctl>ib%0utton( -elect Case 0utton%Inde: Case ' Fom@%-how
Page 43
CHIT FUND MAINTENANCE
Case , Ms"0o: 2R-econdR( Case / Ms"0o: 2RThidR( End -elect End -u
Page 44
CHIT FUND MAINTENANCE
Dim conn As New AD4D0%Connection 1ublic s As New AD4D0%)ecodset 1ublic s' As New AD4D0%)ecodset
1ivate -ub Combo,>ostFocus2( 4n Eo .oTo e If Combo,%Te:t S '@ Then
t:tapntname%8isible P Tue t:tapntadd%8isible P Tue >abel';%8isible P Tue >abel''%8isible P Tue Fame'%Hei"ht P K/5 t:tapntname%-etFocus Else t:tapntname%8isible P False >abel';%8isible P False t:tapntadd%8isible P False >abel''%8isible P False Te:t'%-etFocus Fame'%Hei"ht P 7,55 End If e* End -ub Page 45
CHIT FUND MAINTENANCE
1ivate -ub Combo/Chan"e2( Fom>oad End -ub
1ivate -ub Combo/>ostFocus2( If s'%E4F P False Then
Combo3%Te:t P s'Tabel
lbltable%Caption P s,TT
lbldoc%Caption P s,D4C
blpe%Caption P s,1emium
End If s'%Close End -ub
1ivate -ub Command'Clic!2( Te:t,%-etFocus Combo'%-etFocus
Te:t'%Te:t P RR
Te:t,%Te:t P RR
Te:t/%Te:t P RR
Command'%Enabled P False End -ub Page 46
CHIT FUND MAINTENANCE
1ivate -ub Command,Clic!2(
4n Eo .oTo h s%AddNew s2;( P Te:t'%Te:t s2'( P Te:t,%Te:t s2,( P t:taddcp%Te:t s2/( P Combo3%Te:t R + R Combo5%Te:t s23( P t:tadd%Te:t s25( P DT1ic!e'%8alue s27( P Te:t/%Te:t s2( P t:tnadd%Te:t s2@( P Te:t3%Te:t s2K( P Combo,%Te:t s2';( P t:tapntname%Te:t s2''( P t:tapntadd%Te:t s2',( P Combo/%Te:t s2'/( P DT1ic!e,%8alue s2'3( P Te:t5%Te:t s2'5( P Te:t7%Te:t s2'7( P Combo7%Te:t s2'( P DT1ic!e/%8alue s2'K( P Combo'%Te:t Page 47
CHIT FUND MAINTENANCE
If Ima"e'%1ictue P >oad1ictue2RR( Then s2'@( P Rno ima"e%$p"R Else " P App%1ath R>ic1hotoR s2'@( P Te:t,%Te:t Q R%$p"R -ave1ictue Ima"e'%1ictue# " Te:t,%Te:t R%$p"R End If
4n Eo .oTo h
If Ima"e'%1ictue P >oad1ictue2RR( Then
s2'@( P Rno ima"e%$p"R Else
Dim " As -tin"
M!Di App%1ath R>ic1hotoR
" P App%1ath R>ic1hotoR
-ave1ictue Ima"e'%1ictue# " Te:t,%Te:t R%$p"R
s2'@( P Te:t,%Te:t R%$p"R
End If If IsNull2s2'@(( P Tue Then If Ima"e'%1ictue P >oad1ictue2RR( Then
Page 48
CHIT FUND MAINTENANCE
s%Update Command,%Caption P R-aveR
h* Call -ubA Ms"0o: R-ucessfully -ave ou DataR End -ub 1ivate -ub Command3Clic!2( CommonDialo"'%-how4pen If Ima"e'%Hei"ht O /;;; And Ima"e'%9idth O ,5;; Then st P Ms"0o:2RThis 1hoto si&e is vey la"eR# vb4Cancel( vbC>f
Rou 1hoto si&e 7 cm to 3 cmR vbclf
Do you want chan"e# vb4Cancel# R>IC Ima"e >oadR(
If st P vb4 Then
CommonDialo"'%-how4pen
Ima"e'%1ictue P >oad1ictue2CommonDialo"'%FileName(
End If
Ima"e'%1ictue P >oad1ictue2RR( Else Ima"e'%1ictue P >oad1ictue2CommonDialo"'%FileName( End If CommonDialo"'%Filte P RB1. 2V%$p"(WV%$p"W0M1 2V%bmp(WV%bmpR CommonDialo"'%-how4pen CommonDialo"'%Filte P R1ictueWV%$p"R Ima"e'%1ictue P >oad1ictue2CommonDialo"'%FileName# ;%5( # ,57# ';;# '5;( Page 49
CHIT FUND MAINTENANCE
If Ima"e'%9idth O /;;; And Ima"e'%Hei"ht O /5;; Then Ima"e'%1ictue P >oad1ictue2RR( Ms"0o: R8ey 0i"# ou 1hoto si&e must be 5 c%m and 7 c%mR Ima"e'%1ictue P >oad1ictue2RR( Ima"e'%9idth P 5;;; Ima"e'%1ictue P >oad1ictue2RR( Else Else End If End -ub
1ivate -ub Command5Clic!2( CommonDialo",%-how4pen Ani%Animated.IF P Ani%>oadAnimated.IFFile2CommonDialo",%FileName( End -ub
1ivate -ub Fomey1ess2eyAscii As Inte"e( If eyAscii P '/ Then Unload Me End If End -ub
1ivate -ub Fom>oad2( Dim st As -tin" Page 50
CHIT FUND MAINTENANCE
-et conn P Nothin" conn%4pen R1ovidePMicosoft%Bet%4>ED0%3%;XData -oucePR App%1ath Rlic%mdbX1esist -ecuity InfoPFalseR st P Rselect V fom policyR s%4pen st# conn# ad4penDynamic# ad>oc!1essimistic Combo5%Te:t P 5 Call cmba"e Fo a P 5 To 5; Combo5%AddItem 2a( Ne:t Command,%Caption P RAddR s%Close PPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPP PPPPPPPPPPPPPPPPPPPP Dim st' As -tin" -et db P Nothin" db%4pen R1ovidePMicosoft%Bet%4>ED0%3%;XData -oucePR App%1ath R=lic%mdbXR
st P Rselect V fom 1NameR s'%4pen st# conn# ad4penFowad4nly# ad>oc!)ead4nly s%4pen st# db# ad4penFowad4nly# ad>oc!)ead4nly s'%MoveFist If IsNull2s'2;(( P False Then 9hile Not s'%E4F Page 51
CHIT FUND MAINTENANCE
Combo/%AddItem 2s'2;((
s'%MoveNe:t 9end End If PPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPP s'%MoveFist If IsNull2s'2'(( P False Then 9hile Not s'%E4F Combo3%AddItem 2s'2'((
s'%MoveNe:t 9end End If End If s'%Close PPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPP PPPPPPPPPPPPPPPPPPPPPP End -ub
1ivate -ub FomUnload2Cancel As Inte"e( conn%Close Fom'%-how End -ub Page 52
CHIT FUND MAINTENANCE
Function cmba"e2( Fo I P ' To 75 Combo,%AddItem 2I( Ne:t End Function
1ivate -ub Te:t'Chan"e2( If IsNumeic2Te:t'%Te:t( P False Then Te:t'%Te:t P RR Te:t'%-etFocus End If End -ub 1ivate -ub Te:t'ey1ess2eyAscii As Inte"e( If eyAscii P '/ Then Dim db As New AD4D0%Connection Dim s As New AD4D0%)ecodset Dim !ey As Inte"e# st As -tin"
If Te:t'%Te:t P RR Then Te:t'%Te:t P RR Else !ey P Input0o:2REnte the Employee No whose details u want to !now* R( -et db P Nothin" Page 53
CHIT FUND MAINTENANCE
db%4pen R1ovidePMicosoft%Bet%4>ED0%3%;XData -oucePR App%1ath R=lic%mdbXR
-et s P Nothin"
st P Rselect V fom policy whee 1olicyNoPR Te:t'%Te:t s%4pen st# db# ad4penFowad4nly# ad>oc!)ead4nly P ' If s%E4F P Tue Then Else s P Ms"0o:2R-oy Data is aleady E:itR vbC>f R Do you want see DataR# vbesNo# R>IC AlatR( If s P vbNo Then Te:t'%Te:t P RR Te:t'%-etFocus Else Me%Hide Fom'/%>abel'%Caption P s1olicyNo Fom'/%>abel,%Caption P sName Fom'/%-how vbModal End If
-et s P Nothin"
st P Rselect V fom policyR
s%4pen st# db# ad4penDynamic# ad>oc!1essimistic End If Page 54
CHIT FUND MAINTENANCE
End If db%Close End If End -ub
1ivate -ub Te:t5Chan"e2( If IsNumeic2Te:t5%Te:t( P False Then Te:t5%Te:t P RR End If End -ub
1ivate -ub Te:t'>ostFocus2( If Te:t'%Ma:>en"th O K Then Ms"0o: R1lease Ente only Numeic 8alue in 1olicy No%R
End If Dim db As New AD4D0%Connection Dim s As New AD4D0%)ecodset Dim !ey As Inte"e# st As -tin"
If Te:t'%Te:t P RR Then Te:t'%Te:t P RR Else !ey P Input0o:2REnte the Employee No whose details u want to !now* R( Page 55
CHIT FUND MAINTENANCE
-et db P Nothin" db%4pen R1ovidePMicosoft%Bet%4>ED0%3%;XData -oucePR App%1ath R=lic%mdbXR -et s P Nothin" st P Rselect V fom policy whee 1olicyNoPR Te:t'%Te:t s%4pen st# db# ad4penFowad4nly# ad>oc!)ead4nly P ' If s%E4F P Tue Then Else s P Ms"0o:2R-oy Data is aleady E:itR vbC>f R Do you want see DataR# vbesNo# R>IC AlatR( If s P vbNo Then Te:t'%Te:t P RR Te:t'%-etFocus Else Me%Hide Fom'/%>abel'%Caption P s1olicyNo Fom'/%>abel,%Caption P sName Fom'/%-how vbModal End If
-et s P Nothin"
st P Rselect V fom policyR s%4pen st# db# ad4penDynamic# ad>oc!1essimistic End If End If Page 56
CHIT FUND MAINTENANCE
db%Close End -ub
1ivate -ub Te:t7Chan"e2( If IsNumeic2Te:t5%Te:t( P False Then Te:t5%Te:t P RR End If End -ub
1ublic -ub -ubA2( 4n Eo .oTo 1ocEo
othe code Ms"0o: FuncA2(
1ocE:it* E:it -ub
1ocEo* Ms"0o: E%Desciption )esume 1ocE:it End -ub 1ivate Function FuncA2( As Date FuncA P CDate2Rhi theeR( Page 57
CHIT FUND MAINTENANCE
End Function
1ublic s As New AD4D0%)ecodset 1ublic conn As New AD4D0%Connection Dim con As AD4D0%Connection Dim s' As AD4D0%)ecodset Dim st' As -tin" Dim num# id: As Inte"e Page 58
CHIT FUND MAINTENANCE
Dim findit# 6uey As -tin" Dim db, As New AD4D0%Connection Dim s, As AD4D0%)ecodset
Function connectD02( -et con P New AD4D0%Connection -et s' P New AD4D0%)ecodset con%4pen R1ovidePMicosoft%Bet%4>ED0%3%;X1esist -ecuity InfoPFalseXData -ouceP R App%1ath Rlic%mdbR End Function 1ivate -ub Command'Clic!2( Dim stm As -tin" Dim a As Inte"e Call connectD0 st' P Rselect V fom peR s'%4pen st'# conn# ad4penDynamic# ad>oc!1essimistic s'%MoveNe:t a P s'23( s'%AddNew s'2;( P Te:t'%Te:t s'2'( P DT1ic!e'%8alue s'2,( P Te:t,%Te:t s'2/( P DT1ic!e,%8alue Page 59
CHIT FUND MAINTENANCE
s'23( P 8al2a( Q 8al2Te:t,%Te:t( s'%Update stm P Ms"0o:2Rou Data -ucessfully -aveR# vb4Cancel# R>IC AddR(
If stm P vbCancel Then E:it -ub Else Command3%Enabled P False End If End -ub
1ivate -ub Command,Clic!2( Unload Me End -ub 1ivate -ub Command,Clic!2( Fom'%-how Unload Me End -ub 1ivate -ub Command/Clic!2( Dim st As -tin" -et db P Nothin"
If IsNumeic2Te:t'%Te:t( P False Then Ms"0o: R1lese Ente only No*R Page 60
CHIT FUND MAINTENANCE
Else Fame'%8isible P Tue
db%4pen R1ovidePMicosoft%Bet%4>ED0%3%;XData -oucePR App%1ath R=lic%mdbXR
st P RselectV fom policyR
s%4pen st# db# ad4penDynamic# ad>oc!1essimistic s%MoveFist
lblname%Caption P s2'(
lbladd%Caption P s2,(
lbltable%Caption P s2/(
db%Close
End If -et cn P New AD4D0%Connection -et s P New AD4D0%)ecodset conn P R1ovidePMicosoft%Bet%4>ED0%3%;X1esist -ecuity InfoPFalseXData -oucePR App%1ath Rlic%mdbR cn%4pen 2conn( Dim fla" As 0oolean -et s P cn%E:ecute2R-elect 1olicyNo#Name# Addess# TT#D4C#1emium fom policyR( Page 61
CHIT FUND MAINTENANCE
Do Until s%E4F P Tue If s1olicyNo P Me%Te:t' Then fla" P Tue E:it Do End If s%MoveNe:t >oop If fla" P Tue Then
Fame'%8isible P Tue
lblname%Caption P sName
lbladd%Caption P sAddess
lbltable%Caption P sTT
lbldoc%Caption P sD4C
lblpe%Caption P s1emium
Command3%Enabled P Tue
Else Fame'%8isible P False Ms"0o: R1olicy Numbe not foundR# vb44nly# R>IC 1aymentR Time'%Enabled P Tue End If -et cn P Nothin" Page 62
CHIT FUND MAINTENANCE
s%Close End -ub 1ivate -ub Command3Clic!2( Call connectD0 st' P Rselect V fom peR s'%4pen st'# conn# ad4penDynamic# ad>oc!1essimistic s'%AddNew Te:t,%Te:t P R R Te:t,%-etFocus Command3%Enabled P False Command'%Enabled P Tue End -ub 1ivate -ub FomeyDown2eyCode As Inte"e# -hift As Inte"e( -elect Case eyCode Case vbeyFK Fame'%8isible P Tue End -elect End -ub
1ivate -ub FomActivate2( Page 63
CHIT FUND MAINTENANCE
Dim a As Inte"e Call connectD0 st' P Rselect V fom peR s'%4pen st'# conn# ad4penDynamic# ad>oc!1essimistic s'%Move>ast a P s'Total a P s'%Fields23( End -ub
1ivate -ub Fom>oad2( Dim st As -tin" -et conn P Nothin" db,%4pen R1ovidePMicosoft%Bet%4>ED0%3%;XData -oucePR App%1ath Rlic%mdbX1esist -ecuity InfoPFalseR conn%4pen R1ovidePMicosoft%Bet%4>ED0%3%;XData -oucePR App%1ath Rlic%mdbX1esist -ecuity InfoPFalseR Command'%Enabled P False Command3%Enabled P False End -ub
1ivate -ub FomUnload2Cancel As Inte"e( Fom'%-how s,%Close db,%Close Page 64
CHIT FUND MAINTENANCE
conn%Close End -ub
PPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPP 1ublic -ub findst2tb As Contol# 0y8al st As -tin"# int!ey As Inte"e( If 2int!ey O ', 4 int!ey S /,( And Not int!ey P @ Then E:it -ub If Not int!ey P @ Then If tb%Te:t P RR Then findit P st ChY2int!ey( Else findit P >eftY2st# tb%-el-tat( ChY2int!ey( End If End If If int!ey P @ Then If >en2tb%Te:t( P ; Then Else E:it -ub num P tb%-el-tat + ' findit P >eft2st# num( End If End If 6uey P Rselect V fom policy whee 1olicyNo li!e R findit RZR Page 65
CHIT FUND MAINTENANCE
-et s, P db,%E:ecute26uey( If s,%E4F Then E:it -ub tb%Te:t P s,2;( tb%-el-tat P >en2findit( tb%-el>en"th P >en2tb%Te:t( + tb%-el-tat int!ey P ; End -ub PPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPP 1ivate -ub Te:t'ey1ess2eyAscii As Inte"e( findst Te:t'# Te:t'%Te:t# eyAscii If eyAscii P '/ Then If s,%E4F P False Then Fame'%8isible P Tue Ima"e'%8isible P Tue
lblname%Caption P s,M-t s,Name lbladd%Caption P s,Addess lblpe%Caption P s,1emium lbltable%Caption P s,TT lbldoc%Caption P s,D4C blpe%Caption P s,1emium If IsNull2s,2'@(( P Tue Then Ima"e'%1ictue P >oad1ictue2App%1ath R>ic1hotono ima"e%$p"R( R( Else Page 66
CHIT FUND MAINTENANCE
Ima"e'%1ictue P >oad1ictue2App%1ath R>ic1hotoR s,2'@(( End If Command3%Enabled P Tue Else Ms"0o: R-oy not foundR Command'%Enabled P False Fame'%8isible P False Ima"e'%8isible P False End If End If End -ub
Page 67
CHIT FUND MAINTENANCE
Page 68
CHIT FUND MAINTENANCE
Page 69
CHIT FUND MAINTENANCE
Page 70
CHIT FUND MAINTENANCE
Page 71
CHIT FUND MAINTENANCE
Page 72
CHIT FUND MAINTENANCE
8.7 Report: 0. !he label o6: It
allows you to display te:t that you don?t want the use to chan"e# such as a caption
Unde a .aphic# when u wants to pint the invoice# you need to !now if the custome is "oin" to pay 0y cash o chec! o cedit cad%
The command 0uttons* Ceates a button that the use can choose to cay out a command% The use 9ill clic! on this button and the compute will pefom the tas! associated with The button%
3. !he !e6t o6 control: In ode to display o accept use input in the fom of te:t li!e# Custome ID# name #a"e etc% it is used to display te:t and allows the use to edit the data in the bo:% A te:t bo: contol is also called an edit field o edit contol%
1. !he picture o6: A pictue bo: contol can display a "aphic fom a bitmap# icon o metafile # as well as enhanced metafile# .1E.# o .IF%it clips the "aphic if the contol Isn?t la"e enou"h to display the entie ima"e%
8. !he ata %ontrol: The data contol is pat of standad toolbo:% It has buttons fo movin" fom )ecod too ecod #you have buttons to move the ne:t o last ecod and to move The pevious and fist ecod %you can also set the caption popety fo the data 8.; !E&!I* Page 73
CHIT FUND MAINTENANCE
Testin" is a pocess of e:ecutin" a po"am with the inteest of findin" an eo% A "ood test is one that has hi"h pobability of findin" the yet undiscoveed eo% Testin" should systematically uncove diffeent classes of eos in a minimum amount of time with a minimum amount of effots% Two classes of inputs ae povided to test the pocess '% A softwae confi"uation that includes a softwae e6uiement specification# a desi"n specification and souce code% ,% A softwae confi"uation that includes a test plan and pocedue# any testin" tool and test cases and thei e:pected esults% Testin" is divided into seveal distinct opeations*
0. +nit !esting
Unit test compises of a set tests pefomed by an individual po"am pio to the inte"ation of the unit into la"e system% A po"am unit is usually the smallest fee functionin" pat of the whole system% Module unit testin" should be as e:haustive as possible to ensue that each epesentation handled by each module has bee tested% All the units that ma!eup the system must be tested independently to ensue that they wo! as e6uied% Duin" unit testin" some eos wee aised and all of them wee ectified and handled well% The esult was 6uiet satisfactoy and it wo!ed well% Page 74
CHIT FUND MAINTENANCE
3. Integration !esting
Inte"ation testin" is a system techni6ue fo constuctin" the po"am stuctue while at the same time conductin" tests to uncove eos associated with intefacin"% The ob$ective is to ta!e unit tested modules and build a po"am stuctue that has been dictated by desi"n% 0ottom+up inte"ation is the taditional state"y used to inte"ate the components of a softwae system into functionin" whole% 0ottom+up inte"ation consists of unit test followed by testin" of the entie system% A sub+system consists of seveal modules that communicated with othe defined inteface% The system was done the inte"ation testin"% All the modules wee tested fo thei compatibility with othe modules %They test was almost successful% All the modules coe:isted vey well# with almost no bu"s% All the modules wee encapsulated vey well so as to not hampe the e:ecution of othe modules%
1. Validation !esting
Afte validation testin"# softwae is completely assembled as a pac!a"e# intefacin" eos that have been uncoveed and coected and the final seies Page 75
CHIT FUND MAINTENANCE
of softwae testX the validation test be"ins% -teps ta!en duin" softwae desi"n and testin" can "eatly impove the pobability of successful inte"ation in the la"e system% -ystem testin" is actually a seies of diffeent tests whose pimay pupose is to fully e:ecise the compute based system% 8. Reco9er !esting
It is a system that foces the softwae to fail in a vaiety of ways and veifies that the ecovey is popely pefomed%
B. &ecurit !esting
It attempts to veify that potection mechanisms built into a system will in fact potect it fom impope penetation% The system?s secuity must of couse be tested fom in vulneability fom fontal attac!% <. &tress !esting
-tess tools ae desi"ned to confont po"ams with abnomal situations% -tess testin" e:ecutes a system in a manne that demands esouces in abnomal 6uantity and volume% 7. lac5 o6 !esting
0lac! bo: testin" is done to find out the followin" infomation as shown in below* '% Incoect o missin" functions% ,% Inteface eos% Page 76
CHIT FUND MAINTENANCE
/% Eos o database access% 3% 1efomance eo% 5% Temination eo% The mentioned testin" is caied out successfully fo this application accodin" to the use?s e6uiement specification%
;. !est ata Output
Afte pepain" test data# the system unde study is tested usin" the test data% 9hile testin" the system usin" test data# eos ae a"ain uncoveed and coected by usin" above testin" and coections ae also noted fo futue use%
B. %onclusion C Ad9antageous B.0 %onclusion:
The CHIT FUND MAINTENANCE --TEM is a "eat impovement ove the manual system usin" case fields and pape% The computei&ation of the system has Page 77
CHIT FUND MAINTENANCE
sped up the pocess% In the cuent system# the font office mana"in" is vey slow% The Insuance 1olicy mana"in" system was thoou"hly chec!ed and tested with dummy data and thus is found to be vey eliable%
Ad9antages:
It is fast# efficient and eliable Avoids data edundancy and inconsistency 8ey use+fiendly Easy accessibility of data Numbe of pesonnel e6uied is consideably less
1ovides moe secuity and inte"ity to data
<. ibliograph: B$ Page 78
CHIT FUND MAINTENANCE •
A Complete .uide to 1o"ammin" in 8isual 0asic %7%; +Mohammed A&am
•
A Complete 8isual 0asic 7 Tainin" Couse* How to 1o"amme* 1ac!a"e +Havey M deitel#1aul $ deitel#Tem ) Neito
•
Advanced 1o"ammin" Usin" 8isual 0asic* 8esion 7%; +Bulia Case 0adley
•
Access ,;;/1owe 1o"ammin" with 80A +Allen . Taylo
•
Advanced M- 8isual 0asic +1ete Mois
B.0 Reference: •
•
wwwassociatedcontentcom wwwmemberstri#odcom www#roect-downloadcom
Page 79