College Library Management System (ER) Entity Relationship Diagram in DBMS
Hi there Itsourcecoders! Today I will give you ideas about the College Library Management System Entity Relationship Diagram (ERD) for 2021. This simple database will also give you deep understanding about College Library management system database project with ER Diagrams tables. This will teach you in managing College Library database as well as the relationships of tables in College management system project database design. By the end of the discussion you will find the College Library Management system ER diagram PDF and PPT files that will be helpful for your studies in DBMS.
ThisEntity Relationship Diagram for the College Library Management System project with a table will also give you the idea ofhow to make a database design for aCollege Library management system withERD,tables, andschema .
The idea presented here can be used for your College Library management system final year project. You can enhance theER diagram for asystem in this article to meet your desiredsystem requirements.
What are included in this ER Diagram for College Library Management System Database projects 2021?
- Library management system Description with Features
- College Library management system database tables
- Simple diagram for College Library management system
- ER Diagram for College Library Management System
College Library Management System ER Diagram Description
Thiscollege library management system database design was made based on managing library requirements. The system can encode students or borrowers' information. College admin can have access to the students' status and information for borrowing transaction. They can handle the data needed in managing books files as well as the transactions made by their borrowers.
The features included in the system ER diagram were the security and monitoring of the book and borrowers' records, transactions and status. These features were also listed and recorded in reports that served as the history of transactions done in the system.
ER Diagram For College Library Management System With Tables and Features
Time needed:5 minutes.
Here's the simple database design for college library management system with ER Diagram of college management system 2021 that includes Tables, PPT, PDF, etc.
- College Library Management
College Library Management is the main feature of this system wherein ER diagram and it contains the basic details of the library. These basic information was composed of the basic information of books and the transactions done by the borrowers.
- Student Management
This feature plays a big role for the system because this gathers the important information of the students. These information were used to track their transactions and other important matters regarding the system.
- Manage Book Borrowing
The book borrowing management will be done by the college admin/librarian to track the transaction made by the borrowers. This process will help them in updating the status of the books and tracing their borrowers.
- Manage Books Information and Status
The college admin will have to manage the basic information of the books that are available at the library. This management will cover from encoding the essential information of the book to the system as well as updating its status.
- Transaction and Retuning Management
Its feature will store the transactions made by the students during borrowing and to generate reports according to the transactions made for tracing purposes.
College Library Management System Entity Relationship Diagram Tables
These tables below provide the complete database tables details such asField Name,Descriptions,data types,character lengths.
Table Name: Student
| Field | Description | Type | Length |
| stud_ID (PK) | Student ID | Int | 11 |
| fname | Student First Name | Varchar | 255 |
| lname | Student Last Name | Varchar | 255 |
| gender | Student Gender | Int | 11 |
| age | Student Age | Int | 11 |
| contact_add | Contact Address | Int | 11 |
| stud_email | Student Email | Varchar | 255 |
| stud_pass | Student Password | Varchar | 255 |
Table Name: Users
| Field | Description | Type | Length |
| user_ID (PK) | User ID | Int | 11 |
| fname | Instructor First Name | Varchar | 255 |
| lname | Instructor Last Name | Varchar | 255 |
| gender | Instructor Gender | Int | 11 |
| age | Instructor Age | Int | 11 |
| contact_add | Contact Address | Int | 11 |
| user_email | User Email | Varchar | 255 |
| user_pass | User Password | Varchar | 255 |
Table Name: Book
| Field | Description | Type | Length |
| book_ID (PK) | Book ID | Int | 11 |
| bk_title | Book Title | Varchar | 30 |
| bk_name | Book Name | Varchar | 30 |
| publisher | Publisher | Varchar | 30 |
| author | Author | Varchar | 30 |
| bk_num | Book Number | Int | 11 |
| pub_date | Date Published | Date |
Table Name: Borrowing
| Field | Description | Type | Length |
| borrowing_ID (PK) | Borrowing ID | Int | 11 |
| book_ID (FK) | Book ID | Int | 11 |
| stud_ID (FK) | Student ID | Int | 11 |
| date_borrowed | Borrowing Date | Date | |
| date_return | Returning Date | Date |
Table Name: Transaction
| Field | Description | Type | Length |
| trans_ID (PK) | Transaction ID | Int | 11 |
| trans_name | Transaction Name | Varchar | 30 |
| borrowing_ID (FK) | Subject ID | Int | 11 |
| stud_ID (FK) | Student ID | Int | 11 |
| trans_date | Date of Transaction | Date |
Table Name: Reports
| Field | Description | Type | Length |
| report_ID (PK) | Report ID | Int | 11 |
| trans_ID (FK) | Transaction ID | Int | 11 |
| borrowing_ID (FK) | Borrowing ID | Int | 11 |
| report_date | Report Date | Date |
Entity Relationship Diagram for College Library Management System
ER Diagram of College Library Management System shows the system entity relationships in each entity and their supposed functions in each relationship.
Sample ER Diagram for College Library Management System Project
Based on the image above, theEntity Relationship diagram forthis System is the entity of the college library management system database, which is presented bytables.
The tables are made to meet the required specification of the system and provide much more specific details of each entity within the system.
You can now have the PPT and PDF file of the College Library Management System ER Diagram for you to have your own copy and basis for your future studies in DBMS.
Conclusion
So that completes our discussion about ER Diagram project fellas, and I hope that this article about ER Diagram For College Library Management System Database Design 2021 will help you a lot.
Now let me ask you something. What have you learned through the discussion?
May this article help you with your projects in the future!
If you have inquiries or suggestions about Entity Relationship Diagram (ERD) for College Library Management System just leave us your comments below.
Keep us updated and Good day!
Related Articles:
- Best ER Diagram In DBMS With Examples 2020
- ER Diagram for Hospital Management System | [2020]
- Hotel Management System ER Diagram |Best Database Design 2021
- ER Diagram For Library Management System Database Design 2021
- Barangay Information System ER Diagram
- Student Registration System ER Diagram
- Bus Reservation System ER Diagram | Entity Relationship Diagram
- Enrollment System ERD | Entity Relationship Diagram
- Online Ordering System ER Diagram | Entity Relationship Diagram
- School Management System ER Diagram
- Payroll Management System ER Diagram | Itsourcecode.com 2021
- Loan Management System ER Diagram | Entity Relationship Diagram
- Online Shopping System ER Diagram | Entity Relationship Diagram
- Blood Bank Management System ER (Entity Relationship) Diagram
- Bank Management System ER Diagram | Entity Relationship Diagram
- College Library Management System ER Diagram
- ER Diagram For Student Management System Database Design 2021
- Online Ticket Booking System ER Diagram
- Pharmacy Management SystemER Diagram
- Railway Management System ER Diagram
- Car Rental System ER Diagram | Entity Relationship Diagram
- Attendance Management System (ERD) Entity Relationship Diagram
- Laundry Management System Database Design | ERD|TABLES
- Employee Attendance Management System ER Diagram
- Employee Management System ER Diagram
- Airline Reservation System ER Diagram | Entity Relationship Diagram
- ER Diagram of Gym Management System | Entity Relationship Diagram
- ATM Management System ER Diagram | Entity Relationship Diagram
- E-commerce Website ER Diagram (ERD) | Entity Relationship Diagram
- Employee Attendance Management System ER Diagram | ERD
- Library Management System Java Project With Source Code
- Library Management System Project In Django With Source Code
- School Library Management System in C# with Source Code
- Library System in JavaScript with Source Code
- Library Management System In C++ With Source Code
- Online Library Management System in PHP Source Code
- Library Management System In C With Source Code
- Library Management System Project In Python and MySQL
- Create a DynamicLibrary Link (.dll) in VB.Net
- Library Management System Free Source Code
- Library Management System for St. Columban's Academy with Sample Program
Source: https://itsourcecode.com/uml/college-library-management-system-er-diagram/
Posted by: hermanbillupse0189337.blogspot.com
