Enrollment System ER Diagram

Posted By freeproject on July 17, 2017

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.
Enrollment System ER Diagram
Get 6 diagrams only in 300/- or $6.99 USD.
Call or WhatsApp us on +91-8470010001 for more details.

Related Entity Relationship Diagram (ERD)

Super Market Management System ER Diagram

Super Market Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Super Market Management System Entity. The entity-relationship diagram of Super Market Management System shows all the visual instrument of database tables and the relations between Customer, Sales, Stores, Products etc. It used...
Railway Ticket Booking Portal ER Diagram

Railway Ticket Booking Portal ER Diagram

This ER (Entity Relationship) Diagram represents the model of Railway Ticket Booking Portal Entity. The entity-relationship diagram of Railway Ticket Booking Portal shows all the visual instrument of database tables and the relations between Timetable, Stations, Trains, Customers etc. It used...
Clinic Appointment System ER Diagram

Clinic Appointment System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Clinic Appointment System Entity. The entity-relationship diagram of Clinic Appointment System shows all the visual instrument of database tables and the relations between Patient, Booking, Clinic, Doctor Schedule etc. It used structure...
Contractor Management System ER Diagram

Contractor Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Contractor Management System Entity. The entity-relationship diagram of Contractor Management System shows all the visual instrument of database tables and the relations between Company, Timesheet, Contract, Salary etc. It used structure...
Exam Seating Management System ER Diagram

Exam Seating Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Exam Seating Management System Entity. The entity-relationship diagram of Exam Seating Management System shows all the visual instrument of database tables and the relations between Block, Exam, Student, Teacher etc. It used structure...
Store Management System ER Diagram

Store Management System ER Diagram

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