27 documents+tbl

7/21/2019 27 DOCUMENTS+TBL

1/28

TABLE OF CONTENTS

S.NO. CONTENT

1 CERTIFICATE

2 DECLARATION

3 ACKNOWLEDGMENT

4 PREFACE

5 INTRODUCTION

6 PROJECT OBJECTIVE

7 SYSTEM REQUIRMENT SPECIFICATION

INTRODUCTION TO VISUAL BASIC

! ABOUT MS"ACCESS

1# GRAP$ICAL USER INTERFACE

11 SYSTEM ANALYSIS AND DESIGN

12 DATA FLOW DIAGRAM

13 TABLE STRUCTURE

14 FORM

15 CODING

16 TESTING

17 IMPLEMENTATION

1 CONCLUSION

1! BIBLOGRAP$Y

2# GLOSSARY


2/28

CERTIFICATECERTIFICATE

-

This is to certify that this project report INSTITUTE MANAGEMENT

SYSTEM is developed by the stde!t of M"A # rd Se$ester %&'I(AI

INSTITUTE ) TE"'N)()GY* +r, ".G./0.

Ms. KADAMBINI DEWANGAN.

Mr. IMTIYAZ KHAN

This 1roject 2eport has !ot bee! sb$itted a!y 3here for a!y other

corse.

4e 3ish the$ for better ftre.

(Si,! of ')+)

Mrs. SUNITA S)NI '.).+. M"A +ept./


3/28

SELF CERTIFICATESELF CERTIFICATE

This is to certify that this 1roject 2eport I!stitte

Ma!a,e$e!t Syste$ is developed by s for the a3ard of M"A %&hilai

I!stitte )f Tech!olo,y*+r, ".G./0 co!dcted by "hhattis,arh S3a$i

5ive6a!a!d tech!ical U!iversity* +r, ".G./.

This 1roject 2eport has !ot bee! sb$itted a!y3here for a!y

other corse.

Tha!6s

Ms. 7A+AM&INI +E4ANGAN 89:;:9899;


4/28

CERTIFICATECERTIFICATE

-

This is to certify that this project report INSTITUTE MANAGEMENT

SYSTEM is developed by the stde!t of M"A # rd Se$ester %&'I(AI

INSTITUTE ) TE"'N)()GY* +r, ".G./0.

Ms. KADAMBINI DEWANGAN.

Mr. IMTIYAZ KHAN.

This 1roject 2eport has !ot bee! sb$itted a!y 3here for a!y

other corse.

4e 3ish the$ for better ftre.

(Si,! of 1roject I!char,e)

Mrs. A!y Tho$s>aclty M"A +ept./


5/28


6/28

DECLARATION

4e hereby declare that or ,rop acco$plished the project e!titled INSTITUE

MANAGEMENT SYSTEM. This 3or6 has bee! do!e ,e!i!ely by or ,rop

a!d does !ot i!volve a!y piracy a!d e?ter!al sorces of efforts.

4ithi! the dratio! 9:st@ly ;99 to :9th Nove$ber ;99 at &hilai I!stitte of

Tech!olo,y* "o$pter Applicatio! +epart$e!t. 4e shold be very tha!6fl to

Mrs. S!ita So!i '.).+ co$pter applicatio! depart$e!t/ for per$itted

orselves to do this project. This project is Sb$itted to "hattis,arh S3a$i5ive6a!a!d Tech!ical U!iversity* &hilai ".G/ for the partial >lfill$e!t of the

reBire$e!t for the certificate of M"A- Se$- IIIrd .

DECLARED BY C -

1. Imt!"# $%"&.'. K""m& D*+"&,"&.


7/28

ACKNOWLEDGEMENT

The 1roject report e!titled INSTITUTE MANAGEMENT SYSTEM

sb$itted for (Computer Application Department, Bhilai Institute of

Technology) i$proved e!viro!$e!t e?te!sive e!deavor a!d obviosly all-

!ecessary spport by or respected Mrs. S!ita So!i 2espected ')+/ 3ho

per$itted orselves to do this project.

A!d 3e did!Dt e?pect that 3e 3old $eet sch as

brillia!t* fll of pote!tial a!d e!cora,i!, perso!ality as Mrs. A!y Tho$s

1roject i!char,e/ as or project ,ide. +e to their !pardo!able efforts*

the 3or6 3as co$pleted 3ithi! the stiplated ti$e. Their efforts $ade the

soltio! for all possible !foresee! difficlties* their i!spiratio! is a !tshell*

a!d everythi!, 3as !for,ettable.

The 3or6* 3hich 3e have do!e* $ay be

acco$plished i! $ch better 3ay* as 3e believe To err is human* 3e

shold also li6e to tha!6 all the faclties a!d ')+ of &hilai I!stitte of

tech!olo,y M"A depart$e!t for their i!valable spport a!d ,ida!ce.

At the i!itial sta,e* the

e!tire project see$ed to be i$possible bt the Far came near a!d

co$pelled $e to realie the a,e-old fact that the dream of yesterday is the

hope of today and the reality of tomorrow.

W%- + *&*/t t- t 0

This project 3ill be helpfl for the i!stitte to 6eep

trac6 a!d record of their stde!ts a!d teachers 3ho are part of the i!stitte.


8/28

REFACE

A practical trai!i!, !eeded to be co$plsory i! each a!d every field i!

todayDs sce!ario. This report deals 3ith the co$$!icatio! bet3ee! a!

or,a!iatio! a!d a co$pter professio!al. It also describes abot the

services provided by the soft3are-professio!als to their csto$ers.

The 6ey objective of this report is to ,et practical e?posre overthe hard3are a!d soft3are bei!, sed !o3 i! a! or,a!iatio!. 'e!ce all the

s,,estio!s for its i$prove$e!t 3ill be appreciated.

Atte$pt has bee! $ade to prese!t the sbject i! lcid $a!!er.

Every i$porta!t sectio! is spple$e!ted 3ith 3or6ed ot e?a$ples. 4e

have freely co!slted the available $aterial of 3ell-6!o3! professio!als i!

this field. 4e ac6!o3led,e* ,rateflly the help 3e derived fro$

professio!als a!d faclties li6e Mrs. A!y Tho$s F2EA+E2- M"A

depart$e!t* &hilai i!stitte of tech!olo,y* +r, %".G0. 4e are i!debted to

pri!cipals a!d 'eads of the M"A depart$e!t for providi!, s libraryfacilities.

4e hope that the prese!t i!for$atio! 3ill also be

sefl to or j!iors a!d other discipli!es.

>i!ally 3e 3ish to e?press or si!cere tha!6s a!d appreciatio! to

Mrs. S!ita So!i %respected '.).+0 3ho have bee! a co!sta!t sorce of

e!cora,e$e!t a!d assista!ce.


9/28

INTRODUCTION

4e are $a6i!, a project for A&A"US I!stitte e!titled as INSTITUTE

MANAGEMENT SYSTEM. This project is prepared as i!strctio! ,ive! by the

ho!or of Abacs i!stitte.

E2ISTING ROBLEMS0

The follo3i!, are the proble$s 3ith the e?isti!, $a!al syste$ 3hichleads s to develop this soft3areC

:/ 1roble$ 3ith prese!t $ethodolo,y 0The prese!t syste$ of $ai!tai!i!,

the records 3ithot si!, a!y "o$pterised syste$ / is totally $a!al

3hich creates h$a! error.

;/ (ac6 of efficie!cy C +e to the $a!al 3or6 do!e.

#/ "o$ple?ityC 'a!dli!, of a lar,e data is co$ple?.

To overco$e these difficlties of the $a!al syste$ * 3e !o3 create

a "o$pteried I!for$atio! Syste$ is totally di,itied a!d it is sed for

$ai!tai!i!, the records* that records shold co!tai! Na$e of the

stde!tsHstaff * 1rpose of stayi!, i! this syste$* 1erso!al i!for$atio! a!d other

i!terrelated i!for$atio! that is related to a!y $e$ber of the i!stitte. 4e

hope that these featres are see$s to be helpfl for a!y ser.


10/28

RO3ECT OB3ECTI4E

1. K**5&, t%* r*6-rs -/ t%* st7*&ts.

'. G8* t%* st"// &/-rm"t-&.

9. S*67rt!.


11/28

SYSTEM RE:UIRMENT SECIFICATION

S5*6/6 R*;7r*m*&t0

4e are si!, 3i!do3 ?pH as operati!, syste$. >or

r!!i!, the pro,ra$ 3e !eed 5& J.9 as fro!t e!d a!d Microsoft

access as bac6 e!d.

H"r+"r* R*;7r*m*&t0

M-&t-r0< 99?J99 resoltio! at ;8J colors $i!i$$.

M*m-r! 0


12/28

INTRODUCTION TO 4ISUAL BACIC

Microsoft 5isal &asic is the fastest a!d easiest 3ay to create

applicatio!s for Microsoft 4i!do3s. 5isal &asic provides s 3ith a

co$plete set of tool to si$plify rapid applicatio! develop$e!t.

The visal part refers to the $ethods sed to create

the ,raphical ser i!terface GUI/ 2ather tha! 3riti!, !$eros li!es of

code to describe the appeara!ce a!d locatio! of i!terface ele$e!ts 3e

si$ply add pre-bilt objects i!to place o! scree!.

The basic part refers to the &ASI"&e,i!!ers All-prpose

Sy$bolic I!strctio! "ode/ la!,a,e is a la!,a,e* 3hich is i! se

to pro,ra$ by $ore pro,ra$$ers tha! other la!,a,e. I! the history of

co$pti!, 5isal &asic has evolved fro$ the ori,i!al &ASI" la!,a,e

a!d !o3 co!tai!s several h!dred state$e!ts* f!ctio!s a!d 6ey3ords*

$a!y of 3hich related directly to the 3i!do3s GUI.

The 5isal &asic pro,ra$$i!, la!,a,e is !ot !iBe to 5isal

&asic. The 5isal &asic pro,ra$$i!, syste$ Applicatio! Editio!

i!clded i! Microsoft E?cel* Microsoft Access a!d $a!y other 4i!do3s

applicatio! sed i! the sa$e la!,a,e.

+ata access featres allo3 s to create databases* >ro!t-e!d

applicatio!* a!d scalable server-side co$po!e!ts for $ost poplar

database for$ats. I!cldi!, Microsoft SL( server a!d other e!terprise-

level databases.

Active TM

tech!olo,ies allo3s s to se thef!ctio!ality provided by other applicatio!* sch as Microsoft 4ord

processor* Microsoft E?cel spreadsheet* a!d other 4i!do3s applicatio!.

4e ca! eve! ato$ate applicatio! a!d object created si!, the

professio!al or e!terprise editio!s of 5isal &asic.


13/28

IDE 0

5& provides the I+E I!te,rated +evelop$e!t E!viro!$e!t/.

The I+E is 3here yo do pro,ra$$i!, i! 5&-jst as the sa$e !a$e

s,,ests. Yo develop the I+E. It is called i!te,rated becase 3e ca! access

virtally all of the develop$e!t tools that 3e !eed fro$ o!e scree! called as

a! i!terface.

)ver the year the I+E beco$e $ore po3erfl a!d 3ith that po3er has

overco$e fro$ the co$ple?ity. The I+E sed to be $ore or less i!visible to

the pro,ra$$er bt !o3 that there are Activ co!trols to add versio!resorce object to stdy. The I+E is also co$$o!ly referred as the dsi,!

e!viro!$e!t or the pro,ra$.

The visal basic I+E has three differe!t states.

o +esi,!

o 2!

o +eb,

The I+E co$posed these co$po!e!ts.

The Me! &ar

The Tool &ar

The 1roject E?plorer

The 1roperties 4i!do3

The >or$ (ayot 4i!do3

The Tool &o?

1roject sally co!tai!s three type of ite$s.

Global ite$

>or$s

Modle


14/28

G-" It*ms

Global ite$s are accessible to all $odles a!d for$ i! a

project a!d yo declare the$ 3ith the pblic 6ey 3ord. 'o3ever Microsoft

reco$$e!ds that yo 6eep the !$ber of ,lobal ite$s to a! absolte

$i!i$$ a!d* i!fect s,,est their se o!ly 3he! yo !eed to co$$!icate

bet3ee! for$s. )!e reaso! to avoid ,lobal variables is their accessibility

fro$ a!y3here i! the pro,ra$ 3hile yo are 3or6i!, 3ith the ,lobal

variable i! o!e part of a pro,ra$* a!other part of the pro,ra$ $i,ht be bsy

cha!,i!, that variable* ,ivi!, yo !predictable reslts.

F-rms

>or$s are fa$iliar to all 5& pro,ra$$ers* of corse they are

the te$plates yo base 3i!do3s o!. &esides sta!dard for$s* 5& also

spport Mltiple +oc$e!t I!terfaceM+I/ for$s* as 3ell as 3hole !$ber

of predefi!ed for$s.

M-7*s

Modles are collectio! of code a!d data that f!ctio!

so$ethi!, li6e object i! object-orie!ted pro,ra$$i!, ))1/* bt 3ithot

defi!i!, ))1 characteristics li6e i!terface* poly$orphis$ a!d so o!. The

poi!t behi!d the pro,ra$. 4eDll discss the i$porta!ce of doi!, this later i!

this project 3he! 3e cover 5& pro,ra$$i!, tech!iBes a!d style brea6i!,a lar,e pro,ra$ i!to s$aller* self-co!tai!ed $odles ca! be i!valable for

creati!, a!d $ai!tai!i!, code.


15/28

ABOUT MS


16/28

GRAHICAL USER INTERFACE

The '$a! co$pter i!terfaces for $ost syste$ i!volve e?te!sive ,raphics*

re,ardless of applicatio!. Typically* ,e!erally syste$s !o3 co!sists of

$ose a!d pop do3! a!d pop p $e!s* ico!s a!d poi!ti!, devices* sch as

$ose or space ball* for positio! the scree! corser. I! ,raphics pac6a,es*

specialied i!teractive dialo,s are desi,! for i!dividal applicatio! sch as

e!,,. +esi,!* architectral desi,!* data visaliatio!* drafti!,* bsi!ess

,raphs a!d pai!t brsh pro,ra$.

W&-+s "& I6-&s

A 3i!do3 syste$ provides a 3i!do3 $a!a,er i!terface for the ser

a!d f!ctio! for ha!dli!, the display a!d $a!iplatio! of the 3i!do3s.

"o$$o! f!ctio! of the 3i!do3s are ope!i!, a!d closi!, 3i!do3*

repositio!i!, 3i!do3s* resii!, 3i!do3s* display roti!es that provide a!

i!terior clippi!, a!d other ,raphics f!ctio!.

C-&sst*&6!

A! i$porta!t desi,! co!sideratio! is a! i!terface co!siste!cy.

>or e?. A particlar ico! shape shold al3ays have a si!,le $ea!i!,* rather

the! servi!, to represe!t differe!t actio! or objects depe!di!, o! the

co!te?t. So$e other e?a$ple of co!siste!cy is al3ays placi!, $e!s i! the

sa$e relative positio! so that a ser does !ot have to h!t a particlar

co$bi!atio! of 6eyboard 6ey for so$e actio!.

M&m#&, M*m-r#"t-&

)peratio! i! i!terface shold also be strctred so that they are

easy to !dersta!d a!d to re$e$ber. >or e?a$ple o!e 6ey or btto! se for

all delete operatio!s is easy to re$e$ber that a !$ber of 6eys for delete

operatio!s. Ico! a!d 3i!do3s aid i! $i!i$ii!, $e$oriatio!. 4e ca!


17/28

si$ple retai! the $ltiple i!for$atio!Ds o! the scree! i! differe!t 3i!do3s

a!d s3itched bac6 a!d forth bet3ee! 3i!do3 areas.


18/28

SYSTEM ANALYSIS > DESIGN

F*"st! A&"!ss

Three 6ey co!sideratio! are i!volve i! the feasibility a!alysis C

Eco!o$ic

Tech!ical

&ehavioral

E6-&-m6 F*"st!

Eco!o$ic feasibility is sed to deter$i!e

3eather the syste$ ca! be developed 3ithi! the cost restrictio! defi!ed by

$a!a,e$e!t.

T*6%&6" F*"st!

Tech!ical feasibility decides if the hard3are

a!d soft3are co$po!e!t are available or ca! be developed if !ecessary to

co$plete the syste$ a!d 3ill be acceptable to the ser.

A&"!ss

A!alysis is the process that ,ives the syste$

a!alyst a co$plete a!d thoro,h !dersta!di!, of a syste$ that is !ecessary

prereBisite before proceedi!,.

The first step i! a!alysis is the process of data ,atheri!,. >ollo3i!, sorce$ay be sed for the collectio!.

)bservi!, E?isti!, 1rocedre

Lestio!!aires

I!tervie3s

+ata "ollectio!


19/28

SYSTEM ANALYSIS AND DESIGN 0

Syste$ a!alysis a!d desi,! are the applicatio! of the syste$

approach to proble$ solvi!,* ,e!erally si!, co$pter. To reco!strct a

syste$ the a!alyst $st co!sider its ele$e!ts* otpts a!d i!pts*

processors* co!trols* feedbac6 a!d e!viro!$e!t.

After ide!tificatio! of proble$ a!d testi!, its feasibility* 3e have

a!alyed the project closely a!d ,athered the related data fro$ co!cer!ed

people. 4e co!tacted athoried people to collect the stde!t data* sbject

details of corse a!d teachers assi,!ed for


20/28

TESTING

Syste$ testi!, is desi,!ed to !cover the 3ea6!ess* 3hich 3ere !ot fo!di! earlier tests. The syste$ testi!, 3ill be possible 3he! all the $odles are

i!te,rated a!d i$ple$e!ted by its ser i! its operatio!al e!viro!$e!t. This

i!cldes the forced syste$ failre a!d validatio! of the total syste$. The

total syste$ is also tested for recovery a!d fallbac6 after varios $ajor

failres to e!sre that !o data are lost dri!, the recover.

Unit Testing

U!it Testi!, is do!e by deb,,i!, each a!d everyco$$a!ds of the soft3are

Features To Be Tested

The featres to be tested areC-

:/.+ata shold !ot be red!da!t.

;/.+eletio! is occrri!, correctly.

#/.Updati!, of data

Approach For Testing

A very si$ple a!d strai,ht for3ard approach is sed for testi!, 3hich

i!volves the deb,,i!, of each a!d every featre of the INSTITUTE.

:/. Stored data.

;/. +eletio! a!d pdati!, of data.


21/28

IMLEMENTATION

A syste$ shold al3ays be tested thoro,hly before i$ple$e!ti!, it* as

re,ards its i!dividal pro,ra$ a!d the syste$s a 3hole. This is becase

i$ple$e!ti!, a $ajor job* 3hich reBires a lot of $a! O hors a!d other

resorces* so i!ve!t of a! error bei!, detected after i$ple$e!tatio! $ay

cost a lot. Effective testi!, early i! a process tra!slates directly i!to lo!,

ter$ cost savi!,s redci!, a !$ber of errors. This is also !ecessary

becase i! so$e cases* a s$all error before i!stallatio! $ay e?plode i!to

$ch lar,er proble$s. After a thoro,h testi!, of differe!t aspects of the

syste$ as described above* the syste$ is i$ple$e!ted. 4he! it is

i$ple$e!ted * it co$es across the real 3orld $a!ifestatio! of processi!,

f!ctio!s a!d i!for$atio! strctres.


22/28

CONCLUSION

:. This project is very $ch sefl to $ai!tai! the daily I!for$atio! of

ser i!vesti,atio!.

;. It is ser frie!dly so it is very easy to ha!dle by the ser .

#. It saves the ti$e.

K. The project also provides the secrity a!d validatio!.

8. The i!sertio!* pdati!,* deletio! a!o$alies are also easy to ha!dle.


23/28

BIBLIOGRAHY

The project e!titled INSTITUTE MANAGEMENT SYSTEM is prepared by si!,

refere!ce to the follo3i!, boo6s a!d $aterialsC

Usi!, Search e!,i!e 444. G))G(E. ")M

Syste$ A!alysis A!d +esi,!

:. Elias M A3ad;. Se!

5isal &asic

:. 5& J 1ro,ra$$i!, &lac6 &oo6 by Steve! 'ol!er .

;. Masteri!, visal basic by Eva!,elos 1etrotsos.


24/28

GLOSSARY

4s7" B"s6 0 < It s " "&,7",*? +%6% s 7s* /-r *8*&t


25/28

ADDMISSION TABEL


26/28

COUNCELLING TABEL


27/28

FEES TABEL


28/28

STAFF TABEL

27 documents+tbl

Documents