Accesaskjduiadshyuadsjdasjhadsuygdasygvdsagdavscgfcdsagvvdsabnbdsajdsahsaddasnjuadsidshnjjkads

8/9/2019 Accesaskjduiadshyuadsjdasjhadsuygdasygvdsagdavscgfcdsagvvdsabnbdsajdsahsaddasnjuadsidshnjjkads

http:///reader/full/accesaskjduiadshyuadsjdasjhadsuygdasygvdsagdavscgfcdsagvvdsabnbdsajdsahsaddasnjuadsids 1/48

Storing Modifying And Retrieving

Students Data

19

DATA FLOW DIAGRAM

LEVEL 0 DFD OF COMPUTER INSTITUTE

MANAGEMENT SYSTEM

User name &

Password

Details of



20

LEVEL 1 DFD OF COMPUTER INSTITUTE MANAGEMENT SYSTEM

Access Denied

Access

Granted

New Student

Edit Reports

Records

Printing

Storing, Manipulation & Retrieval O Student Data

Editing O Records Student Detail

Reports

Addition O NewRecords

MD!" Main MenuReports

#eriication O $%e

Data

Attempt Granted or

$%ree $imes

'as% Detail Reports i(e(ee Detail(

Cancellation &Reprinting

Printing O ees

Receipt



21

DATA DICTIONARY

Data dictionar) ma) cover t%e w%ole organi*ation, a part o t%e organi*ation or

a data+ase( !n its simplest orm, t%e data dictionar) is onl) a collection o dataelement deinitions, according to descriptions +elow( More advanced data

dictionar) contains data+ase sc%ema wit% reerence e)s, still more advanced

data dictionar) contains entit)-relations%ip model o t%e data elements or

o+.ects(

TABLES USED IN DATABASE

$A/0E 12

NAME2 Users

PURPOSE2 !t stores t%e details o t%e users woring on t%e sotware((

$A/0E 32

NAME2 Student

PURPOSE2 !t stores t%e details o t%e students in t%e institute

$A/0E 42

NAME2 !nstructor

PURPOSE2 !t stores t%e details o t%e instructors"teac%ers in t%e institute(

$A/0E 52

NAME2 'ourse

PURPOSE2 !t stores t%e details o t%e courses oered +) t%e institute(

$A/0E 62

NAME2 $ransaction

PURPOSE2 !t stores t%e details o t%e pa)ment details o students(



22

DESIGN PHASE

$%e design p%ase ocuses on t%e detailed implementation o t%e s)stem

recommended in t%e easi+ilit) stud)( Emp%asis is on translating perormance

speciications into design speciications( $%e design p%ase is a transition rom a

user-oriented document 7s)stem proposal8 to a document oriented to t%e

programmers or data+ase personnel(

$%e design process is a set o iterative steps t%at allow t%e designer to descri+e

all t%e aspects o t%e sotware to +e +uilt, +ased on t%e user speciication(

S)stem design goes t%roug% two p%ases2

Logi!" D#$ig%& 9%en anal)sts prepare t%e logical s)stem design, t%e)

speci) t%e user needs at a level o detail t%at virtuall) determines t%e

inormation low into and out o t%e s)stem and t%e re:uired data

resources(

P'($i!" D#$ig%& $%is produces t%e woring s)stem +) deining t%e

design speciications t%at tell programmers e;actl) w%at t%e candidate

s)stem must do( !n turn, t%e programmer writes t%e necessar) programs

or modiies t%e sotware pacage t%at accepts input rom t%e user,

perorms t%e necessar) calculations t%roug% t%e e;isting ile or data+ase,

produces t%e report on t%e %ard cop) or displa)s it on t%e screen and

maintains an updated data+ase at all times(

A good s)stem design is t%e e) to eective engineering process( !t serves as a

+ridge +etween anal)sis activities t%at descri+e t%ose properties a s)stem s%ould

posses, and implementation activities t%at descri+e t%e language and

environment(



24

INPUT)OUTPUT DESIGN

A good GU! application s%ould +e ver) user riendl)( !t s%ould +e simple and

eas) to use( !t s%ould %ave a consistent loo and eel t%roug%out( A good

interace design along wit% proper error %andling can ensure +est perormance

rom a sotware product(

$%e dierent GU! controls to +e used in t%e application are2

'ommand /utton = $%is control is used to initiate some unction +ased

on a user>s action o clicing t%e +utton(

Option /utton = $%is is similar to t%e command +uttons in unction

e;cept or t%e act t%at a user can select onl) one o t%e options at a time

rom a group o option +uttons(

$e;t /o; = !t is a rectangular s%aped +o; used or taing user input(

rame = $%is control is used to group dierent controls on a orm(

Picture /o; = $%is control is used to displa) images(

0a+el = $%is control is used to displa) some te;t t%at a user can>t edit( !t

is +asicall) used to identi) a particular control on t%e orm(

'om+o /o; = $%is control allows a user to select an item rom a list o

options availa+le( $%e user can also add some input o its own(

Scroll /ars = $%ese controls %elp a user to scroll some image or data

%ori*ontall) and verticall)(

Menu 'ontrols = $%e menus provide various options and commands

availa+le in t%e application to t%e user(

$ool /ars = $%ese controls are used to displa) dierent tools(



2

$imer 'ontrol = A good control or controlling grap%ics and animations

in visual +asic( Using it )ou can repeat a particular code at a regular

interval o time(

'%ec /o;es = $%ese +uttons can +e used to provide t%e users wit% some

options rom w%ic% none, some or all options can +e selected(

OUTPUT OF THE SYSTEM

$%e output o t%e s)stem also needs to +e ver) clear and simple in la)out( !t

s%ould serve its purpose well +) providing t%e rig%t ind o inormation to t%e

user at t%e rig%t time( $%e GU! s%ould +e ver)-ver) user riendl)( $%ere s%ould

+e report printing acilit) to generate a %ard cop) o all t%e current status o t%e

s)stem(

Attractiveness o t%e s)stem output also matters( #er) oten t%e success and

acceptance o a s)stem depends on good presentation o %e output(



2!

TESTING

$esting is a ver) critical activit) t%at ensures t%e lia+ilit) o a particular sotware

product( During t%is activit) t%e sotware to +e tested is e;ecuted wit% a set o

tests, and t%e output and unctioning o t%e program are evaluated( !t is done to

ensure w%et%er t%e s)stem meets t%e speciied re:uirements or not(

$esting can +ring ort% some aspects t%at %ave not +een considered or covered

+) t%e developers( $esting a large program is a comple; process t%at can +e

+roen down into two parts2

unit testing

s)stem testing

!n t%e irst case t%e dierent modules o t%e application are tested individuall)(

!n case o s)stem testing t%e sotware is tested as a w%ole( $%e s)stem

undergoes several tests lie2

time tests

perormance tests

memor) tests

input and output tests, etc(

$esting can +e done in t%e ollowing t%ree p%ases2

P*og*!++!,i T#$,i%g - $%is is done to determine w%et%er t%e

application wors according to t%e speciications(


http:///reader/full/accesaskjduiadshyuadsjdasjhadsuygdasygvdsagdavscgfcdsagvvdsabnbdsajdsahsaddasnjuadsi 10/48

2#

IMPLEMENTATION

$%is is almost t%e last stage o t%e s)stem development lie c)cle( !mplementing

t%e developed s)stem in t%e real environment is a ver) +ig and important tas( !t

re:uires utmost care( $%ere are various wa)s to implement t%e new s)stem(

Di*#, C/,o#*& $%is is a rat%er ris) met%od in w%ic% t%e entire old

s)stem is directl) replaced +) t%e new one( $%is met%od s%ould +e

adopted w%en t%ere is %ig% conidence on t%e new s)stem and t%ere is not

muc% ris in s%utting down t%e old s)stem(

P!*!""#" Co%#*$io%& !n t%is met%od t%e old and new s)stem wor

simultaneousl)( As soon as t%e new s)stem is ull) approved o +eing

perect t%e old s)stem is ull) stopped(

P'!$#I% M#,'o2& !n t%is met%od t%e new s)stem is implemented in

p%ases(

Pi"o, S($,#+& !n t%is met%od, an important module o t%e old s)stem is

replaced +) t%e new one to c%ec its perormance( Graduall) t%e entire

s)stem is replaced i t%e new s)stem wors properl)(



29

USER TRAINING

An anal)sis o user training ocuses on two actors2 user capa+ilities and t%e

nature o t%e s)stem +eing installed( Users range rom native to sop%isticated

e;perts( !t involves learning %ow to use t%e newl) installed s)stem(

E"#+#%,$ o3 U$#* T*!i%i%g&

M!%/!"$ !t is ver) important to provide proper documentation to t%e

users a+out t%e s)stem( $%is manual can %elp t%em understand dierent

eatures o t%e s)stem(

D#+o%$,*!,io%$& 0ive demos are ver) important and eective means or

user training( More inormation is conve)ed t%roug% t%is met%od t%an .ust

reading(

R#$i2#%, E45#*,& $raining in t%is case is more rapid, w%ic% means a

:uicer use o t%e s)stem on regular +asis(



30

VALIDATIONS

No important ield lie t%e idno, uname must +e let +lan(

Onl) numeric data s%ould +e allowed in ields lie amount(

Onl) valid users must +e allowed to use t%e transactions(

Date"$ime must +e in a correct ormat(

Onl) te;t data s%ould +e allowed in ields lie uname(



31

FORMS

S5"!$' Fo*+



32

Logi% Fo*+



33

M!i% Fo*+



34

S,/2#%, E%,*( Fo*+



3

I%$,*/,o* E%,*( Fo*+



3!

Co/*$# E%,*( Fo*+



3"

F##$ P!(+#%, Fo*+



3#

N#6 U$#* E%,*( Fo*+



39

C'!%g# P!$$6o*2 Fo*+



40

S,/2#%, D#,!i"$ Fo*+



41

I%$,*/,o* D#,!i"$ Fo*+



42



43

Co/*$# D#,!i"$ Fo*+



44

P!(+#%, D#,!i"$ Fo*+



4

U$#*$ R#5o*,



4!

S,/2#%,$ R#5o*,



4"

I%$,*/,o* R#5o*,



4#

Co/*$#$ R#5o*,



49

P!(+#%,$ R#5o*,



0

SOURCE CODE

Fo*+1 7S5"!$'8

Private Su+ $imer1?$imer78

Progress/ar1(#alue @ Progress/ar1(#alue 4! Progress/ar1(#alue @ BB $%en

Unload Me

rmlogin(S%ow

End !

End Su+

Fo*+9 7Logi%8



1

Private Su+ 'ommand1?'lic78

s @ Cselect rom users w%ere username @ C & $e;t1($e;t & C and pass @ C &

$e;t3($e;t & CCMsg/o; s

! rs(State @ 1 $%en rs('lose

rs('ursor0ocation @ adUse'lient

rs(Open s, cn, adOpenStatic, ad0oc/atc%Optimistic

! rs(Record'ount @ 1 $%en

Msg/o; 7C0ogin SuccessulC8, v+!normation, CSuccessC

rmmain(S%ow

Unload Me

Else

Msg/o; 7CUnsuicieent Or !nvalid Entr)C8, v+'ritical, C9rong !D n PasswordC

End !

End Su+


End

End Su+

Private Su+ orm?0oad78

! cn(State @ 1 $%en cn('lose

cn('ursor0ocation @ adUse'lient

cn(Open Cprovider @ msdaora(1F user id @ scottF password@ tigerC

End Su+

Fo*+: 7M!i%8



2

Private Su+ a+out?'lic78

rma+out(S%ow

End Su+

Private Su+ '%angepassword?'lic78

rmc%angepass(S%ow

End Su+

Private Su+ 'ollectionromStudents?'lic78

rmrecpa)ment(S%ow

End Su+

Private Su+ 'ollectionlist?'lic78

rmpa)detail(S%ow

End Su+

Private Su+ coursedetails?'lic78

DataReport3(S%ow

End Su+

Private Su+ coursedetailss?'lic78

rmcouentr)(S%ow

End Su+

Private Su+ 'oursepacage?'lic78

End Su+

Private Su+ 'ourses?'lic78

DataReport3(S%ow

End Su+



3

Private Su+ 'ourseslist?'lic78

rmcoudetails(S%ow

End Su+

Private Su+ 'reateuser?'lic78

rmuserentr)(S%ow

End Su+

Private Su+ E;it?'lic78

End

End Su+

Private Su+ !nstructordetails?'lic78

rminstdetails(S%ow

End Su+

Private Su+ !nstructorlist?'lic78

rminsdetail(S%ow

End Su+

Private Su+ !nstructors?'lic78

DataReport5(S%ow

End Su+

Private Su+ 0a+el1?'lic78

End Su+

Private Su+ Pa)mentlist?'lic78

rmpa)detail(S%ow

End Su+



4

Private Su+ Pa)ments?'lic78

DataReport6(S%ow

End Su+

Private Su+ Studentdetails?'lic78

rmstuentr)(S%ow

End Su+

Private Su+ Studentlist?'lic78

rmstudetail(S%ow

End Su+

Private Su+ Studentsdetails?'lic78

End Su+

Private Su+ Students?'lic78

DataReport1(S%ow

End Su+

Private Su+ Users?'lic78

DataReport4(S%ow

End Su+

Fo*+; 7N#6 S,/2#%, E%,*(8







rs(Open Cselect rom student C, cn, adOpenStatic, ad0oc/atc%Optimistic

rs(AddNew

rs78 @ $e;t1($e;trs718 @ $e;t3($e;t

rs738 @ $e;t4($e;t

rs748 @ $e;t5($e;t

rs758 @ $e;t6($e;t

rs768 @ $e;tH($e;t

rs7H8 @ $e;tI($e;t

rs7I8 @ $e;tJ($e;t

rs7J8 @ $e;tB($e;t

rs7B8 @ D$Picer1(#alue

rs(Update/atc%

Msg/o; CRecord Saved Successull)C, v+!normation, CSavedC

End Su+


$e;t1($e;t @ 'lear

$e;t3($e;t @ 'lear

$e;t4($e;t @ 'lear

$e;t5($e;t @ 'lear

$e;t6($e;t @ 'lear

$e;tH($e;t @ 'lear$e;tI($e;t @ 'lear

$e;tJ($e;t @ 'lear

$e;tB($e;t @ 'lear

End Su+


Me(



"




cn(Open Cprovider @ msdaora(1F user id @ scottF password@ tigerCrs(Open Cselect rom users C, cn, adOpenStatic, ad0oc/atc%Optimistic

rs(AddNew

rs78 @ $e;t1($e;t

rs718 @ $e;t3($e;t

rs(Update/atc%

Msg/o; CUser !normation Saved Successull)C, v+!normation, CSavedC

End Su+


Me( 7S,/2#%, D#,!i"8

Pu+lic rs1 As New ADOD/(Recordset


s @ Cselect rom studentC


rs('ursor0ocation @ adUse'lientrs(Open s, cn, adOpenStatic, ad0oc/atc%Optimistic

Set DataGrid1(DataSource @ rs

End Su+


s @ Cselect rom student w%ere stu?id@C & 'om+o1($e;t & CC




9


s @ Cselect rom instructor w%ere inst?id@C & 'om+o1($e;t & CC

! rs(State @ 1 $%en rs('losers('ursor0ocation @ adUse'lient



End Su+


s @ Cselect rom instructorC





End Su+







rs(Open Cselect inst?id rom instructorC, cn, adOpenStatic,ad0oc/atc%Optimistic

or i @ $o rs(Record'ount - 1

'om+o1(Add!tem 7rs788

rs(MoveNe;t

Ne;t i

End Su+



!1

Fo*+10 7P!(+#%,$ D#,!i"8


s @ Cselect rom transaction w%ere +ill?no@C & 'om+o1($e;t & CC





End Su+


cn('lose

s @ Cselect rom transactionC




rs(Open s, cn, adOpenStatic, ad0oc/atc%OptimisticSet DataGrid1(DataSource @ rs

End Su+







!2



rs(Open Cselect +ill?no rom transactionC, cn, adOpenStatic,

ad0oc/atc%Optimistic

or i @ $o rs(Record'ount - 1

'om+o1(Add!tem 7rs788

rs(MoveNe;t

Ne;t i

End Su+



!3

CONCLUSION

$%is pro.ect is an automation o t%e tass t%at are +eing perormed in a

computer institute lie registration o students, aculties, receipts o students>

ees, pa)ments o salaries to aculties, etc(

$%e ollowing points are concluded a+out t%is s)stem2

!t reduces t%e time consumed signiicantl) t%at was taen in t%e

traditional manual records s)stem in e;ecuting tass suc% as t%e time in

maing manual records o students, salar) slips o aculties etc(

!t also reduces t%e cost incurred in stationer) and on sta to a great e;tent

+ecause less stationer) and sta mem+ers are re:uired to in t%e e;ecution

o t%e tass o t%e institution(

!t +ecame :uite eas) or t%e management to do inancial planning or t%e

institution as t%e s)stem eeps records o inancial activities occurring in

t%e institution(



!4

ADVANTAGES

$%is automated s)stem %as a lot o advantages over t%e old manual s)stem( $%emain advantages t%at it is providing include2

$%e new automated s)stem is totall) computeri*ed( s management to

anal)*e t%e inancial position o t%e institute(

Accesaskjduiadshyuadsjdasjhadsuygdasygvdsagdavscgfcdsagvvdsabnbdsajdsahsaddasnjuadsidshnjjkads

Documents

Transcript of Accesaskjduiadshyuadsjdasjhadsuygdasygvdsagdavscgfcdsagvvdsabnbdsajdsahsaddasnjuadsidshnjjkads