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
ER Diagram For Library Management System
- Book Management
Book Management is the main feature of this er diagram for library management system wherein it contains the basic details of books.
- User Management
This feature is only an add on to ER diagram for library management system it contain all the necessary information of the users.
- 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 |
| bktitle | Book Title | varchar | 30 |
| bkedition | Book Edition | varchar | 30 |
| bkauthor | Author of the book | varchar | 30 |
| bkpublisher | 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.
