This ER (Entity Relationship) Diagram represents the model of School Management System Entity. The entity-relationship diagram of School Management System shows all the visual instrument of database tables and the relations between Students, Teachers, Schools, Registrations etc. It used structure data and to define the relationships between structured data groups of School Management System functionalities. The main entities of the School Management System are Schools, Students, Classes, Teachers, Cources and Registrations.
School Management System entities and their attributes :
- Schools Entity : Attributes of Schools are school_id, school_name, school_type, school_description
- 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
- Teachers Entity : Attributes of Teachers are teacher_id, teacher_college_id, teacher_name, teacher_mobile, teacher_email, teacher_username, teacher_password, teacher_address
- Cources Entity : Attributes of Cources 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
Description of School Management System Database :
- The details of Schools is store into the Schools tables respective with all tables
- Each entity ( Registrations, Classes, Cources, Students, Schools) contains primary key and unique keys.
- The entity Classes, Cources has binded with Schools, Students entities with foreign key
- There is one-to-one and one-to-many relationships available between Cources, Teachers, Registrations, Schools
- All the entities Schools, Cources, Classes, Registrations are normalized and reduce duplicacy of records
- We have implemented indexing on each tables of School Management System tables for fast query execution.