This ER (Entity Relationship) Diagram represents the model of Enrollment System Entity. The entity-relationship diagram of Enrollment System shows all the visual instrument of database tables and the relations between Student, Fees, Enrollment, Login etc. It used structure data and to define the relationships between structured data groups of Enrollment System functionalities. The main entities of the Enrollment System are Enrollment, Student, Course, Fees, Examination and Login.
Enrollment System entities and their attributes :
- Enrollment Entity : Attributes of Enrollment are enrollmnet_id, enrollmnet_student_id, enrollmnet_exam_id, enrollmnet_course_id, enrollmnet_title, enrollmnet_type, enrollmnet_description
- Student Entity : Attributes of Student are student_id, student_college_id, student_name, student_mobile, student_email, student_username, student_password, student_address
- Course Entity : Attributes of Course are course_id, course_student_id, course_registration, course_name, course_type, course_year, course_description
- Fees Entity : Attributes of Fees are course_fee_id, course_fee_course_id, course_fee_amount, course_fee_total, course_fee_payment, course_fee_type, course_fee_description
- Examination Entity : Attributes of Examination are exam_id, exam_student_id, exam_roll_number, exam_date exam_name, exam_type, exam_description
- Login Entity : Attributes of Login are login_id, login_user_id, login_role_id, login_username, login_password, login_lastlogin
Description of Enrollment System Database :
- The details of Enrollment is store into the Enrollment tables respective with all tables
- Each entity (Login, Course, Examination, Student, Enrollment) contains primary key and unique keys.
- The entity Course, Examination has binded with Enrollment, Student entities with foreign key
- There is one-to-one and one-to-many relationships available between Examination, Fees, Login, Enrollment
- All the entities Enrollment, Examination, Course, Login are normalized and reduce duplicacy of records
- We have implemented indexing on each tables of Enrollment System tables for fast query execution.