LIBRARY
MANAGEMENT
MINI
PROJECT
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Guidelines and tips
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Amazing java microproject in this field
Typology: Assignments
2025/2026
1 / 10
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download Mini project for java and more Assignments Computer science in PDF only on Docsity!
LIBRARY
MANAGEMENT
MINI
PROJECT
TEAM
Abdullah
Boat
Saad
Ansari
Abdullah
Ansari
Rehan
Shaikh
TABLE
STRUCTURE
STUDENT ID, STUDENT NAME,
GENDER, DEPARTMENT, CONTACT
NUMBER
BOOK ID, BOOK TITLE, AUTHOR,
CATEGORY, BOOK PRICE
ISSUED DATE, DUE DATE, RETURN
DATE, FINE, MEMBERSHIP TYPE,
BOOK STATUS, ADDRESS
MEMEBERSHIP
- (^) This pie chart shows the distribution of library memberships.
- (^) Gold is the largest category at 42%, followed by Regular at 33% and Premium at 25%.
- (^) Gold membership is clearly the most popular choice among users.
CONCEPT
Present with ease using automated Excel formulas like VLOOKUP to quickly fetch any student’s full record based on their Student ID. Eg. When a Student ID is entered, all related details (name, gender, contact, book info) appear instantly, reducing manual search time.
CONCEPT
Add smart Excel logic
(using IF, DATEDIF,
TODAY functions) to
calculate fi nes based on
overdue return dates
dynamically.
Eg.
If a book is not returned,
the system instantly
calculates the fi ne as the
number of late days
multiplied by the fi ne rate,
updating live as dates
change.
CONCEPT
It’s excellent for tracking and capturing details about students with the highest fi nes by sorting and displaying a “Top 10 Fines List.” Eg. The system displays the student name, book, department, and amount due in a dedicated section— making follow-up easy and improving accountability.
AUTOMATED
STUDENT RECORD
SEARCH
DYNAMIC FINE
CALCULATION
TOP FINE DEFAULTER
TRACKING
FORMULAS
- FETCH DATA BY STUDENT ID: =VLOOKUP(C3,SHEET1!$A$2:$Q$101,COLUMN,FALSE) GETS INFO LIKE NAME, GENDER, ETC. WHEN YOU ENTER STUDENT ID.
- FINE CALCULATION: =IF(RETURNDATE="NOT RETURNED", IF(TODAY()>DUEDATE, DATEDIF(DUEDATE,TODAY(),"D"), 0), IF(RETURNDATE>DUEDATE, DATEDIF(DUEDATE,RETURNDATE,"D"), 0)) GIVES OVERDUE DAYS AS FINE.
- TOP 10 HIGHEST FINE: =IF(N="NOT RETURNED", IF(TODAY()>M, DATEDIF(M,TODAY(),"D"), 0), IF(N>M, DATEDIF(M,N,"D"), 0)) FOR EACH STUDENT IN TOP 10 TABLE (CHANGE N, M AS PER ROW).