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