LIBRARY MANAGEMENT

SYSTEM
TABLE OF CONTENTS - II
CHAPTER CONTENT PAGE NO.
ABSTRACT 27
1 ANALYSIS 28
1.1 Schedule of Project 29
2 DESIN !"
Le#el " D$D D%&'r&( !1
Le#el 1 D$D D%&'r&( !1
Le#el 2 D$D D%&'r&( !!
D&t&)&*e De*%'+ !,
! C-DIN !7
. -/TP/T 0IND-0S ,7
, C-NCL/SI-N 12
1 RE$ERENCE 1!
2
ABSTRACT
The 2roject focu*e* o+ the de#elo2(e+t *3%ll* of the u*er. The 3+o4led'e
&c5u%red 2ro#e* to )e hel2ful &+d effect%#e6 o+l7 %f %t %* %(2le(e+ted. The
%(2le(e+t&t%o+ of the 3+o4led'e &c5u%red %* trou'h 2roject &+d c&*e *tud%e* )&*ed o+
re&l t%(e *ce+&r%o*.
The 8LIBRARY 9ANAE9ENT SYSTE9: u+dert&3e+ &* & 2roject %*
)&*ed o+ rele#&+t tech+olo'%e* .The 2roject* &re do+e %+ 'rou2* 4here the *tude+t le&r+
to 4or3 %+ & te&(6 (&+&'e 2roject *chedule* 6follo4 the )e*t cod%+' *t&+d&rd* &+d
co+#e+t%o+* &+d &dhere to 2roject docu(e+t&t%o+ *t&+d&rd*.
;ere %+ th%* 2roject 4e u*e fro+t e+d &* <C== &+d )&c3e+d &* (*>&cce**.
0e *tore %+for(&t%o+ &)out the )oo3* &+d the *tude+t* 4ho h&#e t&3e+ the )oo3*. All
the*e det&%l* &re *tored %+ the d&t&)&*e )7 e+ter%+' %+to <C== &+d the det&%l* c&+ )e
d%*2l&7ed fro( the d&t&)&*e )7 4r%t%+' the 5uer7 %+ <C ==. Th%* 2roject %+#ol#e* *e#er&l
(odule* to c&rr7 out e&ch &ct%o+.
0e cre&ted d&t&)&*e for *tor%+' the det&%l* %+ t&)le* .0e cre&ted t&)le for
9E9BER DETAILS6 & t&)le for *tor%+' B--? DETAILS &+d &+other t&)le for *tor%+'
the det&%l* of the *tude+t* 4ho h&#e t&3e+ the )oo3* +&(el7 9E9BER B--?
DETAILS.
0e c&+ &l*o *tore the det&%l* &t ru+ t%(e 6th&t %* 4e c&+ e+ter the *tude+t
det&%l* )7 e+ter%+' the det&%l* of the *tude+t *e2&r&tel7 &t ru+ t%(e. L%3e4%*e the
tr&+*&ct%o+ det&%l* c&+ &l*o )e e+tered &t ru+ t%(e. 0e c&+ e%ther *tore %+ & d&t&)&*e &+d
*ee the det&%l* 4he+ re5u%red or *ee the det&%l* &t ru+ t%(e )7 *elect%+' the o2t%o+ d%*2l&7.
;e+ce %+ the e@%*t%+' *7*te( for LIBRARY 9ANAE9ENT SYSTE9
6the 2erfor(&+ce e#&lu&t%o+ *7*te( &+d the (&%+te+&+ce &re do+e (&+u&ll7. The
2ro2o*ed *7*te( 4%ll (&%+t&%+ &ll the %+for(&t%o+ %+ & *t&+d&rd d&t&)&*e &+d 4%ll )e &)le
!
to 'e+er&te re2ort* &* &+d 4he+ +ece**&r7.Acce**%+' &+d the u*er h&* the r%'ht to *e&rch
)&*ed o+ the &)o#e (e+t%o+ed cr%ter%&*.
1. ANALYSIS PHASE
I+ th%* A+&l7*%* 2h&*e 4e &re &+&l7A%+' the re5u%re(e+t* 4h&t 4e 4&+t to
do 2roject. 0e h&#e to collect the re5u%re(e+t* +eeded to de#elo2 the 2roject. $or th&t
4e h&#e to refer the )oo3* &+d 4e)*%te* for '&ther%+' the re5u%re(e+t*.
I+ th%* &+&l7*%* 2h&*e6 4e h&#e to de*%'+ the 2roject %+ (%+d ho4 %t h&* to
)e &+d 4h&t &re &ll the o2er&t%o+* th&t h&* to c&rr7 %+ the 2roject &+d ho4 %t h&* to )e
%+ter&ct%#e 4%th the u*er* &+d ho4 %t h&* to &ttr&ct the cu*to(er.
The 2roject h&* to co+t&%+ &ll the det&%l* &)out the (e()er* %+ the l%)r&r7
&+d )oo3* %+ the l%)r&r7 &+d the det&%l* the (e()er* 4ho t&3e+ the )oo3* &+d th%* det&%l*
h&* to *tore %+ the d&t&)&*e for th%* t72e 4e h&#e to &+&l7Ae the 2ro)le( &+d 4e h&#e to
de#elo2 the 2roject. I+ th%* &+&l7*%* 2h&*e 4e h&#e to collect the det&%l* &)out the
2roject *uch &* 4h&t &re &ll o2er&t%o+* th&t 4%ll (&3e %+ter&ct%#e &+d 4h&t &re &ll the
f%eld* th&t h&* to )e 2re*e+t + the d&t&)&*e &+d the d&t&)&*e (u*t *tore the det&%l* of &ll
the (e()er* &+d the )oo3 det&%l* &+d the (e()er* 4ho t&3e+ the )oo3*.
I+ th%* &+&l7*%* 2h&*e o+l7 4e 4%ll collect the %+for(&t%o+ &)out the
2roject. Th%* %* the f%r*t *t&'e of the 2roject. After th%* o+l7 4e 4%ll *t&rt do%+' 2roject
th&t %* the de*%'+ of the 2roject 4%ll c&rr7 &fter th%* *t&'e. After th&t 4e 4%ll 4r%te the
2roject cod%+' &+d 4e 4%ll te*t the 2roject.
Th%* 2h&*e 4%ll t&3e the dur&t%o+ u2 to 1 to 2 4ee3* for co(2let%o+ of th%*
&+&l7*%* *t&'e th&t %* for collect%+' the re5u%re(e+t* &+d %t h&* to co+t&%+ &ll the det&%l*
&)out the 2roject. I+ *o(e 2roject* %t 4%ll t&3e (ore t%(e for co(2let%o+ of the &+&l7*%*
*t&'e )ec&u*e %t h&* to collect (ore re5u%re(e+t*6 %t h&* to )e de2e+d u2o+ the 2roject %t
4%ll t&3e dur&t%o+6 he+ce for *(&ll t72e of 2roject* 4e c&+ e&*%l7 co(2lete the 2roject
.
4%th%+ the *hort dur&t%o+6 for l&r'e 2roject* %t 4%ll t&3e (ore dur&t%o+ for &+&l7*%* *t&'e
&+d &l*o for co(2let%o+ of the 2roject.
But for th%* 2roject 4e c&+ e&*%l7 co(2lete the 2roject 4%th%+ the *hort
dur&t%o+ )ec&u*e %t %* l%3e & (%+% 2roject &+d &l*o 4e c&+ e&*%l7 co(2lete the *t&'e of
&+&l7*%*. If 4e co(2leted the *t&'e of &+&l7*%* the+ %t &22e&r* l%3e 4e co(2leted the 2,B
of the 2roject 4%th%+ *hort dur&t%o+.
1.1 SCHEDULE OF THE PROJECT
ACTIVITY DURATION
De*%'+ Ph&*e 2 0ee3*
I(2le(e+t&t%o+ 2 0ee3*
Cod%+' Ph&*e ! 0ee3*
<%e4 Re*ult 2 0ee3*
E@ecut%o+ C De(o 1 0ee3
Re2ort e+er&t%o+ 1 0ee3
,
2. DESIGN PHASE
I+ th%* de*%'+ *t&'e 4e &re de*%'+%+' our 2roject &ccord%+' to cu*to(er
*&t%*f&ct%o+ or u*er *&t%*f&ct%o+. I+ th%* de*%'+ 2h&*e the u*er (u*t u+der*t&+d the 4hole
2roject )7 *ee%+' the de*%'+ of the 2roject. After the co(2let%o+ of the &+&l7*%* *t&'e the
u*er (u*t de*%'+ the 2roject &ccord%+' to the collected re5u%re(e+t* %+ the &+&l7*%* *t&'e.
After the co(2let%o+ of the &+&l7*%* *t&'e the u*er (u*t co+t%+ue 4%th the de*%'+ *t&'e.
I+ th%* 2roject the u*er (u*t cre&te the d&t&)&*e to *tore the det&%l* of (e()er*6
)oo3*6 &+d re2ort* t&)le* )&*ed u2o+ collect%o+ of t&)le re5u%re(e+t* collected %+ the
de*%'+ *t&'e.
I+ th%* t&)le*6 o+e f%eld h&* )ee+ '%#e+ &* 2r%(&r7 3e7 %+ the de*%'+ of t&)le*
)ec&u*e %t 4o+Dt &llo4 the du2l%c&te #&lue* of (e()er* or %t 4o+Dt &cce2t the *&(e %d
+u()er for d%ffere+t (e()er*.
$or Boo3 Det&%l* t&)le &l*o o+e 2r%(&r7 3e7 h&* )ee+ &lloc&ted for +e'lect%+' the
*&(e #&lue* for the f%eld Boo3 +u()er &+d &+other t&)le 4&* cre&ted th&t %* for *tor%+'
the det&%l* of tr&+*&ct%o+ th&t h&* )ee+ c&rr%ed out6 %+ th&t d&t&)&*e %t doe*+Dt h&#e &+7
3e7* %+ th&t )ec&u*e %t c&+ co+t&%+ the det&%l* (&+7 u*er* c&+ t&3e the )oo3 4%th *&(e
&ccou+t +u()er.
After cre&t%o+ of t&)le* the u*er (u*t de*%'+ the 2roject th&t %* %t c&+ &l*o
re2re*e+t the de*%'+ %+ the for( of D&t& $lo4 D%&'r&(*. I+ the D&t& $lo4 d%&'r&(* %t
co+t&%+* the le#el* th&t %* %t h&* to )e re2re*e+ted %+ Le#el " D$D6 Le#el 1 D$D6 Le#el 2
D$D6E *o th&t 4e c&+ re2re*e+t the D&t& flo4 d%&'r&(* %+ th&t for(&t u2 to +u()er of
D$DD* re5u%red %+ the 2roject.
The u*er (u*t de*%'+ or dr&4 the D$D d%&'r&(* )&*ed u2o+ the 2roject 4h&t %t
4%ll do6 4h&t &re the o2er&t%o+* th&t 4&* c&rr7%+' %+ the 2roject %t 4%ll re2re*e+t the D$D
d%&'r&(* %+ the o+e )7 o+e o2er&t%o+ th&t 4&* c&rr7%+' %+ the 2roject.
The u*er (u*t u+der*t&+d the 2roject 4h&t &re &ll the o2er&t%o+* %+ the 2roject th&t
4&* 'o%+' to do or c&rr7%+' out )7 *ee%+' the D$D D%&'r&(*. I+ th&t for(&t the u*er
1
(u*t dr&4 the D$D d%&'r&(. The D$D d%&'r&( th&t (u*t co+t&%+ &ll the det&%l* of the
2roject.
2.1 LEVEL 0 DFD DIAGRAM:
I+ Le#el " D$D d%&'r&(6 %t 4%ll d%*2l&7 the (e+u* of the 2roject th&t %*
4h&t &re &ll 4e c&+ do %+ the 2roject. $ro( th&t 4e c&+ *elect the o2t%o+ 4h&t 4e &re
'o%+' to do. B&*ed u2o+ the co+d%t%o+ %t d%*2l&7 the +e@t *cree+ for the *elected
o2er&t%o+.
7
LEVEL O DFD DIAGRAM
ErrorF Refere+ce *ource +ot fou+d
2.2 LEVEL 1 DFD DIAGRAM:
I+ Le#el 1 D$D d%&'r&( %t t&3e* the %+2ut det&%l* &+d *tore the det&%l* %+
the d&t&)&*e. It t&3e* the det&%l* *e2&r&tel7 for e&ch t&)le &+d *tore det&%l* *e2&r&tel7 %+
e&ch t&)le.
2.2.1 TO STORE THE DETAILS OF MEMBERS:


8
SEARC;IN
T;E
B--?
SEARC;IN
ST/DENT
DETAIL
ENTERIN
T;E B--?
DETAILS
ENTERIN
ST/DENT
DETAILS
ST/DENTB--?
ENTRY
DISPLAYIN
T;E B--?
DETAILS
DISPLAYIN
T;E ST/DENTS
DETAILS
ST-RIN T;E
B--?
DETAILS
ST-RIN T;E
ST/DENT
DETAILS
ST-RIN T;E
ST/DENTB--?
DETAILS
2.2.2 TO STORE THE DETAILS OF BOOKS:
9
TA?IN
INP/T
DETAILS
-$
9E9BER
9E9BER
NA9E
9E9 N-
ADDRESS
D-B
ST-RIN T;E
DETAILS IN
T;E
DATABASE
TA?IN
INP/T
DETAIL
S -$
B--?S
B--?

NA9E
B--? N-
A/T;-R
EDITI-N
ST-RIN
T;E
DETAILS IN
T;E
DATABASE
P/BLIS;ER
ST-C?
2.2.3 TO STORE THE DETAILS OF TRANSACTIONS
2.3 LEVEL 2 DFD DIAGRAM:
I+ Le#el 2 D$D d%&'r&( %t d%*2l&7* the *elected det&%l* or the det&%l* of &ll
)oo3* 2re*e+t %+ the l%)r&r7 &+d the det&%l* of *elected (e()er* or &ll the (e()er* 4ho
&re h&#%+' the (e()er*h%2 %+ the l%)r&r7 &+d the tr&+*&ct%o+ det&%l* of (e()er* 4ho
h&#e t&3e+ )oo3*.
1"
TA?IN
DETAIL
S -$
TRANSA
CTI-NS
B--?

NA9E
B--? N-
A/T;-R
EDITI-N
ST-RES T;E
DETAILS IN
T;E
DATABASE
DATE -$
ISS/E
DATE -$
RET/RN
9E9N-
9E9BER
NA9E
2.3.1 TO DISPLAY THE MEMBER DETAILS:
11
DISPLAY
IN
-/TP/T
DETAILS
-$
9E9BER
NA9E
9E9 N-
ADDRESS
D-B
DISPLAYIN
T;E
DETAILS
$R-9 T;E
DATABASE
2.3.2 TO DISPLAY THE DETAILS OF BOOKS:
2.3.3 TO DISPLAY THE DETAILS OF TRANSACTIONS
2.4 DATABASE DESIGN:
MS-ACCESS DATABASE F LIBRARY . 9DB
2...1 B--?DETAILS TABLE
$IELD NA9E
DATATYPE SIGE
B--?N- Te@t ,"
B--?NA9E Te@t ,"
A/T;-R Te@t ,"
EDITI-N
Te@t ,"
12
DISPLA
YIN
DETAIL
S -$
B--?S
B--?

NA9E
B--? N-
A/T;-R
EDITI-N
DISPLAYIN
T;E
DETAILS
$R-9 T;E
DATABASE
P/BLIS;ER
ST-C?
P/BLIS;ER Te@t ,"
ST-C? Te@t ,"

2...2 9E9BER DETAILS TABLE

$IELD NA9E DATATYPE SIGE
9E9N- Te@t ,"
NA9E Te@t ,"
ADRESS Te@t ,"
D-B D&teHT%(e 8
1!
2...! TRANSACTI-N DETAILS TABLE
$IELD NA9E DATATYPE SIGE
9E9N- Te@t ,"
B--?N- Te@t ,"
B--?NA9E Te@t ,"
NA9E Te@t ,"
A/T;-R Te@t ,"
DATE-$B--?ISS/E D&teHT%(e 8
DATE-$B--?RET/RN D&teHT%(e 8
EDITI-N Te@t ,"
1.
3. CODING:
I%+cludeJ%o*tre&(.hK
I %+cludeJ*td%o.hK
I %+cludeJco+%o.hK
I %+cludeJdo*.hK
I %+cludeJ*tr%+'.hK
I %+cludeJ(&th.hK
I%(2ort LcFMPro'r&( $%le*MCo((o+ $%le*MS7*te(MAD-M(*&do1,.dllL M
+oN+&(e*2&ce re+&(eOLE-$L6 LE+d-f$%leLP
ch&r +&(eQ,"R6&+&(eQ,"RS
%+t &cc+oS
%+t edS
%+t r3S
%+t r4S
%+t *toc3S
#o%d *electc&*eOPS
#o%d (e(det&%l*OPS
#o%d )oo3det&%l*OPS
#o%d tr&+*&ct%o+det&%l*OPS
#o%d &dd+e4)oo3OPS
1,
#o%d %**ue)oo3OPS
#o%d (e+uOPS
#o%d (e((e+uOPS
#o%d )oo3(e+uOPS
#o%d re2ort(e+uOPS
#o%d e@%tOPS
#o%d )&c3OPS
#o%d &dd+e4(e()erOPS
#o%d delete(e()erOPS
TO ADD NE! MEMBER DETAILS TO THE DATABASE
#o%d &dd+e4(e()erOP
T
HHclr*crOPS
ch&r +&(eQ2"RS
ch&r te(2Q1"RUL LS
ch&r (e(+oQ1"RS
ch&r &ddre**Q1"RS
ch&r do)Q1"RS
coutJJLENTER T;E 9E9BER N/9BERFLS
c%+KK(e(+oS
coutJJLENTER T;E 9E9BER NA9EFLS
c%+KK+&(eS
11
coutJJLENTER T;E ADDRESSFLS
c%+KK&ddre**S
coutJJLENTER T;E DATE -$ BIRT;FLS
c%+KKdo)S
CoI+%t%&l%AeON/LLPS
tr7
T
*trc&tOte(26LINSERT INT- 9E9DETAILS <AL/ESOV LPS
*trc&tOte(26(e(+oPS
*trc&tOte(26LV6VLPS
*trc&tOte(26+&(ePS
*trc&tOte(26LV6VLPS
*trc&tOte(26&ddre**PS
*trc&tOte(26LV6VLPS
*trc&tOte(26do)PS
*trc&tOte(26LVPSLPS
NRecord*etPtr 2R*tOLAD-DB.Record*etLPS
N)*trNt *trC++OLDRI<ERUT9%cro*oft Acce** Dr%#er
OW.(d)PXS/IDU&d(%+SDBYULIBRARY.(d)LPS
2R*t>K-2e+Ote(26*trC++6&d-2e+?e7*et6&dLoc3-2t%(%*t%c6&dC(dTe@tPS
2R*t>K9o#e$%r*tOPS
4h%le OZ2R*t>KE+d-f$%leP
T
17
2R*t>K9o#eNe@tOPS
X
2R*t>KClo*eOPS
X
c&tch ONco(Nerror CeP
T
coutJJOch&rWP e.De*cr%2t%o+OPS
X
coutJJe+dlJJLT;E 9E9BER DETAILS 0AS ST-RED IN A DATABASE
S/CCESS$/LLYLJJe+dlS
*electc&*eOPS
X
18
TO ADD NE! BOOK TO THE DATABASE
#o%d &dd+e4)oo3OP
T
HHclr*crOPS
ch&r +&(eQ2"RS
ch&r te(2Q8"RUL LS
ch&r )oo3+oQ1"RS
ch&r &+&(eQ1"RS
ch&r edQ1"RS
ch&r 2u)Q1"RS
ch&r *toc3Q1"RS
coutJJLENTER T;E B--? NA9EFLS
c%+KK+&(eS
coutJJLENTER T;E ACC-/NT N/9BERFLS
c%+KK)oo3+oS
coutJJLENTER T;E A/T;-R NA9EFLS
c%+KK&+&(eS
coutJJLENTER T;E EDITI-N -$ B--?FLS
c%+KKedS
19
coutJJLENTER P/BLIS;ER NA9EFLS
c%+KK2u)S
coutJJLENTER T;E ST-C?FLS
c%+KK*toc3S
CoI+%t%&l%AeON/LLPS
tr7
T
*trc&tOte(26LINSERT INT- B--?DETAILS <AL/ESOV LPS
*trc&tOte(26)oo3+oPS
*trc&tOte(26LV6VLPS
*trc&tOte(26+&(ePS
*trc&tOte(26LV6VLPS
*trc&tOte(26&+&(ePS
*trc&tOte(26LV6VLPS
*trc&tOte(26edPS
*trc&tOte(26LV6VLPS
*trc&tOte(262u)PS
*trc&tOte(26LV6VLPS
*trc&tOte(26*toc3PS
*trc&tOte(26LVPSLPS
NRecord*etPtr 2R*tOLAD-DB.Record*etLPS
N)*trNt *trC++OLDRI<ERUT9%cro*oft Acce** Dr%#er
OW.(d)PXS/IDU&d(%+SDBYULIBRARY.(d)LPS
2R*t>K-2e+Ote(26*trC++6&d-2e+?e7*et6&dLoc3-2t%(%*t%c6&dC(dTe@tPS
2"
2R*t>K9o#e$%r*tOPS
4h%le OZ2R*t>KE+d-f$%leP
T
2R*t>K9o#eNe@tOPS
X
2R*t>KClo*eOPS
X
c&tch ONco(Nerror CeP
T
coutJJOch&rWP e.De*cr%2t%o+OPS
X
coutJJe+dlJJLT;E B--? DETAILS 0AS ST-RED IN A DATABASE
S/CCESS$/LLYLJJe+dlS
*electc&*eOPS
X
TO ISSUE LIBRARY BOOK TO THE STUDENT
#o%d %**ue)oo3OP
T
ch&r te(2Q1""RUL LS
ch&r +oQ1"RS
ch&r )+oQ1"RS
ch&r d&teQ1"RS
ch&r ed&teQ1"RS
21
ch&r &uthorQ1"RS
ch&r ed%t%o+Q1"RS
ch&r +&(eQ,"R6)+&(eQ,"RS
coutJJLENTER T;E 9E9N-FLS
c%+KK+oS
coutJJLENTER T;E B--? ACC-/NT N-FLS
c%+KK)+oS
coutJJLENTER T;E B--? NA9EFLS
c%+KK)+&(eS
coutJJLENTER T;E NA9EFLS
c%+KK+&(eS
coutJJLENTER A/T;-R NA9EFLS
c%+KK&uthorS
coutJJLENTER T;E DATE -$ ISS/SEFLS
c%+KKd&teS
coutJJLENTER T;E DATE -$ RET/RNFLS
c%+KKed&teS
coutJJLENTER EDITI-N -$ B--?FLS
c%+KKed%t%o+S
CoI+%t%&l%AeON/LLPS
tr7
T
*trc&tOte(26LINSERT INT- TRANSACTI-NDETAILS <AL/ESOV LPS
22
*trc&tOte(26+oPS
*trc&tOte(26LV6VLPS
*trc&tOte(26)+oPS
*trc&tOte(26LV6VLPS
*trc&tOte(26)+&(ePS
*trc&tOte(26LV6VLPS
*trc&tOte(26+&(ePS
*trc&tOte(26LV6VLPS
*trc&tOte(26&uthorPS
*trc&tOte(26LV6VLPS
*trc&tOte(26d&tePS
*trc&tOte(26LV6VLPS
*trc&tOte(26ed&tePS
*trc&tOte(26LV6VLPS
*trc&tOte(26ed%t%o+PS
*trc&tOte(26LVPSLPS
NRecord*etPtr 2R*tOLAD-DB.Record*etLPS
N)*trNt *trC++OLDRI<ERUT9%cro*oft Acce** Dr%#er
OW.(d)PXS/IDU&d(%+SDBYULIBRARY.(d)LPS
2R*t>K-2e+Ote(26*trC++6&d-2e+?e7*et6&dLoc3-2t%(%*t%c6&dC(dTe@tPS
2R*t>K9o#e$%r*tOPS
4h%le OZ2R*t>KE+d-f$%leP
T
2!
2R*t>K9o#eNe@tOPS
X 2R*t>KClo*eOPS
X c&tch ONco(Nerror CeP
T
coutJJOch&rWP e.De*cr%2t%o+OPS
XcoutJJe+dlJJLT;E TRANSACTI-N DETAILS 0AS ST-RED IN A
DATABASE S/CCESS$/LLYLJJe+dlS
*electc&*eOPS
X
TO DISPLAY THE MAIN SCREEN
#o%d (e+uOP
T
%+t &S
coutJJe+dlJJe+dlJJe+dlJJLMtMtLIBRARY 9ANAE9ENTLJJe+dlS
coutJJe+dlS
coutJJL1.9E9BERSLJJe+dlS
coutJJL2.B--?SLJJe+dlS
coutJJL!.REP-RTSLJJe+dlS
HHcoutJJL;ELPLJJe+dlS
coutJJL..E[ITLJJe+dlS
coutJJe+dlS
coutJJLENTER Y-/R C;-ICEFLS
c%+KK&S
*4%tchO&P
2.
T
c&*e 1F
(e((e+uOPS
)re&3S
c&*e 2F
)oo3(e+uOPS
)re&3S
c&*e !F
re2ort(e+uOPS
)re&3S
c&*e .F
e@%tOPS
)re&3S
def&ultF
coutJJLENTER C-RRECT C;-ICEFLS
)re&3S
X
'etchOPS
X
TO DISPLAY THE MEMBER DETAILS MENU
#o%d (e((e+uOP
T
2,
%+t )S
coutJJe+dlS
coutJJL1.ADD NE0 9E9BERLJJe+dlS
coutJJL2.DELETE T;E 9E9BERLJJe+dlS
coutJJL!.BAC?LJJe+dlS
coutJJe+dlS
coutJJLE+ter 7our cho%ceFLS
c%+KK)S
*4%tchO)P
T
c&*e 1F
&dd+e4(e()erOPS
)re&3S
c&*e 2F
delete(e()erOPS
)re&3S
c&*e !F
)&c3OPS
)re&3S
def&ultF
coutJJLE+ter correct cho%ceFLS
)re&3S
21
X
'etchOPS
X
TO DISPLAY THE BOOK DETAILS MENU IN THE SCREEN
#o%d )oo3(e+uOP
T
%+t )S
coutJJe+dlS
coutJJL1.ADD NE0 B--?SLJJe+dlS
coutJJL2.ISS/E B--?LJJe+dlS
HH coutJJLB--? DETAILSLJJe+dlS
coutJJL!.BAC?LJJe+dlS
coutJJe+dlS
coutJJLE+ter 7our cho%ceFLS
c%+KK)S
*4%tchO)P
T
c&*e 1F
&dd+e4)oo3OPS
)re&3S
c&*e 2F
%**ue)oo3OPS
)re&3S
27
c&*e !F
)&c3 OPS
)re&3S
def&ultF
coutJJLE+ter correct cho%ceFLS
)re&3S
X
'etchOPS
X
TO SELECT !HICH OPERATION HAS TO DO
#o%d to*electc&*eOP
T
ch&r 7S
coutJJe+dlJJLTo co+t%+ue 2re** &+7 3e7 F LS
c%+KK7S
coutJJe+dlS
%f O7UV7VP
T
(e+uOPS
X
el*e
T
28
#o%d e@%tOPS
X
X
TO GO BACK TO THE PREVIOUS SCREEN
#o%d *electc&*eOP
T
ch&r 7S
coutJJe+dlJJLTo co+t%+ue 2re** &+7 3e7FLS
c%+KK7S
coutJJe+dlS
%f O7UV7VP
T
(e+uOPS
X
el*e
T
#o%d )&c3OPS
X
X
MAIN FUNCTION
29
#o%d (&%+OP
T
(e+uOPS
X
TO DELETE MEMBER
#o%d delete(e()erOP
T
HHlr*crOPS
coutJJLENTER T;E B--? NA9EFLS
c%+KK+&(eS
coutJJLENTER T;E ACC-/T N/9BERFLS
c%+KK&cc+oS
coutJJLENTER T;E A/T;-R NA9EFLS
c%+KK&+&(eS
coutJJLENTER T;E EDITI-N -$ B--?FLS
c%+KKedS
coutJJLENTER T;E RAC? N/9BER -$ B--?FLS
c%+KKr3S
coutJJLENTER T;E R-0 N/9BER -$ B--?FLS
c%+KKr4S
coutJJLENTER T;E ST-C?FLS
c%+KK*toc3S T
!"
CoI+%t%&l%AeON/LLPS
tr7
T
NRecord*etPtr 2R*tOLAD-DB.Record*etLPS
N)*trNt *trC++OLDRI<ERUT9%cro*oft Acce** Dr%#er
OW.(d)PXS/IDU&d(%+SDBYULIBRARY.(d)LPS
2R*t>K9o#e$%r*tOPS
4h%le OZ2R*t>KE+d-f$%leP T
coutJJOch&rWP OON)*trNtP 2R*t>Ket$%eld*OP>KetIte(OLNA9ELP>Ket<&lueOPPJJL LS
coutJJOch&rWP OON)*trNtP 2R*t>Ket$%eld*OP>KetIte(OL<TN-LP>Ket<&lueOPPJJe+dlS
2R*t>K9o#eNe@tOPS
X
2R*t>KClo*eOPS
X
c&tch ONco(Nerror CeP
T
coutJJOch&rWP e.De*cr%2t%o+OPS
X
FFCo/+%+%t%&l%AeOPS
X
*electc&*eOPSX
TO DISPLAY THE REPORT MENU
#o%d re2ort(e+uOP
!1
T
coutJJe+dlS
%+t cS
coutJJL1.9E9BER DETAILSLJJe+dlS
coutJJL2.B--? DETAILSLJJe+dlS
coutJJL!.TRANSACTI-N DETAILSLJJe+dlS
coutJJL..BAC?LJJe+dlJJe+dlS
coutJJLENTER Y-/R C;-ICEFLS
c%+KKcS
*4%tchOcP
T
c&*e 1F
(e(det&%l*OPS
)re&3S
c&*e 2F
)oo3det&%l*OPS
)re&3S
c&*e !F
tr&+*&ct%o+det&%l*OPS
)re&3S
c&*e .F
)&c3OPS
)re&3S
!2
def&ultF
coutJJLENTER C-RRECT C;-ICEFLS
)re&3S
X
'etchOPS
X
HHT- E[IT $R-9 T;E PR-RA9
#o%d e@%tOP
T
e@%tOPS
X
HHT- - BAC? T- T;E PRE<I-/S SCREEN
#o%d )&c3OP
T
coutJJe+dlS
coutJJe+dlS
(e+uOPS
X
TO DISPLAY MEMBER DETAILS ON THE SCREEN
#o%d (e(det&%l*OP
T
T
CoI+%t%&l%AeON/LLPS
!!
tr7
T
NRecord*etPtr 2R*tOLAD-DB.Record*etLPS
N)*trNt *trC++OLDRI<ERUT9%cro*oft Acce** Dr%#er
OW.(d)PXS/IDU&d(%+SDBYULIBRARY.(d)LPS
2R*t>K-2e+OLSELECT W $R-9 9E9DETAILS SL6 *trC++6 &d-2e+St&t%c6
&dLoc3Re&d-+l76 &dC(dTe@tPS

coutJJe+dlS
coutJJL9E9N- NA9E ADDRESS D-B LJJe+dlS
coutJJLLJJe+dlS
2R*t>K9o#e$%r*tOPS
4h%le OZ2R*t>KE+d-f$%leP T
coutJJe+dlS
coutJJOch&rWP OON)*trNtP 2R*t>Ket$%eld*OP>KetIte(OL9E9N-LP>K et<&lueOPPJJL
LS
coutJJOch&rWP OON)*trNtP 2R*t>Ket$%eld*OP>KetIte(OLNA9ELP>Ket<&lueOPPJJL LS
coutJJOch&rWP OON)*trNtP 2R*t>Ket$%eld*OP>KetIte(OLADDRESSLP>Ket<&lueOPPJJL
LS
coutJJOch&rWP OON)*trNtP 2R*t>Ket$%eld*OP>KetIte(OLD-BLP>Ket<&lueOPPJJL LS
coutJJLMtLS
2R*t>K9o#eNe@tOPS
X
2R*t>KClo*eOPS
!.
X
c&tch ONco(Nerror CeP
T
coutJJOch&rWP e.De*cr%2t%o+OPS
X
X coutJJe+dlS
*electc&*eOPS
X
TO DISPLAY BOOK DETAILS ON THE SCREEN
#o%d )oo3det&%l*OP
T
T
CoI+%t%&l%AeON/LLPS
tr7
T
NRecord*etPtr 2R*tOLAD-DB.Record*etLPS
N)*trNt *trC++OLDRI<ERUT9%cro*oft Acce** Dr%#er
OW.(d)PXS/IDU&d(%+SDBYULIBRARY.(d)LPS
2R*t>K-2e+OLSELECT W $R-9 B--?DETAILS SL6 *trC++6 &d-2e+St&t%c6
&dLoc3Re&d-+l76 &dC(dTe@tPS
coutJJe+dlS
coutJJLB--?N- B--?NA9E A/T;-R EDITI-N P/BLIS;ER ST-C?
LJJe+dlS
2R*t>K9o#e$%r*tOPS
!,
4h%le OZ2R*t>KE+d-f$%leP
T
coutJJe+dlS
coutJJOch&rWP OON)*trNtP 2R*t>Ket$%eld*OP>KetIte(OLB--?N-LP>Ket<&lueOPPJJL
LS
coutJJLMtLS
coutJJOch&rWP OON)*trNtP 2R*t>Ket$%eld*OP>KetIte(OLB--?NA9ELP>
Ket<&lueOPPJJL LS
coutJJLMtLS
coutJJOch&rWP OON)*trNtP 2R*t>Ket$%eld*OP>KetIte(OLA/T;-RLP>Ket<&lueOPPJJL
LS
coutJJLMtLS
coutJJOch&rWP OON)*trNtP 2R*t>Ket$%eld*OP>KetIte(OLEDITI-NLP>
Ket<&lueOPPJJL LS
coutJJLMtLS
coutJJOch&rWP OON)*trNtP 2R*t>Ket$%eld*OP>KetIte(OLP/BLIS;ERLP>Ket<&lueOPPJJL
LS
coutJJOch&rWP OON)*trNtP 2R*t>Ket$%eld*OP>KetIte(OLST-C?LP>Ket<&lueOPPJJL L
JJe+dlS S
HHcoutJJOch&rWP OON)*trNtP 2R*t>Ket$%eld*OP>KetIte(OLR-0N-LP>Ket<&lueOPPJJL
LJJe+dlS
2R*t>K9o#eNe@tOPS
HHcoutJJe+dlS
X
2R*t>KClo*eOPS
X
!1
c&tch ONco(Nerror CeP
T
coutJJOch&rWP e.De*cr%2t%o+OPS
X
FFCo/+%+%t%&l%AeOPS
coutJJe+dlS
*electc&*eOPS
X
X
TO DISPLAY THE DETAILS OF STUDENTS TAKEN BOOKS FROM THE
LIBRARY
#o%d tr&+*&ct%o+det&%l*OP
T
CoI+%t%&l%AeON/LLPS
tr7 T NRecord*etPtr 2R*tOLAD-DB.Record*etLPS
N)*trNt *trC++OLDRI<ERUT9%cro*oft Acce** Dr%#er
OW.(d)PXS/IDU&d(%+SDBYULIBRARY.(d)LPS
2R*t>K-2e+OLSELECT W $R-9 TRANSACTI-NDETAILS SL6 *trC++6 &d-2e+St&t%c6
&dLoc3Re&d-+l76 &dC(dTe@tPS
coutJJL9E9N- BN- B--?NA9E NA9E A/T;-R DATE-$ISS/E
DATE-$RET/RN EDITI-NLJJe+dlS
2R*t>K9o#e$%r*tOPS
4h%le OZ2R*t>KE+d-f$%leP T coutJJe+dlS
!7
coutJJOch&rWP OON)*trNtP 2R*t>Ket$%eld*OP>KetIte(OL9E9N-LP>
Ket<&lueOPPJJL LS
coutJJOch&rWP OON)*trNtP 2R*t>Ket$%eld*OP>KetIte(OLB--?N-LP>
Ket<&lueOPPJJL LS
coutJJOch&rWP OON)*trNtP 2R*t>Ket$%eld*OP>KetIte(OLB--?NA9ELP>
Ket<&lueOPPJJL LS
coutJJOch&rWP OON)*trNtP 2R*t>Ket$%eld*OP>KetIte(OLNA9ELP>
Ket<&lueOPPJJL LS
coutJJOch&rWP OON)*trNtP 2R*t>Ket$%eld*OP>KetIte(OLA/T;-RLP>
Ket<&lueOPPJJL LS
coutJJOch&rWP OON)*trNtP 2R*t>Ket$%eld*OP>
KetIte(OLDATE-$B--?ISS/ELP>K et<&lueOPPJJL LS
coutJJOch&rWP OON)*trNtP 2R*t>Ket$%eld*OP>
KetIte(OLDATE-$B--?RET/RNLP>K et<&lueOPPJJL LS
coutJJOch&rWP OON)*trNtP 2R*t>Ket$%eld*OP>KetIte(OLEDITI-NLP>
Ket<&lueOPPJJL LJJe+dlS
2R*t>K9o#eNe@tOPS
X
2R*t>KClo*eOPS
X
c&tch ONco(Nerror CeP
T coutJJOch&rWP e.De*cr%2t%o+OPS
X
*electc&*eOPS
X
!8
4. OUTPUT !INDO!S
HH9AIN 9EN/
HH9E9BER 9EN/ AND ADDIN A NE0 9E9BER
!9
HHT- - BAC? T- T;E 9AIN 9EN/
."
HHT- ST-RE T;E DETAILS -$ NE0 B--?
.1
HH T- ISS/E B--? T- T;E 9E9BER
HH DISPLAYIN 9E9BER DETAILS
.2
HH T- DISPLAY T;E B--? DETAILS
.!
HH T- DISPLAY T;E TRANSACTI-N DETAILS
HH T- E[IT T;E PR-RA9
..
". CONCLUSION:
I+ th%* 4e le&r+ed (ore &)out do%+' l%)r&r7 (&+&'e(e+t %+ C== &+d
co++ect%+' D&t&)&*e to %t. Th%* 2roject +eed* to refer (ore )oo3* &+d *e&rch 4e)*%te* for
do%+' th%* 2roject. Th%* (&3e* &+ &dd%t%o+&l 3+o4led'e for u* %+ C== &+d <%*u&l C==.
I+ th%* Project 4e co++ected the d&t&)&*e to #%*u&l c== &+d 4e le&r+ed
ho4 to co++ect the d&t&)&*e 4%th c== th%* (&3e* &+ &dd%t%o+&l 3+o4led'e for u* )7
3+o4%+' the det&%l*.
.,