ER Diagram For Library Management System With Tables

0
924

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 NameDescriptionTypeLength
book_IDBook ID numberInt11
bk­titleBook Titlevarchar30
bkeditionBook Editionvarchar30
bk­authorAuthor of the bookvarchar30
bk­publisherPublisher of the bookvarchar30
bkcopiesNumber of copies of the bookInt11
bk_sourceSource of the bookVarchar30
bk_costCost of the bookInt11
bk_remarksStatus of the bookvarchar30

 

Table Name: tblbtr

Field NameDescriptionTypeLength
Borrowers_id(PK)Borrowers ID numberInt11
Book_idBook ID numberint11
stud_IDStudent ID numberInt11
staff_idStaff  ID numberInt11
StaffnameName of the staffvarchar30
studentNOcopiesNumber of books to be borrowedint11
ReleaseDateDate of the publication that was releaseDate30
DueDateDue date of the book to be returnedDate30

 

Table Name: tblreturn

Field NameDescriptionTypeLength
Borrowers_id(PK)Borrowers ID numberInt11
Book_idBook ID numberint11
stud_IDStudent ID numberInt11
staff_idStaff  ID numberInt11
StaffnameName of the staffvarchar30
studentNOcopiesNumber of books to be borrowedint11
ReleaseDateDate of the publication that was releasedDate30
DueDateDue date of the book to be returnedDate30

Table Name: tblclearedrecords

Field NameDescriptionTypeLength
clearID(PK)Specific ID for cleared recordsInt11
browIDBorrowers IDInt11
bookIDBook IDInt11
bookTitleBook TitleVarchar30
studIDStudent IDInt11
studNameStudent NameVarchar30
staffIDStaff IDInt11
staffNameStaff NameVarchar30
StudentcopiesStudent number of book copiesInt11
releaseDateDate of releaseDate11
dueDateDue date of the bookDate11

 

Table Name: tblreports

Field NameDescriptionTypeLength
rptID(PK)Report IDInt11
rptTransaction_IDTransaction IDInt11
rptbookIDBook IDInt11
RptbktitleBook TitleVarchar30
RptrtnbkcopiesreturnBook Number of copiesVarchar30
RptrtndateDate to be returnedDate11
RptremarksRemarks of the BookVarchar30
RptnumberofdaysNumber of days to be borrowedInt11
RptpenaltyA penalty of the studentVarchar30
RptreceiveReceiveVarchar30

 

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.

Leave a Reply

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