College Management System ER Diagram

July 17 2017

Posted By: freeproject
Comments: 0

Posted By freeproject on July 17, 2017

This ER (Entity Relationship) Diagram represents the model of College Management System Entity. The entity-relationship diagram of College Management System shows all the visual instrument of database tables and the relations between Books, Issues, Library, Branch etc. It used structure data and to define the relationships between structured data groups of College Management System functionalities. The main entities of the College Management System are Library, Books, Students, Issues, Managers and Branch.

College Management System entities and their attributes :

Library Entity : Attributes of Library are library_id, library_book_id, library_name, library_branch, library_place, library_type, library_description
Books Entity : Attributes of Books are book_id, book_student_id, book_name, book_author, book_publication_date, book_type, book_price, book_description
Students Entity : Attributes of Students are student_id, student_college_id, student_name, student_mobile, student_email, student_username, student_password, student_address
Issues Entity : Attributes of Issues are issue_id, issue_book_id, issue_student_id, issue_date, issue_renewl, issue_expiry, issue_description
Managers Entity : Attributes of Managers are manager_id, manager_library_id, manager_name, manager_mobile, manager_email, manager_username, manager_password, manager_address
Branch Entity : Attributes of Branch are branch_id, branch_name, branch_type, branch_city, branch_address

Description of College Management System Database :

The details of Library is store into the Library tables respective with all tables
Each entity (Branch, Students, Managers, Books, Library) contains primary key and unique keys.
The entity Students, Managers has binded with Library, Books entities with foreign key
There is one-to-one and one-to-many relationships available between Managers, Issues, Branch, Library
All the entities Library, Managers, Students, Branch are normalized and reduce duplicacy of records
We have implemented indexing on each tables of College Management System tables for fast query execution.

College Management System ER Diagram Project Source Code and Database

PHP Projects on College Management System

PHP and MySQL Project on College Management System College Management System is a mini php project that is used to keep and maintain the complete record of Students. In this mini project is to provides keep the record of students, courses, attendance, fees. We have developed this mini project...

PHP Projects on College Information System

PHP and MySQL Project on College Information System This mini project College Information System has been developed on PHP and MySQL. The main aim of this mini project is to develop which provides all the information relates to College. There is a single user admin in this mini php project...

Java Projects, JSP Projects on College Event Management System

Java, JSP and MySQL Project on College Event Management System This Project College Event Management System has been developed on Java, JSP and MySQL. We are providing java software projects with source code for student purpose. The main aim for developing this project is to provide details...

HTML Projects, JavaScript, O Level Projects on College Website

HTML, CSS and JavaScript Project on College System This project College System has been developed on HTML, CSS, and JavaScript. The main objective of developing this project was to create a static website for the College, from which user can get the details of the college, teacher and student,...

Visual Basic and SQL Server 2000 Project on College Management System

Visual Basic Projects on College Management System

Visual Basic Project on College Management System College Management System is a desktop application. We have used Visual Basic 6 and SQL Server 2000 for developing this project. Here we are providing visual basic 6.0 projects with ms access database download with source code and documentation...

Get 6 diagrams only in 300/- or $6.99 USD.
Call or WhatsApp us on +91-8470010001 for more details.

Project Category

Related Entity Relationship Diagram (ERD)

University Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of University Management System Entity. The entity-relationship diagram of University Management System shows all the visual instrument of database tables and the relations between Students, Faculties, Colleges, Registrations etc. It used...

Attendance Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Attendance Management System Entity. The entity-relationship diagram of Attendance Management System shows all the visual instrument of database tables and the relations between Employee, Holidays, Attendance, Login etc. It used...

Onile Gas Booking System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Onile Gas Booking System Entity. The entity-relationship diagram of Onile Gas Booking System shows all the visual instrument of database tables and the relations between Connections , Bookings , Gas , Delivery etc. It used structure...

Media Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Media Management System Entity. The entity-relationship diagram of Media Management System shows all the visual instrument of database tables and the relations between Images, Category, Media, Uploads etc. It used structure data and to...

Institution Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Institution Management System Entity. The entity-relationship diagram of Institution Management System shows all the visual instrument of database tables and the relations between Courses, Faculties, Students, Fees etc. It used structure...

Helpdesk Ticketing System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Helpdesk Ticketing System Entity. The entity-relationship diagram of Helpdesk Ticketing System shows all the visual instrument of database tables and the relations between Support, Client, Ticket, Track etc. It used structure data and to...

Shopping Cart System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Shopping Cart System Entity. The entity-relationship diagram of Shopping Cart System shows all the visual instrument of database tables and the relations between Category, Cart, Products, Orders etc. It used structure data and to define...

Grading System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Grading System Entity. The entity-relationship diagram of Grading System shows all the visual instrument of database tables and the relations between Examinations, Papers, Students, Result etc. It used structure data and to define the...

Restaurent Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Restaurent Management System Entity. The entity-relationship diagram of Restaurent Management System shows all the visual instrument of database tables and the relations between Employees, Sells, Restaurent, Orders etc. It used structure...

Golf Scoring System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Golf Scoring System Entity. The entity-relationship diagram of Golf Scoring System shows all the visual instrument of database tables and the relations between Players, Sorts, Golf, Length etc. It used structure data and to define the...