7/21/2019 Library Management System

http://slidepdf.com/reader/full/library-management-system-56ddcb8c6eb0a 1/9

CASE STUDY NO 1

PROBLEM STATEMENT :

 This Case Study titled as “LIBRARY MANAGEMENT SYSTEM” is for the purpose ofmaa!i! ad "otrolli! li#rary a"ti$ities%

I this the system eed to add e& studet' add e& #oo(' issue #oo(' retur #oo(ad maitai all re"ords of #oo(s%

USE CASE DIAGRAM :

7/21/2019 Library Management System

http://slidepdf.com/reader/full/library-management-system-56ddcb8c6eb0a 2/9

ACTIVITY DIAGRAM :

7/21/2019 Library Management System

http://slidepdf.com/reader/full/library-management-system-56ddcb8c6eb0a 3/9

7/21/2019 Library Management System

http://slidepdf.com/reader/full/library-management-system-56ddcb8c6eb0a 4/9

SCREENS :

7/21/2019 Library Management System

http://slidepdf.com/reader/full/library-management-system-56ddcb8c6eb0a 5/9

7/21/2019 Library Management System

http://slidepdf.com/reader/full/library-management-system-56ddcb8c6eb0a 6/9

7/21/2019 Library Management System

http://slidepdf.com/reader/full/library-management-system-56ddcb8c6eb0a 7/9

7/21/2019 Library Management System

http://slidepdf.com/reader/full/library-management-system-56ddcb8c6eb0a 8/9

DATABASE TABLES

)% B**+S

BOOK_ID BOOK_NAME NO OF BOOKS

B,,) B-SINESS ANALYST .B,,/ R0BMS 1

/% ST-0ENT 0ETAILS

STU_ID STU_NAME MOBILE EMAIL ID ADDRESS

MBA2,) 3RITES4 5,/6...)17 3MB8 3-NE

7/21/2019 Library Management System

http://slidepdf.com/reader/full/library-management-system-56ddcb8c6eb0a 9/9

1% B**+ ISS-E

STU_ID BOOK_ID BOOK_NAME DATE_OF_ISS

UE

DATE_OF_RET

URN

MBA2,) B,,/ R0BMS )9)9/,): ),9)9/,):

7%

STU_ID BOOK_ID BOOK_NAME RETURN

DATE

FINE

MBA2,) B,,/ R0BMS ))9)9/,): .,

0ATA MA33ING

)%B**+2I0 ; <ILL SEARC4 B**+S TABLE =*R B**+ I0

/%ST-2I0 ; <ILL SEARC4 ST-0ENT 0ETAILS TABLE =*R ST-2I0%