Hi! Today, I’ll share some thoughts on the Entity Relationship Diagram (ERD) of the University Management System.
This small university database will also provide you with a thorough overview of the tables in the University Management System database project.
What are included in this ER Diagram of University Management System Database projects?
- University Management System Description with Features
- University management system database tables
- Schema diagram for University management system
- ER Diagram for University Management System
Description of University Management System Database:
- The details of Colleges is store into the Colleges tables respective with all tables.
- Each entity ( Registrations, Classes, Courses, Students, Colleges) contains primary key and unique keys.
- The entity Classes, Courses has binded with Colleges, Students entities with foreign key . There is one-to-one and one-to-many relationships available between Courses, Faculties, Registrations, Colleges.
- All the entities Colleges, Courses, Classes, Registrations are normalized and reduce duplicacy of records . We have implemented indexing on each tables of University Management System tables for fast query execution.
University Management System Entities and their Attributes:
- Colleges Entity: Attributes of Colleges are college_id, college_name, college_description, college_address,
- Students Entity : Attributes of Students are student_id, student_college_id, student_name, student_mobile, student_email, student_username, student_password, student_address
- Classes Entity : Attributes of Classes are class_id, class_student_id, class_name, class_room, class_type, class_description
- Faculties Entity: Attributes of Faculties are faculty_id, faculty_teacher_id, faculty_name, faculty_room, faculty_type, faculty_description
- Courses Entity : Attributes of Courses are course_id, course_student_id, course_registration, course_name, course_type, course_year, course_description
- Registrations Entity : Attributes of Registrations are registration_id, registration student_id, registration_course_id, registration_name, registration_type, registration_number, registration_date, registration_description
ER Diagram of University Management System With Features
Time needed: 5 minutes
Here’s the database design for the University Management System with an ER Diagram of the University Management System that includes Tables, Schema, PDF, etc.
- University Management
The key aspect of this system is University Management, which includes an ER diagram and essential university information. The courses and programs available were used to provide this basic information.
- Student Management
This feature is very vital to the system because it collects all of the students’ important information. These details were utilized to keep track of their transactions and other key system details.
- Manage Courses and Subjects
The university administrator will need to set each student’s preferred courses, and then assign relevant instructors to each course’s subjects.
- Manage Instructors
This system manages the instructors’ information, as well as their entire calendar of classes and everything else related to instructor management.
- Transaction and Scheduling Management
Its feature will save student and instructor transactions, including their information and schedules for all subjects and timetables.
University Management System Database Tables
The tables below provide the complete database table details such as Field Name, Descriptions, data types, and character lengths.
Table Name:tbl_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: tbl_Instructor
| Field | Description | Type | Length |
| ins_ID (PK) | Instructor 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 |
| ins_email | Instructor Email | Varchar | 255 |
| ins_pass | Instructor Password | Varchar | 255 |
Table Name:tbl_ Course
| Field | Description | Type | Length |
| course_ID (PK) | Course ID | Int | 11 |
| course_name | Course Name | Varchar | 30 |
| course_desc | Course Description | Varchar | 30 |
| school_yr | School Year | Int | 11 |
Table Name: tbl_Subjects
| Field | Description | Type | Length |
| sub_ID (PK) | Subject ID | Int | 11 |
| name | Subject Name | Varchar | 255 |
| course_ID (FK) | Course ID | Int | 11 |
Table Name: tbl_Schedules
| Field | Description | Type | Length |
| sched_ID (PK) | Schedule ID | Int | 11 |
| course_ID (FK) | Course ID | Int | 11 |
| sub_ID (FK) | Subject ID | Int | 11 |
| ins_ID (FK) | Instructor ID | Int | 11 |
| stud_ID (FK) | Student ID | Int | 11 |
| day | Day of schedule | Date | |
| time_start | Starting Time | Time | |
| time_end | Time Ended | Time |
Table Name:tbl_Transactions
| Field | Description | Type | Length |
| trans_ID (PK) | Transaction ID | Int | 11 |
| trans_name | Transaction Name | Int | 11 |
| stud_ID (FK) | Student ID | Int | 11 |
| trans_date | Transaction Date | Date |
Entity Relationship Diagram of University Management System
Entity Relationship Diagram Symbols
ER Diagram of University Management System with Relationship
ER Diagram of the University Management System shows the system entity relationships in each entity and their supposed functions in each relationship.
This section will show you the ER Diagram of the University Management System.
In the image below you see the actual relationship of all entities.
In creating this activity diagram we used lucidchart.
ER Diagram of University Management System
The database design shown with tables in the Entity Relationship diagram of the University Management System is shown in the image above.
The tables are designed to suit the system’s requirements and to provide considerably more detailed information about each entity within the system.
Conclusion
To summarize, we have discussed the ER diagram for the University Management System, and above we have the system database tables and their relationships.
Inquiries
If you have inquiries or suggestions about the ER Diagram of the University Management System just leave us your comments below.
We would be glad to know to concerns and suggestions and be part of your learning.
Keep us updated and Good day!