Student Counselling Management System ER Diagram

Posted By freeproject on July 17, 2017

This ER (Entity Relationship) Diagram represents the model of Student Counselling Management System Entity. The entity-relationship diagram of Student Counselling Management System shows all the visual instrument of database tables and the relations between Counsellings, Results, Student, Merit List etc. It used structure data and to define the relationships between structured data groups of Student Counselling Management System functionalities. The main entities of the Student Counselling Management System are Student, Counsellings, Registrations, Results, Grade and Merit List.

Student Counselling Management System entities and their attributes :

  • Student Entity : Attributes of Student are student_id, student_college_id, student_name, student_mobile, student_email, student_username, student_password, student_address
  • Counsellings Entity : Attributes of Counsellings are counselling_id, counselling_name, counselling_type, counselling_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
  • Results Entity : Attributes of Results are result_id, result_student_id, result_name, result_description
  • Grade Entity : Attributes of Grade are grade_id, grade_student_id, grade_name, grade_type, grade_description
  • Merit List Entity : Attributes of Merit List are merit_list_id, merit_list_student_id, merit_list_name, merit_list_type, merit_list_description

Description of Student Counselling Management System Database :

  • The details of Student is store into the Student tables respective with all tables
  • Each entity ( Merit List, Registrations, Grade, Counsellings, Student) contains primary key and unique keys.
  • The entity Registrations, Grade has binded with Student, Counsellings entities with foreign key
  • There is one-to-one and one-to-many relationships available between Grade, Results, Merit List, Student
  • All the entities Student, Grade, Registrations, Merit List are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Student Counselling Management System tables for fast query execution.
Student Counselling Management 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)

Bike Showroom Management System ER Diagram

Bike Showroom Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Bike Showroom Management System Entity. The entity-relationship diagram of Bike Showroom Management System shows all the visual instrument of database tables and the relations between Booking, Insurance, Bike, Payment etc. It used...
Crime File Management System ER Diagram

Crime File Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Crime File Management System Entity. The entity-relationship diagram of Crime File Management System shows all the visual instrument of database tables and the relations between Complaints, Charge Sheet, Crime, Criminals etc. It used...
Bus Booking System ER Diagram

Bus Booking System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Bus Booking System Entity. The entity-relationship diagram of Bus Booking System shows all the visual instrument of database tables and the relations between Booking, Sales, Bus, Operators etc. It used structure data and to define the...
Classifieds Management System ER Diagram

Classifieds Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Classifieds Management System Entity. The entity-relationship diagram of Classifieds Management System shows all the visual instrument of database tables and the relations between Location, Categories, Advertisement, Listing etc. It used...
Placement Office Automation ER Diagram

Placement Office Automation ER Diagram

This ER (Entity Relationship) Diagram represents the model of Placement Office Automation Entity. The entity-relationship diagram of Placement Office Automation shows all the visual instrument of database tables and the relations between Users, Resumes, Placements, Registration etc. It used...
Laboratory Management System ER Diagram

Laboratory Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Laboratory Management System Entity. The entity-relationship diagram of Laboratory Management System shows all the visual instrument of database tables and the relations between Lab, Update, Student, Point etc. It used structure data and...