Govt. Degree College for Women Haroonabad
IN THE NAME OF
ALLAH THE MOST MERCIFUL THE MOST BENEFICENT
Hos Ho stel Ma Management Sys Systtem
Page 1
Govt. Degree College for Women Haroonabad
I DEDICATE MY PROJECT
TO MY LOVING PARENTS
BROTHERS, SISTERS
AND
TO MY WONDERFUL TEACHER
MANY PRAY PRAYERS ERS
AND
A LOT OF WISHES FOR THEM
Hos Ho stel Ma Management Sys Systtem
Page 2
Govt. Degree College for Women Haroonabad
I DEDICATE MY PROJECT
TO MY LOVING PARENTS
BROTHERS, SISTERS
AND
TO MY WONDERFUL TEACHER
MANY PRAY PRAYERS ERS
AND
A LOT OF WISHES FOR THEM
Hos Ho stel Ma Management Sys Systtem
Page 2
Govt. Degree College for Women Haroonabad
Project Tite
!
Hostel Management System
U"#ert$%e" &'
!
Kiran Shahzadi, Tahira Parveen, Sana Shahid, Shumaila Kousar
S()er*i+e# &'
!
Miss. Rafia Aslam
St$rti" D$te
!
0101!01"
Co-)etio" D$te
!
0#0#!01"
D$t$&$+e U+e#
!
MS A$$ess
O)er$ti" S'+te-
!
%indo&s '
S'+te- U+e#
!
(ntel1, " )Hz
P$c%$e U+e#
!
MS %ord
Fro"t E"#
!
MS A$$ess
B$c% E"#
!
MS A$$ess
Hos Ho stel Ma Management Sys Systtem
Page 3
Govt. Degree College for Women Haroonabad
ACKNOWLEDGEMENT %e are grateful to almighty Allah the most gra$ious, mer$iful and *enefi$ent &ho hel+ us in every field of life. y &hose gra$e &e have *een a*le to $om+lete this Pro-e$t su$$essfully. %e e+ress over gratitude and o*ligation to Mi++ R$.i$ A+$- /Lect(rer Go*t0 Deree Coee .or Wo-e" H$roo"$&$#1 &ho did her selfless and tireless efforts for +roviding us all fa$ilities throughout this Pro-e$t. %e feel great honor to e+ress over sin$ere and $ordial than/s to res+e$ted Mi++ R$.i$ A+$- for her invalua*le guidan$e, sym+atheti$ attitude, meti$ulous training, healthy $riti$ism, dee+ $on$ern and strong motivation regarding to over +ro*lems that &e have fa$ed not only during Pro-e$t *ut also throughout the session. She guided us in $riti$al times and hel+ed us &hen ever needed. %e feel +roud to *e daughter to over +arents, &hose $onsideration *oosts over moral to get the edu$ation &e are mu$h than/ful to over friends, &hole $oo+eration hel+ us a lot.
Hostel Management System
Page 4
Govt. Degree College for Women Haroonabad
PREFACE om+uterization of 2HOSTEL MANAGEMENT SYSTEM3 is a system that +rovides ui$/ and $orre$t information a*out the &or/ing s$enario of the Hostel.
Hostel Management System
Page 5
Govt. Degree College for Women Haroonabad
To)ic C4$)ter 5 6 I"tro#(ctio" to )roject 606
I"tro#(ctio" to )roject
C4$)ter 5 7 De*eo)-e"t /SDLC1 706
S'+te- De*eo)-e"t Li.e C'ce
70606
Prei-i"$r' I"*e+ti$tio"
70607
S'+te- A"$'+i+
70608
S'+te- De+i"
70609
Co#i"
7060:
Te+ti"
7060;
I-)e-e"t$tio"
7060<
M$i"te"$"ce
C4$)ter 5 8 Nor-$i=$tio" St$e+ o. Nor-$i=$tio" A"o-$ie+ o. St$e+
T$&e+ Fee T$&e Ho+te E"tr' T$&e St(#e"t+ Atte"#$"ce T$&e St(#e"t+ Recor#+ T$&e
Hostel Management System
Page 6
Govt. Degree College for Women Haroonabad
For-+ Fee ForHo+te E"tr' ForSt(#e"t+ Atte"#$"ce ForSt(#e"t+ Recor#+ ForM$i" For-
Re)ort+ Fee Re)ort Ho+te E"tr' Re)ort St(#e"t+ Atte"#$"ce Re)ort
C4$)ter 5 9 >(erie+ ? Re$tio"
C4$)ter 5 : Co"c(+io"
Hostel Management System
Page
Govt. Degree College for Women Haroonabad
CHAPTER 5 6 INTRODUCTION TO PROJECT OR SYSTEM
INTRODUCTION TO PROJECT 2ur +ro-e$t is a*out Ho+te M$"$e-e"t S'+te-. (n this +ro-e$t &e $on$ern the +ossi*le solution to develo+ the Ho+te M$"$e-e"t +'+te-. (n this +ro-e$t &e dis$uss a*out three entities related to Ho+te M$"$e-e"t +'+te-. These entities
Hostel Management System
Page !
Govt. Degree College for Women Haroonabad are Students, 3ee and Attendan$e. The ta*les a*out these entities sho&s the attri*utes, &hi$h &e used to store the re$ord of these entities. (n the *eginning Ho+te M$"$e-e"t +'+te- &as *ased on manual system. ut no& it is develo+ed in $om+uterized data*ase system &hi$h has many advantages.
Hostel Management System
Page "
Govt. Degree College for Women Haroonabad
CHAPTER 5 7 DEVELOPMENT (SDLC)
706 System Devel!me"t L#$e Cy%le
SDLC stand for 2S'+te- De*eo)-e"t Li.e C'ce3 it is an organize &ay to develo+ing su$$essful system.
Hostel Management System
Page 1#
Govt. Degree College for Women Haroonabad 4A set of a$tivities or ste+ that is reuired to develo+ a ne& system and re+la$e an eisting system is $alled 2S'+te- De*eo)-e"t Li.e C'ce3 S56 $onsist of different +hases. These +hases are as follo&s7 •
Preliminary (nvestigation
•
System Analysis
•
System 5esign
•
System oding
•
System Testing
•
System (m+lementation
•
System Maintenan$e
70606 P&el#m#"'&y I"vest#'t#" (n this +hase, the system is investigated. The o*-e$t of this +hase is to $ondu$t an initial and finding of the system as follo&s7 •
System (dentifi$ation
•
System S$o+e
•
•
Alternate Solution Preliminary Plan
*+* System A"'lys#s (n this +hase the $urrent system is studied in detailed to find out ho& the $urrent system is &or/ and ho& to im+rove it.
70608 System Des#" System design +hase is used to design the logi$al model and +hysi$al model of ne& system.
Hostel Management System
Page 11
Govt. Degree College for Women Haroonabad
*+*, System C-#" (n this system the a$tual system is develo+ed. (t $onsists of &riter segment and +rogram. This +hase reuires a lot f time, effort and *udget to develo+ the $om+lete system. Single +rogrammer of a team of +rogrammers develo+s the system using different tools.
*+*. System Test#" om+lete testing of the system is very im+ortant. (t is essential to dete$t errors and +ro*lem *efore using the system.
7060; Im!leme"t't#" A system $an *e im+lemented after it has *een tested it is also /no&n as system $onversion. (t $an *e +erformed in any of the follo&ing &ay. •
Parallel (m+lementation
•
Pilot (m+lementation
•
Phased (m+lementation
•
5ire$t (m+lementation
*+*/ M'#"te"'"%e The system may *e$ome less useful if any $hange o$$urs in user environment. The a$tivity of system maintenan$e may vary de+ending on the s$ale of modifi$ation and enhan$ements.
Hostel Management System
Page 12
Govt. Degree College for Women Haroonabad
CHAPTER 8 8 NORMALI0ATION
N&m'l#1't#"23 The +ro$ess if +rodu$ing a sim+ler and more relia*le data*ase stru$ture is $alled normalization. (t is used to $reate a suita*le set of relation for storing data.
Hostel Management System
Page 13
Govt. Degree College for Women Haroonabad
Use $ N&m'l#1't#"23 9ormalization is a++lied in follo&ing situations7 •
%hen data is large and s$attered.
•
%hen there is no defined grou+ of data.
•
%hen data is too $om+li$ated and redundant .
C4'&'%test#%s $ N&m'l#1e- D't'5'se23 A normalized data *ase should have follo&ing $hara$teristi$s7 •
•
:a$h relation must have a /ey field. All fields must $ontain atomi$ data.
•
There must minimum re+eating field.
•
:a$h ta*le must $ontain information a*out a single entity
•
:a$h field in a relation must de+end on /ey fields.
•
All non/ey must *e mutually inde+endent.
F#&st N&m'l F&m23 A relation is in first normal form ;193< if it does not $ontain a re+eating grou+. A re+eating grou+ is a set of one or more data items that may o$$ur a varia*le num*er of times of in a tu+le.
F6"%t#"'l De!e"-e"%y23
Hostel Management System
Page 14
Govt. Degree College for Women Haroonabad 3un$tional 5e+enden$y is a relationshi+ *et&een attri*utes. (t means that value of one attri*ute is /no&n. (t is +ossi*le to o*tain the value of another attri*ute.
Se%"- N&m'l F&m23 A relation is in se$ond normal form ;!93< if it is in 193 and if all of its non /ey attri*ute are fully fun$tionally de+end on the &hole /ey.
F6ll F6"%t#"'l De!e"-e"%y23 A relation R, attri*ute of R is fully fun$tionally de+end on a *ut not fun$tionally de+endent in any other +ro+er su*set of A.
T 4#&- N&m'l F&m23 A relation is in third normal form if it is in !93 and if no non /ey attri*ute is de+endent on another non /ey attri*ute. (t means that all min /ey attri*utes are fun$tionally de+endent on +rimary /ey.
T&'"s#t#ve De!e"-e"%y23 Transitive de+enden$y is a $ondition in &hi$h an attri*ute in not +art of the +rimary /ey.
Hostel Management System
Page 15
Govt. Degree College for Women Haroonabad
D't'5'se23
Hostel Management System
Page 16
Govt. Degree College for Women Haroonabad (n our data*ase the ta*les are *a$/end. Sin$e our data*ase is distri*uted so &e vie& the data*ase from forms. The +eo+le at different $om+uter a$$ess the data through different ueries.
T'5les23 A data*ase ta*le is similar in a++earan$e to a s+readsheet. (n that is stored in ro&s and $olumns. As a result, it is usually uite easy to im +ort a s+readsheet into a data*ase ta*le. The main differen$e *et&een storing your data in a s+readsheet and storing it in a data*ase is in ho& the data is organized. Ta*les related to Sales Management System are as follo&s7 • • •
3ee Ta*le Hostel :ntry Ta*le Students Attendan$e Ta*le Students Re$ords Ta*le
Fee T'5le
Hostel Management System
Page 1
Govt. Degree College for Women Haroonabad
7stel E"t&y T'5le
St6-e"ts Atte"-'"%e T'5le
Hostel Management System
Page 1!
Govt. Degree College for Women Haroonabad
St6-e"ts Re%&-s T'5le
F&ms2 3orms are sometimes referred to as 45ata :ntry Su$$ess=. They are the interfa$es you use to &or/ &ith your data, and they often $ontain $ommand *uttons that +erform various $ommands. >ou $an $reate a data*ase &ithout using forms *y
Hostel Management System
Page 1"
Govt. Degree College for Women Haroonabad sim+le editing your data in the ta*le datasheet. Ho&ever most data*ase users +refer to use forms for vie&ing, entering and editing data in the ta*les. 3orms +rovide an easytouse format for &or/ing &ith the data, and you $an also add fun$tional elements, su$h as $ommand *uttons, to them. >ou $an +rogram the *utton to determine &hi$h data a++ear on the form, o+en others forms or re+orts, or +erform a variety of others tas/s. 3or eam+le, you might have a form named 4Student form= in &hi$h you &or/ &ith $ustomer data. The Student form might have a *uttons &hi$h o+ens an order form &here you $an enter a ne& order for that $ustomer. 3orms also allo& you to $ontrol ho& others users intera$t &ith the data in data*ase. 3or eam+le, you $an $reate a form that sho&s only $ertain fields and allo&s only $ertain o+eration to *e +erformed. This hel+s +rote$t data and to ensure that the data. • • • • •
3ee 3orm Hostel :ntry 3orm Students Attendan$e 3orm Students Re$ords 3orm Main 3orm
Fee F&m
Hostel Management System
Page 2#
Govt. Degree College for Women Haroonabad
7stel E"t&y F&m
St6-e"t Atte"-'"%e F&m
Hostel Management System
Page 21
Govt. Degree College for Women Haroonabad
St6-e"ts Re%&-s F&m
M'#" F&m
Hostel Management System
Page 22
Govt. Degree College for Women Haroonabad
Re!&ts2 Re+orts are &hat you use to summarize and +resent data in the ta*les. A re+ort usually ans&ers a s+e$ifi$ uestion, su$h as 4ho& mu$h money did &e re$eive from ea$h Student= $an *e formatted to +resent the information in the most reada*le &ay +ossi*le. A re+ort $an *e urn at any time. And &ill al&ays refle$t the $urrent data in the data*ase. Re+orts are generally formatted to *e +rinted out, *ut they $an also *e vie&ed on the s$reen, e+orted to another +rogram, or sent as e mail message. • •
3ee Re+ort Hostel :ntry Re+ort Students Attendan$e Re+ort
Fee Re!&t
7stel E"t& y Re!&t
Hostel Management System
Page 23
Govt. Degree College for Women Haroonabad
St6-e"ts Atte"-'"%e Re!&t
CHAPTER 5 9 Hostel Management System
Page 24
Govt. Degree College for Women Haroonabad
86ees 9 Rel't#"s
86ees2 ?ueries are the real &or/horses in a data*ase, and $an +erform many different fun$tions. Their most $ommon fun$tion is to retrieve s+e$ifi$ data from the ta*les. The data you &ant to see is usually s+read a$ross several ta*les, and ueries allo& you to vie& it in a single datasheet. Also, sin$e you usually don@t &ant all the re$ords at on$e, ueries let you add $riteria to 4filter= the data do&n to -ust the re$ords you &ant. ?ueries often serve as the re$ord for forms and re+orts. ertain ueries are 4u+datea*le,= meaning you $an edit the data in the underlying ta*les via the uery datasheet. (f you are &or/ing in an u+datea*le uery,
Hostel Management System
Page 25
Govt. Degree College for Women Haroonabad remem*er that your $hanges are a $utely *eing made in the ta*les, not -ust in the uery datasheet. ?ueries $ome in t&o *asi$ varieties7 sele$t ueries and a$tion ueries. A sele$t uery sim+ly retrieves the data and ma/es it availa*le for use. >ou $an vie& the results of the uery in the s$reen, +rint it out, or $o+y it to the $li+*oard. 2r, you $an use the out+ut of the uery us the re$ord sour$e for a form or re+ort. An a$tion uery, &e the name im+lies, +erform a ta/e &ith the data. A$tion ueries $an *e used to $reate ne& ta*les, add data to eisting ta*les, u+date data, or delete data.
Atte"-'"%e A"- St6-e"ts 86e&y T'5le 9 Rel't#"
Hostel Management System
Page 26
Govt. Degree College for Women Haroonabad
7stel E"t&y A"- St6-e"ts 86e&y T'5le 9 Rel't#"
Fee A"- St6-e"ts 86e&y T'5le 9 Rel't#"
Hostel Management System
Page 2
Govt. Degree College for Women Haroonabad
CHAPTER 5 : Hostel Management System
Page 2!
Govt. Degree College for Women Haroonabad
CONCLUSION
C"%l6s#"2 (n $on$lusion &e see ne& u+date system, &hi$h is *etter than old system. e$ause all the dra&*a$/s of old system. After the im+lementation of this system the +eo+le $an e$ess the data at different sites through different ueries.
Hostel Management System
Page 2"