Open In App

ER diagram of Library Management System

Last Updated : 19 Jan, 2024
Improve
Improve
Like Article
Like
Save
Share
Report

ER Diagram is known as Entity-Relationship Diagram, it is used to analyze  the structure of the Database. It shows relationships between entities and their attributes. An ER Model provides a means of communication. 

The Library Management System database keeps track of readers with the following considerations –

  • The system keeps track of the staff with a single point authentication system comprising login Id and password.
  • Staff maintains the book catalog with its ISBN, Book title, price(in INR), category(novel, general, story), edition, author Number and details.
  • A publisher has publisher Id, Year when the book was published, and name of the book.
  • Readers are registered with their user_id, email, name (first name, last name), Phone no (multiple entries allowed), communication address. The staff keeps track of readers.
  • Readers can return/reserve books that stamps with issue date and return date. If not returned within the prescribed time period, it may have a due date too.
  • Staff also generate reports that has readers id, registration no of report, book no and return/issue info.

Note:

Follow given link to build a Web application on Library Management System.

Below is the ER Diagram for Library Management System:

ER Diagram of Library Management System

This Library ER diagram illustrates key information about the Library, including entities such as staff, readers, books, publishers, reports, and authentication system. It allows for understanding the relationships between entities. 

Entities and their Attributes –

  • Book Entity : It has authno, isbn number, title, edition, category, price. ISBN is the Primary Key for Book Entity.
  • Reader Entity : It has UserId, Email, address, phone no, name. Name is composite attribute of firstname and lastname. Phone no is multi valued attribute. UserId is the Primary Key for Readers entity.
  • Publisher Entity : It has PublisherId, Year of publication, name. PublisherID is the Primary Key.
  • Authentication System Entity : It has LoginId and password with LoginID as Primary Key.
  • Reports Entity : It has UserId, Reg_no, Book_no, Issue/Return date. Reg_no is the Primary Key of reports entity.
  • Staff Entity : It has name and staff_id with staff_id as Primary Key.
  • Reserve/Return Relationship Set : It has three attributes: Reserve date, Due date, Return date.

Relationships between Entities – 

  • A reader can reserve N books but one book can be reserved by only one reader. The relationship 1:N.
  • A publisher can publish many books but a book is published by only one publisher. The relationship 1:N.
  • Staff keeps track of readers. The relationship is M:N.
  • Staff maintains multiple reports. The relationship 1:N.
  • Staff maintains multiple Books. The relationship 1:N.
  • Authentication system provides login to multiple staffs. The relation is 1:N.

Previous Article
Next Article

Similar Reads

Class Diagram for Library Management System
In Object - Oriented modelling , the main building block generally represents different objects in a system, their attributes, their different functions, and relationships among objects. These building blocks are known as Class Diagram. Class diagrams are generally used for conceptual modeling of static view of a software application, and for model
4 min read
Use Case Diagram for Library Management System
A use case diagram in UML helps to show the various ways in which a user could interact with a system. For a Library Management System, the use case diagram helps visualize the interactions between users (actors) and the system's functionalities (use cases). This diagram provides a clear, simplified way to understand how the system operates and wha
4 min read
ER diagram of Bank Management System
ER diagram is known as Entity-Relationship diagram. It is used to analyze to structure of the Database. It shows relationships between entities and their attributes. An ER model provides a means of communication. ER diagram of Bank has the following description : Bank have Customer.Banks are identified by a name, code, address of main office.Banks
3 min read
Library Management System Using Switch Statement in Java
Here we are supposed to design and implement a simple library management system using a switch statement in Java, where have operated the following operations Add a new book, Check Out a book, display specific book status, search specific book, and display book details using different classes. Follow the given link to build the Library Management S
9 min read
DFD for Library Management System
Data Flow Diagram (DFD) depicts the flow of information and the transformation applied when data moves in and out of a system. The overall system is represented and described using input, processing, and output in the DFD. The inputs can be: Book request when a student requests for a book.Library card when the student has to show or submit his/her
2 min read
How to build Library Management System using Node.js?
In this article, we are going to create a Library Management System. A Library Management System is basically used to manage the book record of a Library, where a librarian can view all the available books, add new books, delete books, issue books, and return books. Note: Follow given link to build a Web application on Library Management System. Fu
9 min read
E -Library Management System
In this article, we will discuss the approach to creating an E-Library Management System where the user has the following options: Add book information.Display book information.To list all books of a given author.To list the count of books in the library. [caption width="800"]E -Library Management System[/caption] Functionalities Required:If the us
10 min read
Library Management System Project | Software Development
Library Management System is one of the most common software development projects till date. In this article, we are going to make the Library Management System software development project, from scratch, for final year students. We will be covering all the steps you have to do while developing this project. [caption width="800"]Library Management
70 min read
Library Management Application Backend
Library Management System backend using Express and MongoDB contains various endpoints that will help to manage library users and work with library data. The application will provide an endpoint for user management. API will be able to register users, authenticate users, borrow books, return books, create books, pay fine . We'll be using NodeJS, Ex
10 min read
Database Management System - GATE CSE Previous Year Questions
Solving GATE Previous Year's Questions (PYQs) not only clears the concepts but also helps to gain flexibility, speed, accuracy, and understanding of the level of questions generally asked in the GATE exam, and that eventually helps you to gain good marks in the examination. Previous Year Questions help a candidate practice and revise for GATE, whic
5 min read