dbms online library management system.pptx

Online library management system

1. TOPIC : LIBRARY MANAGEMENT SYSTEM Presented by: Varshitha G.A 1DA21CS159 Yashaswini .S 1DA21CS170 Submitted To: Veena Potdar Assistant professor Dept of CSE, DR.AIT DR.AMBEDKAR INSTITUTE OF TECHNOLOGY

2. OVERVIEW To build a library management which contains two login :- student and admin(librarian). 2. There will be various features like Searching of books Issuing and returning books Paying fine(if any) Librarian can read information about any member Librarian can track the books issued by a particular student and add books

3. 1 - Student Login / Admin Login Authentication of the user will be there. Id and password will be matched from our database. Once both Id and password matches, then only a user is allowed to enter into the system. Similarly for admin there will be a authentication system.

4. 2 - Signup For New Users For new users there will be sign up option Various details like name, password , email id and phone no etc. will be taken from the user and then it will be updated in our database. After this , the user will be redirected to the login page.

5. 3 - Admin Panel After successful login admin can keep track of the books issued It can also track various other details such as Fine of all students. Requested books from the student Issuing of books The number of copies of book The information on list of students and deleting students Can add ,delete admin and books List of all admin and their information List of all student and their information

6. Module 4 - Student Profile After successful login into system, user can see its details Various details which will be shown are:- Issued books Date of issue When to return Current fine the user has to pay Searching book in the library. Request the book

7. 5 – Books Books present in the library can be searched The books can be searched on book Id. The books can be requested by student The admin allocates the books to student based on availability and requested book and admin can update the quantity of books and can delete the books. The books which are allotted and borrowed can be seen on both student and admin side , student can see only their book list but admin can see book list of all students

8. 6 – Fine. The student who has not returned the book and whose return date is greater than current date, the status of that student will be set as non-returned and no fine. The student who has not returned the book and whose return date is less than current date, the status of that student will be set as non-returned and fine will be set to it. The student who has returned the book and whose return date is less than current date, the status of that student will be set as returned and fine will be set to it . If not these above conditions, then student status is set to returned with no fine

9. ER DIAGRAM It is clear that the physical objects from the previous section – the member, books, library – correspond to entities in the Entity-Relationship model, and the operations to be done on those entities – holds, checkouts, and so on – correspond to relationships. However, a good design will minimize redundancy and attempt to store all the required information in as small a space as possible.

10. Thank You