MIS PROJECT REPORT ON SCHOOL MANAGEMENT SYSTEM Submitted In Partial Fulfillment of the Requirement Of Bachelor of Business Administration 2010-2013
BATCH-(2010-2013)
PROJECT SUPERVISOR:
SUBMITTED SUBMITTE D BY:
Mrs R!"#$ s%!r&!
S!#'%$ J!$# BBA (BI)
0*+12,01+11
D.%$ I#s$/ R/r!. D.&# (DIRD)
A!"I POOA# $%"&I' 11003( )Affiliated to !uru !obind Sin*h Indra+rastha ,niersit./
DECLARATION
I hereb. declare that this Proect Re+ort titled SCHOOL MANAGEMENT SYST SYSTEM EM4 4 submitted b. me to $elhi Institute Of Rural $eelo+ment# A!"I
POOA is a Bonafide or undertaen b. me and has not been submitted to an. other ,niersit. or Institution for the aard of an. de*ree di+loma 4 certificate or +ublished an. time before5
5555555555555555555555 55555555555555555555555 5 Pr"' G/$6 )Internal/
$ate'
Si*nature of the Student
4 4 2012
DECLARATION
I hereb. declare that this Proect Re+ort titled SCHOOL MANAGEMENT SYST SYSTEM EM4 4 submitted b. me to $elhi Institute Of Rural $eelo+ment# A!"I
POOA is a Bonafide or undertaen b. me and has not been submitted to an. other ,niersit. or Institution for the aard of an. de*ree di+loma 4 certificate or +ublished an. time before5
5555555555555555555555 55555555555555555555555 5 Pr"' G/$6 )Internal/
$ate'
Si*nature of the Student
4 4 2012
AC7NO8LEDGEMENT
First of all I ill than to our director sir Dr NARENDER MOHAN4# ho *ie me the aluable su**estion for m. minor +roect5
6he success of this final re+ort is the outcome of !uidance and 7aluable su**estions +roided b. the all concerned ithout hich the re+ort could not fide on the ri*ht bac5
I e8+r e8+res esss m. sense sense of dee+ dee+ *rat *ratit itud udee to Facu Facult. lt. 9oor 9oordi dina nato tor r 9MRS 9MRS RAJNI RAJNI SHARMA: for inclusions and timel. su**estions in the +re+aration of this final
re+ort5
Finall. #I ill be failin* in m. dut.# if I do not than m. +arents# brother# friends and ell ishers for their enthusiastic su++ort and ho hae directl. or indirectl. hel+ed in some a. or the other in main* this final re+ort a success5
TABLE O CONTENTS TABLE O CONTENTS
$%9"ARA6IO A9;O<"%$!%=%6 I6RO$,96IO AB OB>%96I7%S F%SIABI"I6? S6,$? S$"9 &AR$
(1) (2) (3) (,) (*) (;) (<) (+) (=) (10) (11) (12)
S9R%%S "A?O,6 @ 9O$I! 6%S6I! F,6,R% S9OP% 9O9",SIO "I=I6A6IOS
BIB"IO!RAP&?
INTRODUCTION OBJECTIVES
INTRODUCTION 6he +roect is titled S9&OO" $ata =ana*ement S.stem5 6his +aca*e once deelo+ed ill hel+ the school4institute to mana*e arious details +ertainin* to its students5 6his ill hel+ accounts de+artment in maintainin* the details related to the fees @ basic details lie their securit. de+osits# cone.ance and etc# it ill also hel+ mana*ement or e can sa. administration de+artment in maintainin* students basic details as ell as ee+in* a chec on fees details5 6his +aca*e is basicall. deelo+ed for the authorities of the school4institute to mae their tas easier or e can sa. this +aca*e automate their tass lie maintainin* students +ersonal details# marinatin* cash details# +rintin* of recei+ts5 6his +aca*e hel+s the administratie @ accounts de+artment in maintainin* the students +ersonal @ fees related details5 6he details of the s.stem are as follos' It is basicall. a $atabase mana*ement +aca*e for the authorities of the school4institute lie mana*ement# accounts @ administratie de+artment5 All the details of the students @ the dail. or of arious de+artments are mana*ed b. the +aca*e i5e5 Personal details# 9ash details# Fees status# +rintin* of recei+ts etc5 6he +aca*e is b. the name of School4institute $ata =ana*ement Paca*e5 Paca*e hel+s the arious de+artments in maintainin* @ mani+ulatin* the data5 School4institute data are diided into Personal information# 9ash details# fee status @ etc it hel+s in mani+ulatin* the diided +arts of the data5
M6/.s % s>s&: •
Personal Information 4 Student details
•
Fees $etails
•
Fees Status
•
Re+ort !eneration
Personal Information 4 Student details' 6his module hel+s in mana*in* the +ersonal information of the students lie their ame# Address# Phone no5# Roll no @ etc5 6he +aca*e hel+s in addin* the +ersonal records# editin* the records# retrieal of records# re+ort *eneration @ etc5
Fees $etails' 6his module hel+s in mana*in* the fees details of the student lie their tuition fees# securit.# late fees @ etc5 6he basic +ur+ose behind the deelo+ment of this module is +rintin* of recei+ts of the fees +aid b. the students5 Fee Status' 6his module hel+s in mana*in* the fees records of the students lie ho man. hae +aid their fees @ ho man. are .et to +a. their fees @ hat is the recei+t no5 of the student ho hae +aid their fees5 Basicall. this module *enerates the list of all the students ho hae +aid their fees @ it also *enerates a list for those students ho haent +aid their fees5
Re+ort !eneration' 6his module is basicall. all about re+ort *enerationC in this +aca*e quite a fe re+orts are *enerated hich are embedded in the form lie student details# cash details @ etc5 Functions +erformed b. the +aca*e'
6his +aca*e hel+s in mana*in* the student information lie their ame# Roll no5 annual char*es or e can sa. +ersonal details# it also mana*es their fees details# recei+t *eneration @ etc5 6he +aca*e hel+s in addin* the official records# editin* the records# retrieal of records# re+ort *eneration @ etc5 •
Securit.' 6he +aca*e +roides securit. b. the hel+ of ,sername @ Passord# the +aca*e has been desi*ned to be used on a stand-alone s.stem @ b. s+ecific user hence there as no need for multi-user a++roach5
•
=aintenance @ =ani+ulation' 6he +aca*e hel+s in maintainin* @ mani+ulatin* information +ertainin* to students @ dail. actiities of the school4institute authorities for e5*5 maintainin* students +ersonal details# fee structures# maintainin* cash details# fees status @ etc5
•
Search' 6his facilit. hel+ in searchin* the required record from the database# +aca*e has the +roision of searchin* of the record throu*h admission no5 hich is Primar. ;e. @ throu*h the name @ class of the student5
•
&el+' 6his facilit. +roides for hel+ for the usa*e of the s.stem5 It +roides hel+ to the noice re*ardin* the usa*e of the +aca*e5
6he School4institute $ata mana*ement Paca*e +roides the user of the S.stem ith a indo lie interface5 6he Front end of the +aca*e is deelo+ed in 7B i5e5 7isual Basics# Bac end is made in =S Acce
OBJECTIVE
6he folloin* are the main obecties of the +roect titled Student data mana*emen' 6he +aca*e +roides the means of securit.# hich maes sure that onl. the concerned modules and screens are accessible to the +articular de+artment after erif.in* oneDs alidit. and all other modules and screens remains disable5 6he +aca*e is meant to maintain and +roide com+lete details about students such as +ersonal details# their fees details and cash details5 6he basic obectie of the s.stem is to mana*e the students data efficientl. @ accuratel.5 It +roides the user of the s.stem ith +ers onal details of the students their name# address# +hone @ etc# it +roides the user ith fees as ell as cash details of the students# ho much the. hae +aid# hat is the status of the fees i5e5 ho man. hae +aid fees @ ho man. are .et to +a. the fees5 It also +roides the user ith details of cash lie cone.ance details5 Student data mana*ement : +aca*e is a =ana*ement @ Information +roect# hich has these obecties' Student data mana*ement ill be hi*hl. user friendl.# mana*ement information s.stem that ill not hel+ onl. Accounts# =ana*ement @ Administratie s.stem to *ather# communicate# com+uteriEe but also hel+ to act on critical information much faster and in a better manner5 6he solution enisa*es linin* of different de+artments to streamline the flo of data and timel. aailabilit. of information at both the ends5
Further# it also aids in *eneratin*# maintainin* user definable ueries# Re+orts5 Salient Features of the a++lication ill be as defines belo' 15 Oner of data to be the oner of the database 25 9a+ture of information at the source of *eneration 35 Sharin* of data G5 =inimiEin* du+licate or H5 Reducin* inconsistenc. b. eliminatin* multi+le databases of the same data (5 9onsolidation of data at all leels O/.$#6 ?"'$s % s>s& '
,ser friendliness' 6he +aca*e deelo+ed is eas. to learn and understand5 %en a ne user can use the s.stem effectiel.# ithout an. difficult.5 6he hel+ and user manuals are +roided to sole the further queries of the users5
that the s.stem o+erates ithout haltin*5 Pro+er error handlin* codes are +ut ith the codes5 Securit. and robustness' 6he +aca*e is able to aoid or tacle disastrous action5 It allos onl. the authentic user to access the softare as it is +rotected b. the user name and the +assord5 All the administratie tass are alloed to the +roect leader onl. so the ille*al interention is not +ossible5 =odularit.' 6he +aca*e has relatiel. inde+endent and sin*le function +arts that are +ut to*ether to mae com+lete s.stem5 6hus as a result of this modular a++roach the s.stem# in s+ite of bein* robust is not cumbersome5 It also contributes for the fast e8ecution of the s.stem5 =aintainabilit.' 6he s.stem is able to decrease the time and effort for +ro*ram maintenance5 6he full details of the +roects bein* undertaen# and the tas status corres+ondin* to each student is stored carefull. and the re+orts are *enerated as +er the requirement5 6imeliness' 6he +aca*e is able to o+erate ell under normal +ea and recoer. conditions5
EASIBILITY STUDY
Feasibilit. is the test of the s.stem it hel+s in decidin* hether it is iable to *o throu*h the +roect or not5 Feasibilit. stud. studies the s.stem @ tells hether to deelo+ the s.stem or not5 In la. mans terms it can be described as the test of the s.stem @ if the s.stem +asses in the test then it is iable to deelo+ the +roect otherise not or e can sa. feasibilit. stud. checs hether +roect is feasible or not5 Feasibilit. has four solid dimensions' 15 6echnolo*. 25 Finance 35 6ime G5 Resources 6he feasibilit. of the s.stem S9&OO" $ata =ana*ement S.stem : is ieed ith the hel+ of these four dimensions5 6echnolo*.' 6his s.stem uses one of the sim+lest technolo*ies in use# for the deelo+ment +ur+ose it uses sim+le to use @ easil. aailable technolo*.5 6his s.stem is based on indos lie interface# hich is er. eas. to use5 6he +aca*e is been deelo+ed for the de+artment# hich is not er. familiar ith softare hence technolo*. used# must be easil. understandable# because of hich indos lie interface has been chosen5 6he technolo*. used in this +roect is 7B i5e5 7isual Basics (50# = S Access @ $AO controls5 7isual Basic hel+s in +roidin* indos lie enironment5 6his s.stem uses menu-based a++roach in hich eer. thin* is *ien ith the hel+ of menus5
Finance' 6his dimension measures the s.stem in res+ect to mone. or e can sa. funds5 6his dimension checs hether its iable to s+end the required amount on the s.stem or it ill be a aste5 6here is no +roblem of finance in this +roect because it uses sim+le technolo*.# hich is er. eas. to install5 6his s.stem is been deelo+ed for a standalone com+uter hence for this s.stem hardare requirement is er. lo5 For this s.stem to be deelo+ed @ installed +ro+erl. e require er. easil. aailable technolo*ies @ er. basic hardare and all these requirements doesnt cost much5 6ime' 6his +articular dimension measures the s.stems orth in res+ect to time# hich is one of the most im+ortant factors to be considered5 In this +roect time factor is er. im+ortant this s.stem is scheduled to be installed in one months time5 6his s.stem is not er. bi* @ hence can be com+leted ithin the time +eriod it requires a++ro85 30 man-da.s of or5 6ime is a crucial factor to be considered @ e can sa. this s.stem can be deelo+ed ithin the required time +eriod5 Resources' 6his dimension taes into count the recourses required to deelo+ the s.stem5 For this +articular s.stem the resources required are quite nominal hich can be fulfilled# the resources required for this s.stem are basic hardare# an o+eratin* hich is com+atible ith 7B5
SYSTEM DEVELOPMENT LIE CYCLE (SDLC)
SYSTEM DEVELOPMENT LIE CYCLE (SDLC)
S@!r E#$#r$# P!r!6$& is also referred as Softare "ife 9.cle =odel or a
Process =odel5 A softare life c.cle is a series of identifiable sta*e that a softare +roduct under*oes durin* its lifetime5 A softare +roduct deelo+ment effort usuall. starts ith a feasibilit. stud. sta*e# and then subsequentl. requirements anal.sis @ s+ecification# desi*n# codin*# testin* and maintenance are undertaen5 %ach of these sta*es is called life c.cle +hase5
•
"inear Sequential =odel ) also called classis "ife 9.cle: or the
•
Iteratie
•
Protot.+in* =odel- a++lied in the Proect Information S.stem:
•
%olutionar. =odel
•
Ra+id A++lication $eelo+ment )RA$/ =odel
•
S+iral =odel
Protot.+in* Paradi*m of Softare %n*ineerin* is a++lied in the 9om+uter Institute Information S.stem:5 6he +rotot.+in* model su**ests that before deelo+ment of the actual softare# a orin* +rotot.+e of the s.stem should be built first5
6here ere seeral reasons for deelo+in* a +rotot.+e5 An im+ortant +ur+ose as to illustrate the in+ut data formats# re+orts# and the interactie dialo*ues to the end user5 6his as a aluable mechanism for *ainin* better understandin* of the Business $eelo+ment $iisions needs5 For much functionalit. such as the !ra+hical ,ser Interfaces )!,I/ +art of s.stem# it as much easier for the user to form his o+inion b. e8+erimentin* ith a orin* model rather than ust tr.in* to ima*ine the orin* of a h.+othetical s.stem5
After *atherin* the requirements from the Business $eelo+ment $iision# a quic desi*n )Protot.+e/ as made and shoed to the &O$s of Information 6echnolo*. and Business $eelo+ment $iisions5 6he s.stem +rotot.+e built as quite close to the requirements of the Business $eelo+ment $iision5 Some additional requirements ere also added to the s.stem on the +rete8t of sli*ht increase in the earlier sco+e5 Folloin* fi*ure de+icts the Protot.+in* +aradi*m a++lied in the S9&OO" =AA!%=%6 S?S6%= :5
9odin* Im+lementation 6estin* and $esi*n Re+orts
Ste+ 1' identif. the users basic requirements At this sta*e the s.stems +erson ors ith the user to understand users basic needs and requirements as re*ards the out+ut from the s.stems5 6he s.stems +erson establishes realistic user e8+ectation# estimates the cost of deelo+in* the orin* +roto t.+e# defines data elements required and determines data aailabilit.5 Ste+2' $eelo+ the initial4
Ste+3' ,se the +roto t.+e for further refinements' 6he user alread. receied the initial +roto t.+e hich he no +uts to use5 6his orin* ith the +roto t.+e enables the user to *ain hands on e8+erience ith the +ro+osed s.stem and hel+s him to determine as to hat e8tent the +roto t.+e meets the user needs4e8+ectations4requirements5 6he user rather than s.stems +erson# decides the desired chan*es for further im+roin* the +roto t.+e5 Ste+G' Reise and enhance +roto t.+e' 6he s.stems +erson taes due notice of the chan*es su**ested b. the user and reises# enhances and refines the +roto t.+e accordin*l.5 6he +roto t.+e is then returned to the user and the +rocess follos ste+s 3 and G in an interactie mode till the +roto t.+e is finall. a++roed b. the user and become o+eratie5
Based on the feedbac# the requirements ere refined and then classical
HARD8ARE SOT8ARE REUIREMENT
HARD8ARE SOT8ARE REUIREMENT
H!r6@!r R/$r&#s:
&ardare requirement are the basic need of the s.stem or the +aca*e# hich is been deelo+ed and ill be de+lo.ed u+on the s.stem# hich should hae these basic com+onents or fulfill these basic hardare needs of these +aca*e5 6he folloin* hardare is recommended for the u ser5 =icro+rocessor :
PIIIH00 =&E5
=emor.'
12 =B S$RA= $I&=
9ache =emor.'
H12 ;B"2
,+*rade abilit.:
Processor# RA= and &$$ ,+*radeable
&$$'
J51 !B
Flo++. $rie'
2G8 9$ RO= $rie )I$%/
;e.board:
10G ;e.s %nhanced ;e.board
=ouse:
2 Button Scroll =ouse
!ra+hics:
102G8K(# 2H( colors non-interlaced on P9" "ocal Bus
=onitor :
1H: S!A 9olor monitor
S(@!r- R-/$r-&-#(s:
Softare requirement are the basic softare needs of the s.stem or the +aca*e to or +ro+erl. @ efficientl.5 O+eratin* S.stem:
R$B=S:
=S Access JK
For editin* the code of the +aca*e' +ro*ram'
7isual Basics (50
SYSTEM REBUIREMENTS SPECIICATION
A++lication
6he function and +erformance allocated to softare as +art of s.stem en*ineerin* are refined b. establishin* a com+lete information descri+tion# a detailed functional and behaioral descri+tion# an indication of +erformance requirements and desi*n constraints# a++ro+riate alidation criteria# and other data +ertinent to requirements5 6he outlines of s.stem requirement s+ecification are' I#(r6/'($#:
6his S.stem Requirement S+ecifications $ocument forms the basis for the desi*n and deelo+ment of the :Student data mana*ement:5 6he +ur+ose of this document is to define all the +rocesses inoled in the function of Student data mana*ement5 6he requirements of the softare relatin* to the functionalit.# interfaces# lo*ical database requirements and arious other as+ects of the softare are also e8+licitl. defined5 6he SRS document ill also act as the basis for understandin* beteen the end-user and the desi*ner4deelo+er5 Information $escri+tion: 6he deelo+ment of this s.stem assists in the maintenance of the information and to fulfill the com+lete softare re quirements of the +aca*e5 Functional $escri+tion' A +rocessin* narratie is +roided for each function# desi*n constraints are stated and ustified# +erformance characteristics are stated and dia*ram is included5 7alidation and 9riteria : For successful im+lementation of the s.stem e should define the +erformance bounds# and e8+ected softare res+onse5 At the time of creatin* ne entr.# s.stem +erforms different t.+es of alidations lie user can not oerrite the e8istin* information# it ass the user# this information alread. e8ist and al so man. feature5
DDS AND ER DIAGRAM
DDS
DD:
It stands for $ata flo dia*ram it is a dia*rammatic re+resentation of the data obects of the s.stem5 Basicall. $F$ is a a. to sho the ho the data is +rocessed in the s.stem# it shos ho data moes at different sta*es in the s.stem5 $F$ is a *ra+hical re+resentation that de+icts information flo @ the transformations that are a++lied as data moes from in+ut to out+ut5 It is also used to re+resent a s.stem or softare at an. leel of abstraction it can be +artitioned into leels that re+resent increasin* information flo @ functional details5
$ata Flo $ia*ram seres to +ur+oses' 15 6o +roide annunciation of ho data are transformed as the. moe throu*h the s.stem5 25 6o de+ict the functions that transforms the data flo5 $F$s are a e8cellent mechanism for communicatin* ith the customer durin* requirement anal.sis and are idel. used for the re+resentation of e8ternal and to+leel internal desi*n s+ecification5 In the latter situations# $F$s are quite aluable for subs.stem# files and data lins5 6he $F$ methodolo*. is quite effectie# es+eciall. hen the required desi*n is unclear5 In the +rocess# man. leels of $F$s are created de+endin* u+on the leel of details needed5 6he "eel 0 $F$ is also called 9onte8t "eel $F$5 It de+icts the oerie of the entire s.stem5 6he ma0or e8ternal entities# a sin*le +rocess and the out+ut stores constitute the leel-0 $F$5 6hou*h this dia*ram does not de+ict the s.stem in detail# it re+resents the oerall in+uts# +rocess and out+ut of the entire s.stem at a er. hi*h leel5 6he "eel 0 $F$ is no e8+ended into a leel 1 model5 It should be noted that information flo continuit. is maintained beteen leel 0 and leel 15 6he +rocess re+resents at $F$ leel 1 further refined into loer leels5 6his further refinement is continued until an easil. im+lement able +ro*ram com+onent is reached5
LEVEL 0 DD O
9STUDENT DATA
MANAGEMENT4
Storin* =odif.in* And Retriein* Students $ata
$etails of Students
LEVEL 1 DD O
9STUDENT DATA
MANAGEMENT4
Attempt Granted For Three Times
Access Denied
Verificatio n Of The Data
%8it
Access Granted
Addition of New Records
e =enu
MDI / Main Menu Form Shown
Re+ort
%dit =enu
Student Detai# Report
Editin of Records
Printin* Recei+t s !rintin of Fee Receipts
"ance##ation $ Reprintin of Receipts
"ash Detai#s Report i%e% fee detai#& securit'
Storin*# =ani+ulation $ata
6hese are the to $F$S i5e5 0 leel @ 1 leel of Student $ata =ana*ement : +aca*e the 1 leel dfd can be further refined to re+resent more detailed or loer leel of information5 $F$s are also non as flo *ra+h or bubble chart5
ER-DIAGRAM E#($(> F R-.!($#s%$3 D$!r!&:
$e+icts relationshi+s beteen data obects5 6he obect-relationshi+ +air can be re+resented *ra+hicall. usin* the %ntit.-Relationshi+ $ia*ram5 A set of +rimar. com+onents is identified for the %R$' data obects# attributes# relationshi+s# and arious t.+e indicators5 6he +rimar. +ur+ose of the %R$ is to re+resent data obects and their relationshi+s5 D!(! O?"-'(s A((r$?/(-s !#6 R-.!($#s%$3s
6he data model consists of three interrelated +ieces of information' the data obect# the attributes that describe the data obect# and the relationshi+s that connect data obects to one other5 $ata Obects' A data obect is a re+resentation of almost an. com+osite information that must be understood b. softare5 B. com+osite information# e mean somethin* that has a number of different +ro+erties or attributes5 A data obect enca+sulates data onl. there is no reference ithin a data obect to o+erations that act on the data5 6he data obect descri+tion incor+orates the data obect and all of its attributes5 $ata obects are related to one another5 Attributes' Attributes define the +ro+erties of a data obect and tae on one of three different characteristics5 6he. can be used to name an instance of the data obect# describe the instance# or mae reference to another instance in another table5 6he set of attribute that is a++ro+riate for a *ien data obect is determined throu*h an understandin* of the +roblem conte8t5 One or more of the attributes must be defined# as an identifier that is identifier attribute becomes a ;e.: hen e ant to find an instance of the data obect5 Relationshi+s' $ata obect are connected to one another in a ariet. of different a.s5
described in data dictionar. and their relationshi+s beteen these data obects are *ien in %R dia*ram of ne8t section5 9ardinalit. and =odalit. 9ardinalit.' 6he data model must be ca+able of re+resentin* the number of occurrences of obects in a *ien relationshi+5 6he cardinalit. of an obect-relationshi+ +air are' 15 One-to-one )1'1/' An occurrence of obect LA can relate to one and onl. one occurrence of obect LB and an occurrence of LB can relate to onl. one occurrence of LA5 25 One-to-man. )1'/' One occurrence of obect LA can relate to one or man. occurrences of obect LB but an occurrence of LB can relate to onl. one occurrence of LA5 35 =an.-to-man. )=' /' An occurrence of obect LA can relate to one or more occurrences of
LB# hile an occurrence of LB can relate to or more
occurrences of LA59ardinalit. defines the ma8imum number of obect relationshi+s that can +artici+ate in a relationshi+:5 =odalit.' 6he modalit. of a relationshi+ is Eero if there is no e8+licit need for the relationshi+ to occur or the relationshi+ is o+tional5 6he modalit. is 1 if an occurrence of the relationshi+ is mandator.5
ER-DIAGRAM O
9STUDENT DATA
MANAGEMENT4
Department maintainin records
Schoo#
=aintain records
studies ame
admission no
Student
Paca*e Oner
Student Data Manaement details !ac(ae
roll no5
consist
New Admission Modu#e
consists Build Protot.+e
Add Personal, Fees details of Students
Edit Modu#e
9onsists Edit Student Detai#s
Fee Receipt !rintin Modu#e
9onsists !rints Fee detai#s& reprintin $ cance##ation of Receipts
Report Modu#e
9onsists Students detai#s& cash detai#s $ Fee status
ILE DESIGN
$. Ds$#:
File desi*n is the desi*n of the database and it contains information about the files used in the s.stem5 In database desi*n the tables constructed# fields in the tables their data t.+es and in the other +art it tells about the e8tensions of the file used in the deelo+ment5 D!!?!s @$.. '#!$#:
15 Student' ame# Address5 Fathers name# Admission no5 $ata of Birth @ etc 25 Fee' Section# Roll no5 Admission no5 Recei+t no5 35 9lass' 9lass G5 uarter' uarter
Prr!& .$s$#s'
FieldsFI%"$ A=%
Student ame Father ame
$A6A 6?P%
6e8t 6e8t
Address $ata of Birth
6e8t $ate
9lass
6e8t
Section
6e8t
Admission no5 Roll no5
6e8t
Primar. ;e.
6e8t
Securit.
umber
9one.ance
6e8t
$ate of admission
$ate
9lass
6e8t
loc
6e8t
9oncession
umber
Annual char*e
umber
Recei+t no5
6e8t
$ate
$ate
9lass
6e8t
Admission no
umber
Roll no
umber
Section
6e8t
Primar. e.
Admission
umber
6uition
umber
"ate
umber
Absence %8am
umber umber
9om+uter
umber
=usic
umber
6otal
umber
uarter
6e8t
loc
6e8t
Securit.
umber
Annch
umber
,sername
6e8t
Passord
6e8t
uarter
6e8t
6ablesStudent
Fields
Student ame Father ame
$ata t.+es
6e8t 6e8t
Address $ata of Birth
6e8t $ate
9lass
6e8t
Section
6e8t
Admission no5 Roll no5
6e8t
Primar. ;e.
6e8t
Securit.
umber
9one.ance
6e8t
$ate of admission
$ate
9lass
6e8t
loc
6e8t
9oncession
umber
Annual char*e
umber
Fees Fields
$ata t.+es
Recei+t no5
6e8t
Student name
6e8t
Father name
6e8t
$ate
$ate
9lass
6e8t
Admission no
umber
Roll no
umber
Section
6e8t
Admission
umber
6uition
umber
"ate
umber
Absence %8am
umber umber
9om+uter
umber
=usic
umber
6otal
umber
uarter
6e8t
loc
6e8t
9one.ance
umber
Securit.
umber
Primar. e.
Annch
umber
9lass Fields
$ata t.+e
9lass
6e8t
Securit. Fields
$ata t.+e
,sername
6e8t
Passord
6e8t
uarter Fields
$ata 6.+e
uarter
6e8t
$.s Us6'
5frm
7B Forms 5r+t 5db
9r.stal Re+orts Access 4 $atabase File
MODULES IN THE PROJECT
MODULES IN THE PROJECT
STUDENTS
In 6his module there is the information about the students taen admission and stud.in* in the institute5
T!?. Sr/'/r :
stuMid
number)H/
First
archar2)10/#
last
archar2)10/#
!ender
archar2)1/#
Address
archar2)30/#
9it.
archar2)10/#
Phone
archar2)10/#
quali
archar2)10/#
fMname
archar2)20/#
dateMoin
$ate
+rimar. e.#
INSTRUCTORS
In 6his module there is the information about the instructors4 teachers teachin* the students in the institute5
T!?. Sr/'/r :
instMid
number)H/ +rimar. e.
first last *ender addres cit. +hone quali fMname dateMoin
archar2)10/ archar2)10/ archar2)1/ archar2)30/ archar2)10/ archar2)10/ archar2)10/ archar2)20/ $ate
COURSES
In this module there is the details of the courses +roided to the students b. the institute ith fee details5
T!?. Sr/'/r :
courseMid
number)H/ +rimar. e.
courseMname
7archar2)10/
fees
number)H/
duration
number)2/
USERS
6his module consist of the authoriEed user ho are +ermitted to or on the institutes softare5
T!?. Sr/'/r :
,sername
7archar2)10/ +rima. e.
Pass
7archar 2)10/
PAYMENTS
6his module *ies the details of the +a.ments done b. the students after tain* admission in institute5
T!?. Sr/'/r :
StudentMid
umber)H/
Pa.Mdate Paid amount
$ate# umber )H/#
$escri+tion
7archar2 )30/#
Bill Mno
umber )H/
IMPLEMENTATION STRATEGIES
A crucial +hase in the s.stem life c.cle of the successful im+lementation of the ne s.stem desi*n5 Im+lementation sim+l. means cone.in* a ne s.stem desi*n into o+eration5 6his inoles creatin* com+uter-com+atible files# trainin* the o+eratin* staff and installin* hardare# terminals and telecommunication netors before the s.stem is u+ and runnin*5 A critical factor in conersion is not disru+tin* the functionin* of the or*aniEation5 In s.stem im+lementation# user trainin* is crucial for minimiEin* resistance to chan*e and *iin* the ne s.stem a chance to +roe its orth5 6rainin* aids# such as user friendl.# manuals# a data dictionar.# ob +erformance aids that communicate information about the ne s.stem and hel+: screens +roide the user ith a *ood start on the ne s.stem5 6here are three t.+es of im+lementation' 15 Im+lementation of a com+uter s.stem to re+lace a manual s.stem' 6he +roblems encounter are conertin* files# trainin* users# creatin* accurate files and erif.in* +rintouts for inte*rit.5 25 Im+lementin* of a ne com+uter s.stem to re+lace an e8istin* one' 6his is usuall. a difficult conersion5 If not +ro+erl. +lanned there can be man. +roblems5 Some lar*e com+uter s.stem has taen as lon* as a .ear to conert5 35 Im+lementation of a modified a++lication to re+lace an e8istin* one usin* the same
com+uter'
6his t.+e of conersion is relatiel. eas. to handle# +roided there are no maor chan*es in the files5 9onersion means chan*in* from one s.stem to another5 6he obectie is to +ut the tested s.stem into o+eration hile holdin* costs# riss# and +ersonnel irritation to a minimum5 It inoles N 9reatin* com+uter com+atible files
6rainin* the o+eratin* staff Installin* terminals and hardare5 A critical as+ect of conersion is not disru+tin* the function of the or*aniEation5 Seeral +rocedures and documents are unique to the conersion +hase5 9onersion be*ins ith a reie of the +roect +lant# the s.stem test documentation# and the im+lementation +lan5 6he +arties inoled are the user# the +roect team# +ro*rammers# and o+erators 6he conersion +ortion of the im+lementation +lan is finaliEed and a++roed5 15 Files are conerted5 25 Parallel +rocessin* beteen the e8istin* and the ne s.stems is initiated5 35 Parallel +rocessin* beteen the e8istin* and the ne s.stems is initiated5 G5 Results of com+uter runs and o+eration for the ne s.stem are lo**ed on a s+ecial form H5 Assumin* no +roblems# +arallel +rocessin* is discontinued5 Im+lementation results are documented for reference5
9onersion is com+leted5 Plans for the +ost-im+lementation reie are +re+ared5 Folloin* the reie# the ne s.stem is officiall. o+erational5 File conersion inoles ca+turin* data and creatin* a com+uter file from e8istin* files5 9o+.in* the old: files intact for the ne s.stem is the +rime concern durin* conersion5 6he +ro*rams that co+. the files should +roduce identical files to test +ro*rams on both s.stems5 At the outset# a decision is made to determine hich files need co+.in*5 Personnel files must be e+t of course# but an account receiable file
ith man. actiities mi*ht not need co+. in5 Instead# ne customer accounts mi*ht be +ut on the ne s.stem# hile runnin* out the old accounts on the old s.stem5 Once it is determined that a +articular file should be transferred# the ne8t ste+ is to s+ecif. the data to be conerted# current file# .ear-end files# and son on5 6hen files to be co+ied must be identified b. name# the +ro*rammer ho ill do the co+.in*# and the methods b. hich the accurac. of the co+.in* ill be erified5 A file-com+arison +ro*ram is best used for this +ur+ose5
SCREEN LAYOUTS AND CODINGS
SALIENT EATURES O THE SYSTEM
S!.$# !/rs'
1
Reduce com+le8it. throu*h automation5
2
,ser-friendl. enironment to o+erate on5
3
9om+atible to all +latforms5
G
Im+roe Administration de+artments efficienc.
H
%8chan*e of data beteen different de+artments5
(
Im+roe =ana*ement re+ortin*# maintainin* ca+abilities5
15 %nhance ,sers satisfaction and +roductiit.
SECURITY:
1 2
Sin*le indo for entire a++lication5 =odule ise accessibilit.5
CODING
C6$#'
6his section contains codin* of the s.stem Student data mana*ement :5
S.!s%'
6his is the o+enin* screen of the +aca*e# user has to clic O to moe forard or close the +aca*e5
C6'
Priate Sub 9ommand1M9lic )/
frm+assord5Sho =e5&ide %nd Sub
L$# r&'
It as user to enter the ,ser name @ Passord# if he enter it correctl. access is *ranted else he is *ien three chances to enter the correct ,sername @ Passord# if he fail then s.stem is shutdon5
C6:
Priate Sub 9ommand1M9lic)/ If 6e8t2 6hen
=s*Bo8 Please enter the Passord PassordM6e8t5SetFocus %8it Sub
%nd If If fla* 3 6hen
If 6e8t2 dee+a 6hen
=$IForm15Sho frm+assord5&ide
%lse =s*Bo8 )Incorrect Passord/
fla* fla* Q 1
%nd If
%lse
=s*Bo8 ) Intruder $etected / %nd
%nd If
%nd Sub
Priate Sub 9ommand2M9lic)/
%nd
%nd Sub
Priate Sub FormM"oad)/
$im fla* As Inte*er 6e8t1 Administrator 6e8t15"oced 6rue fla* 1 %nd Sub MDI r&:
6his is first form after the access is *ranted to the user# it shos the menus that are aailable to the user5
C6:
O+tion %8+licit DPublic db As $atabase DPublic s As
Priate Sub =$IFormM"oad)/ Set s $B%n*ine5
Priate Sub 6oolbar1MButton9lic)B.7 6oolbar1MButton9lic)B.7al al Button As 9omctl"ib5Button/ Select 9ase Button5e. 9ase e
frmneadmission5Sho 9ase %dit
frmstuedit5Sho 9ase Fee
Fee5Sho 9ase $el
frmRec$el5Sho 9ase Re+rint
frm+rint5Sho 9ase $etails
frm$etails5Sho 9ase 9ash
frmcash5Sho 9ase FeeS
frmFStatus5Sho 9ase close %nd
%nd Select %nd Sub
@ S'r# S%s:
N@ A6&$ss$# A6&$ss$# r&
E6$ r&
6!$.
S/6# D!$. Rr
6!$. rr
C#>!#' D!$. Rr
S'/r$> D!$. Rr
S!/s rr
C6$#:
N@ A6&$ss$#-
O+tion %8+licit $im cl As Recordset
Dused for class table
$im stdnt As Recordset
Dused for student table
$im match As Recordset $im i# # As Inte*er Public e. As Boolean DPublic edite. As Boolean $im a# b As Strin*
Priate Sub 9hconM9lic)/ If chcon5alue 1 6hen t8tfrom5%nabled 6rue t8tfrom5SetFocus %lse t8tfrom5%nabled False t8tfrom56e8t %nd If %nd Sub
Priate Sub cmdclearM9lic)/ clear Dcall clear +rocedure %nd Sub
Priate Sub cmdcloseM9lic)/ If e. 6rue 6hen stdnt59ancel,+date e. False %nd If stdnt59lose Dclose the student table recordset ,nload =e %nd Sub
DPriate Sub 9mdeditM9lic)/ Denable DIf nee. 6rue 6hen D nee. False D%nd If Dedite. 6rue Dt8tadmnno5SetFocus D%nd Sub
Priate Sub cmdneM9lic)/ If e. 6rue 6hen %8it Sub %lse stdnt5Adde e. 6rue 68tadmnno5SetFocus %nd If %nd Sub
Priate Sub cmdoM9lic)/ If e. 6rue 6hen If 68tadmnno56e8t Or t8tdoa56e8t Or t8tsname56e8t Or M t8tdob56e8t Or t8tfname56e8t Or t8taddr56e8t Or cboclass56e8t Or M t8tsec56e8t Or t8trollno56e8t 6hen i =s*Bo8)%6%R PROP%R $%6AI"S# bO;Onl.# S6,$%6/ %8it Sub %nd If i Format)t8tdoa56e8t# ..../ Format)t8tdob56e8t# ..../ If i 6hen
=s*Bo8)$ate of Birth canDt be *reater than or equal to $ate of Admission# bO;Onl.# S6,$%6 $%6AI"S/ t8tdob5SetFocus %8it Sub %nd If If chcon5alue 1 And t8tfrom56e8t 6hen i =s*Bo8)P"%AS% %6%R 6&% "O9A6IO# bO;Onl.# S6,$%6 $%6AI"S/ t8tfrom5SetFocus %8it Sub %nd If If t8tsecurit.56e8t 6hen t8tsecurit.56e8t 0 If t8tannch56e8t 6hen t8tannch56e8t 0 a Ri*ht)68tadmnno56e8t# 1/ If a S And ot )cboclass56e8t 6<%"F6& Or cboclass56e8t %"%7%6&/ 6hen i =s*Bo8)9"ASS O6 9O=PA6IB"%
cboclass5SetFocus %8it Sub %lseIf a & And ot )cboclass56e8t 6%6& Or cboclass56e8t
I6&/ 6hen i =s*Bo8)9"ASS O6 9O=PA6IB"%
cboclass5SetFocus
%8it Sub %lseIf a = And ot )cboclass56e8t SI6& Or cboclass56e8t S%7%6& Or cboclass56e8t %I!&6&/ 6hen i =s*Bo8)9"ASS O6 9O=PA6IB"%
cboclass5SetFocus %8it Sub %lseIf a P And ot )cboclass56e8t FIRS6 Or cboclass56e8t S%9O$
Or cboclass56e8t 6&IR$ Or cboclass56e8t FO,R6& Or cboclass56e8t FIF6&/ 6hen i =s*Bo8)9"ASS O6 9O=PA6IB"%
cboclass5SetFocus %8it Sub %lseIf a " And ot )cboclass56e8t ,RS%R? Or cboclass56e8t
";!/ 6hen i =s*Bo8)9"ASS O6 9O=PA6IB"%
cboclass5SetFocus %8it Sub %nd If b select T from student here admnno D @ 68tadmnno56e8t @ DC Set match db5O+enRecordset)b# dbReadOnl./ If match5Record9ount U 1 6hen
i =s*Bo8)6&IS A$=ISSIO ,=B%R A"R%A$? %IS6S5 9AD6 IS%R6 6
68tadmnno5SetFocus %8it Sub %nd If
match59lose b select T from student here rollno @ t8trollno56e8t @ and class D @ cboclass56e8t @ D and sec D @ t8tsec56e8t @ DC Set match db5O+enRecordset)b# dbReadOnl./ If match5Record9ount U 1 6hen i =s*Bo8)6&IS RO"" ,=B%R A"R%A$? %IS65 IS%R6 AO6&%R5# bO;Onl.# %< A$=ISSIO/ t8trollno5SetFocus %8it Sub %nd If commit stdnt5,+date e. False clear %nd If D%lseIf edite. 6rue 6hen D t8tadmnno5%nabled 6rue D If 68tdoa56e8t Or t8tsname56e8t Or M
D
68tdob56e8t Or t8tfname56e8t Or 68taddr56e8t Or
9boclass56e8t Or M D
t8tsec56e8t Or t8trollno56e8t 6hen
D
i =s*Bo8)%6%R PROP%R $%6AI"S# bO;Onl.# S6,$%6/
D
%8it Sub
D %nd If D i Format)68tdoa56e8t# ..../ D Format)68tdob56e8t# ..../ D If i 6hen D
=s*Bo8)$ate of Birth canDt be *reater than or equal to $ate of
Admission# bO;Onl.# S6,$%6 $%6AI"S/ D
68tdob5SetFocus
D
%8it Sub
D %nd If D If 9hcon5alue 1 And 68tfrom56e8t 6hen D
i =s*Bo8)P"%AS% %6%R 6&% "O9A6IO# bO;Onl.# S6,$%6
$%6AI"S/ D
68tfrom5SetFocus
D
%8it Sub
D %nd If D If t8tsecurit.56e8t 6hen t8tsecurit.56e8t 0 D stdnt5%dit D commit D stdnt5,+date
D edite. False D clear D disable D%lse D %8it Sub %nd Sub
Priate Sub FormM"oad)/ =e56o+ 0 =e5"eft 0 clas D "oad the combo bo8 ith the class names Set stdnt db5O+enRecordset)student# dbO+en$.naset/ stdnt5Adde e. 6rue t8tfrom5%nabled False %nd Sub
Public Sub clas)/ Set cl db5O+enRecordset)class# dbReadOnl./ cl5=oe"ast i cl5Record9ount cl5=oeFirst For 1 6o i
cboclass5AddItem clVclass cl5=oee8t e8t cl59lose %nd Sub
Priate Sub commit)/ stdntVAdmnno 68tadmnno56e8t stdntVdoa Format)t8tdoa56e8t# dd4mm4..../ stdntVsname t8tsname56e8t stdntVdob Format)t8tdob56e8t# dd4mm4..../ stdntVfname t8tfname56e8t stdntVAddr t8taddr56e8t stdntVclass cboclass56e8t stdntVsec t8tsec56e8t stdntVrollno t8trollno56e8t stdntVsecurit. t8tsecurit.56e8t stdntV9on chcon5alue stdntV"oc t8tfrom56e8t stdntVannch t8tannch56e8t %nd Sub
Priate Sub clear)/
68tadmnno56e8t t8tdoa56e8t t8tsname56e8t t8tdob56e8t t8tfname56e8t t8taddr56e8t cboclass56e8t t8tsec56e8t t8trollno56e8t t8tsecurit.56e8t chcon5alue False t8tfrom56e8t t8tannch56e8t %nd Sub
Priate Sub 68taddrM;e.Press);e.Ascii As Inte*er/ ;e.Ascii Asc),9ase)9hr);e.Ascii/// %nd Sub
Priate Sub 68tadmnnoM;e.Press);e.Ascii As Inte*er/ $im str As Strin* str 0123GH(KJAB9$%F!&I>;"=OPRS6,7<?W ;e.Ascii Asc),9ase)9hr);e.Ascii///
If ;e.Ascii U 2( 6hen If InStr)str# 9hr);e.Ascii// 0 6hen ;e.Ascii 0 %nd If %nd If %nd Sub
Priate Sub t8tannchM;e.Press);e.Ascii As Inte*er/ $im str As Strin* str 0123GH(KJ If ;e.Ascii U 2( 6hen If InStr)str# 9hr);e.Ascii// 0 6hen ;e.Ascii 0 %nd If %nd If %nd Sub
DPriate Sub t8tadmnnoM"ostFocus)/ DIf edite. 6rue 6hen D If ot )t8tadmnno56e8t / 6hen D
finddata
D %nd If D%nd If
D%nd 5Action 1 %nd
For i 1 6o totrec
%lse 56e8t=atri8)i# 11/ %nd If %nd
rs5=oee8t e8t %nd If %nd Sub
Priate Sub FormM"oad)/ =e56o+ 0 =e5"eft 0 class %nd Sub
Priate Sub class)/ Set cla db5O+enRecordset)class# dbReadOnl./ cla5=oe"ast totrec cla5Record9ount cla5=oeFirst For i 1 6o totrec cboclass5AddItem claVclass cla5=oee8t e8t cla59lose %nd Sub
Priate Sub t8tsecM;e.Press);e.Ascii As Inte*er/ $im str As Strin* str AB9$%F!&I>;"=OPRS6,7<?W ;e.Ascii Asc),9ase)9hr);e.Ascii///
If ;e.Ascii U 2( 6hen If InStr)str# 9hr);e.Ascii// 0 6hen ;e.Ascii 0 %nd If
TESTING TEST RESULTS
TESTING
Ts$#:
6estin* is the +rocess of e8ecutin* the +ro*rams ith the intention of findin* out errors5 $urin* testin*# the +ro*ram to be tested is e8ecuted ith a set of test cases and the out+ut of the +ro*rams for the test case is ealuated to determine if the +ro*ram is +erformin*
as
it
is
e8+ected
to
be5
As the softare is created and added to the deelo+in* s.stem# testin* is +erformed to ensure that it is orin* correctl. and efficientl.5 6estin* is *enerall. focused on to areas# internal efficienc. and e8ternal effectieness5 6he *oal of e8ternal effectieness testin* is to erif. that the softare is functionin* accordin* to s.stem desi*n# and that it is +erformin* all the required functions5 6he *oal of internal testin* is to mae sure that the com+uter code is efficient# standardiEed# and ell documented5 6estin* can be a labor-intensie +rocess due to its iteratie nature5 Ts P.!#:
,nit
6estin*5
Inte*ration 7alidation S.stem
6estin*5
6estin*5
6estin*5
6hese different leels of testin* attem+t to detect different t.+es of faults5 6he relations of faults introduced in different leels of testin* are as shon belo Re)uirements
S'stem testin
9lients eeds
7alidation 6estin*
$esi*n
Inte*ration 6estin*
"ode
*nit Testin
L-2-.s T-s($#
U#$( T-s($#:
6he first leel of testin* is called unit testin*5 In this# different modules are tested a*ainst the s+ecifications +roduced durin* desi*n for the modules5 ,nit testin* is essential for -erification of the code +roduced durin* the codin* +hase# and the *oal is set to test the internal lo*ic of the modules5
I#(-r!($# T-s($#:
6he ne8t leel of testin* is often called the inte*ration testin*5 In this man. tested modules are combined into subs.stems# hich are then tested5 6he *oal here is to see if the modules can be inte*rated +ro+erl.# the em+hasis bein* on testin* interfaces beteen modules5 6his testin* actiit. can be considered as testin* desi*n and hence the em+hasis on testin* interactions5
V!.$6!($# T-s($#:
$urin* alidation testin*# the s.stem is used e8+erimentall. to ensure that the softare does not fail# i5e5 2ill run accordin* to its s+ecifications and in the 2a. users acce+ts# s+ecial test data in+ut for +rocessin*# and the results e8amined5 A limited number of users ma. be alloed to use the s.stem so anal.sts can see hether the. tr. to use it in unforeseen a.s5 S.stem alidation checs the qualit. of the softare in both simulated and lie enironments5 First the softare *oes throu*h a +hase in hich error and failures based on simulated user requirements are erified and studied# called al+ha testin*5 6he
modified softare is then subected to +hase to in the actual users site or a lie enironment# called beta testin*5
S>s(-& T-s($#:
A series of different tests hose function is to erif. that all s.stem elements hae been +ro+erl. inte*rated and +erform allocated functions5
T-s($# 9S(/6-#( D!(! M!#!-&-#( 4:
In case of Student data mana*ement +aca*e# I +erformed unit testin* to each indiidual function to see that hether the. are orin* +ro+erl. or not5
Fe sam+les of unit testin* are e8+lained ith the hel+ of screen out+uts5 ,nit testin* is basicall. testin* the modules ith the dumm. data5
If Admission no is not in the data+ase messae wi## +e prompted% No record found%
If search button is +ressed before enterin* the name it ill as for the field5
USER MANUAL
A?/ % S>s&:
It is basicall. a $atabase mana*ement +aca*e for the authorities of school4institute that maintains students data5 All the details of student are mana*ed b. the +aca*e i5e5 Personal details# Fees details# Re+orts @ etc5 6he +aca*e is b. the name of Student $ata =ana*ement Paca*e5 Paca*e hel+s the arious de+artments in maintainin* @ mani+ulatin* the data5 Student data are diided into Personal information# Fees $etails# Recei+t +rintin* @ etc it hel+s in mani+ulatin* the diided +arts of the data5 6his s.stem is for the de+artment maintainin* student records5
P.!r&:
6his s.stem is +latform inde+endent# it ill or on an. +latform5 O+eratin* s.stem recommended for this s.stem is
H@ /s $
Student $ata =ana*ement +aca*e has a er. user friendl. enironment @ its interfaces are similar to indos# so it ill not tae time for the user to *et acquainted ith the s.stem# there are fe thin*s that should be e+t in mind before usin* the s.stem those +oints are e8+lained ith the hel+ of screen out+uts5 6his Paca*e is deelo+ed for stand-alone s.stem# hence for lo**in* on the s.stem user must no the ,sername @ Passord5 After choosin* from the menus the s+ecific o+tions fe thin*s has to be e+t in mind hich are e8+lained belo5
A66$$# r'r6s '
For addin record first fi## up the form after that c#ic( on o(
For fi##in up another students data c#ic( new then enter detai#s %
E6$$# R'r6s:
UTURE SCOPE O THE SYSTEM
Sco+e of the s.stem measures the sco+e of the +roect# hich is *oin* to be deelo+ed5 Anserin* folloin* as+ects can anser the +roect sco+e'
15 9onte8t 25 Information obectie 35 Function @ Performance G5 Interfaces
6he s.stem S9&OO" data mana*ement s.stem: is a data mana*ement of students5 All the details of the students are mana*ed ith the hel+ of this +aca*e i5e5 their Personal information# fees information @ their re+ort *eneration# ith the hel+ of this +aca*e the or*aniEation can maintain @ mani+ulate students data5 6his +aca*e has the +roision for addin* ne records# editin* old records# iein* the database# searchin* facilit.# re+ort *eneration# hel+ i5e5 ho to use the +aca*e @ etc5 Sco+e of the s.stem can be measured ith the hel+ of the dimensions5 9onte8t' 6his
+roect
is
related
to
mana*ement of students data and the dail. actiities of the authorities ith the hel+ of this +aca*e the user of this +aca*e# hich is the de+artment i5e5 administratie ill be able to maintain the data throu*h the com+uter hich ill hel+ in increasin* he efficienc.# accurac. of the de+artment as ell as hel+ in electronic inter chan*e of the data5 Administratie de+artment can use this +aca*e to chec for the details of the students# hether the. hae +aid their fees amount or hether it is due to them# throu*h hich recei+t no5 it as +aid the. can stud. the +ast records anal.Ee the trends5 Information obectie' Basicall. this is related to the In+uts @ Out+uts to the s.stem5 In other a. e can sa. it is related to the in+uts required b. the s.stem @ out+uts *enerated b. the s.stem5 6his +aca*e is basicall. data mana*ement +aca*e# in hich the in+uts *ien b. the user is itself the out+ut of s.stem it +erforms fe calculation lie the total cash receied from the students5
15 In+uts' 6he in+ut to the s.stem is username @ +assord for the s.stem securit.# their Personal details lie ame# Address# Phone number# admission details# roll no for data mana*ement# their fees details lie admission fees# tuition# com+uter fee @ etc 5 25 Out+uts' 6he out+ut for this s.stem is the maintained records# +ersonal details# fees details# fee status @ re+ort *enerated5 6he out+uts of the s.stem are the records that ere added in the database as ell as the re+orts that are *enerated ith the hel+ of he data in the database5
Function @ Performance' 6his dimension measures the sco+e of the s.stem ith the hel+ of functions @ +erformance of the s.stem5 6he basic function +erformed b. the s.stem is of data mana*ement @ re+ort *eneration5 6he s.stem +erforms arious functions lie' 15 Securit.' 6he first function of the s.stem is to +roide securit. from unauthoriEed access to the data# hich is +roided ith the hel+ of user name @ +assord at the be*innin* of the +aca*e5 6his s.stem is been deelo+ed for a sin*le user hence no ri*hts are em+lo.ed or e can sa. administrator is onl. the user5 25 $ata maintenance' 6he most im+ortant function of the s.stem is to maintain student data# the data is maintained ith the hel+ of different menus lie addin*# editin*# iein*# searchin* @ etc5 6here are different inds of data in the s.stem lie +ersonal information# fees information @ cash details ith the hel+ of the front end data is mana*ed5
35 Re+ort *eneration' 6he last function of the s.stem is to *enerate re+orts of the data lie student details re+ort# cash re+ort# fee status re+ort @ etc5
RESULTS CONCLUSION
LIMITATION O THE SYSTEM
L$&$!$#s % s>s& !#6 //r 6.&# !r!s :
"imitation of an. s.stem is difference beteen the required s.stem @ the deelo+ed s.stem' 15 It is deelo+ed for onl. stand-alone P95 25 6his s.stem is quite eas. to use this is not its limitation but its restrictie features are its limitation5 35 6he bac end used in the s.stem is = S Access# hich is not an R$B=S5 G5 6he s.stem does not su++ort multi+le users5 H5 6here are fe thin*s# hich should be e+t in mind hile usin* the s.stem5
BIBLIOGRAPHY 6he folloin* boos4 documents ere used in main* of this s.stem' •
7isual Basic ( ,nleashed b. Rob 6ha.er )SA=S Publication/
•
7isual Basic (' Blac Boo b. Stee &olEner )9oriolis !rou+ Boos/
•
S"# P"4S" b. Ian Ba.ross )BPB Publication/
•
Softare %n*ineerin* b. ;5;5 A**raal and ?o*esh Sin*h )e A*e International Pt5 "td5/5
•
A fe notes from *oo*le5com5
•
Sahoo Reeta# Be*inners !uide to 7isual Basic# K th reised edition# BPB Publications5
•
•
Petroutous# =asterin* in 7B (50# BPB Publications5
•
Pressman S Ro*er Practitioners A++roach to Softare %n*ineerin*# 6=& Publication5
•
Bradle.# =ills+au*h# Pro*rammin* in 7isual Basic (50# 6=& Publication5