ER Diagram For Library Management System With Tables

This ER Diagram for Library Management System with table will give you an idea on how to make a Database design for a library management system.

The idea presented here can be used for your case study on the library management system. You can enhance the ER diagram for a library management system to suit your system requirements.

What is included in this Database Design for Library Management System?

• Library management system Description with Features
• Library management system database tables
• ER Diagram for Library Management System

Library Management System Description

The library management system was made based on school requirements. The system can register book information.

Librarian has easy access in each book, search tabs for reliable, secure and faster monitoring of books and more importantly a report and evaluation papers can be generated in a well-organized and well-presented reports. (source)

ER Diagram For Library Management System Features

Library Management System Database Tables

These tables below provide the complete database tables details such as Field Name, Descriptions, data types, character lengths.

Table Name: tblbook

Field Name	Description	Type	Length
book_ID	Book ID number	Int	11
bk­title	Book Title	varchar	30
bkedition	Book Edition	varchar	30
bk­author	Author of the book	varchar	30
bk­publisher	Publisher of the book	varchar	30
bkcopies	Number of copies of the book	Int	11
bk_source	Source of the book	Varchar	30
bk_cost	Cost of the book	Int	11
bk_remarks	Status of the book	varchar	30

Table Name: tblbtr

Field Name	Description	Type	Length
Borrowers_id(PK)	Borrowers ID number	Int	11
Book_id	Book ID number	int	11
stud_ID	Student ID number	Int	11
staff_id	Staff  ID number	Int	11
Staffname	Name of the staff	varchar	30
studentNOcopies	Number of books to be borrowed	int	11
ReleaseDate	Date of the publication that was release	Date	30
DueDate	Due date of the book to be returned	Date	30

Table Name: tblreturn

Field Name	Description	Type	Length
Borrowers_id(PK)	Borrowers ID number	Int	11
Book_id	Book ID number	int	11
stud_ID	Student ID number	Int	11
staff_id	Staff  ID number	Int	11
Staffname	Name of the staff	varchar	30
studentNOcopies	Number of books to be borrowed	int	11
ReleaseDate	Date of the publication that was released	Date	30
DueDate	Due date of the book to be returned	Date	30

Table Name: tblclearedrecords

Field Name	Description	Type	Length
clearID(PK)	Specific ID for cleared records	Int	11
browID	Borrowers ID	Int	11
bookID	Book ID	Int	11
bookTitle	Book Title	Varchar	30
studID	Student ID	Int	11
studName	Student Name	Varchar	30
staffID	Staff ID	Int	11
staffName	Staff Name	Varchar	30
Studentcopies	Student number of book copies	Int	11
releaseDate	Date of release	Date	11
dueDate	Due date of the book	Date	11

Table Name: tblreports

Field Name	Description	Type	Length
rptID(PK)	Report ID	Int	11
rptTransaction_ID	Transaction ID	Int	11
rptbookID	Book ID	Int	11
Rptbktitle	Book Title	Varchar	30
Rptrtnbkcopiesreturn	Book Number of copies	Varchar	30
Rptrtndate	Date to be returned	Date	11
Rptremarks	Remarks of the Book	Varchar	30
Rptnumberofdays	Number of days to be borrowed	Int	11
Rptpenalty	A penalty of the student	Varchar	30
Rptreceive	Receive	Varchar	30

Entity Relationship Diagram for Library Management System

ER Diagram for Library Management System shows the system entity relationships in each entity and their supposed functions in each relationship.

Sample ERD for Library system

Based on the image above, the ER diagram for Library Management System is the entity of the library management system database, which is presented by tables;

the tables are made to meet the required specification of the system and provide much more specific details of each entity within the system.

Future Updates

For future updates of this material, I will make a tutorial on how to make an effective library management system project in DBMS.

Any you can make better database design using online database design tools.

Conclusion

This is not yet a complete database project of a Library management system ERD. What you have in this material is for student use only.

FREE DOWNLOAD! 

If you want to see the real application of er diagram library management system, Download here the Library Management System Full source code.

For another free material on database design.

• ER Diagram for Sales and Inventory System Database Design
• Ordering System Database Design with ERD
• ER Diagram for Water Refilling Station System Database Design

Inquiries

If you have any questions or suggestion, please feel free to contact us or you can leave a message below.