ER Diagram For Library Management System With Tables

0
115

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.

ER Diagram For Library Management System Featured
ER Diagram For Library Management System Featured

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)

Features of LMS

  • Book Management
  • User Management
  • Manage Books Inventory
  • Generate user-Friendly Reports
  • Student management system

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

"<yoastmark

 

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.

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

Facebook Comments

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.