Faculty Management System ER Diagram

Posted By freeproject on July 17, 2017

This ER (Entity Relationship) Diagram represents the model of Faculty Management System Entity. The entity-relationship diagram of Faculty Management System shows all the visual instrument of database tables and the relations between Faculty, Teacher, Leave, Subject etc. It used structure data and to define the relationships between structured data groups of Faculty Management System functionalities. The main entities of the Faculty Management System are Leave, Faculty, Student, Teacher, Course and Subject.

Faculty Management System entities and their attributes :

  • Leave Entity : Attributes of Leave are leave_id, leave_employee_id, leave_type, leave_status, leave_to, leave_from, leave_description
  • Faculty Entity : Attributes of Faculty are faculty_id, faculty_teacher_id, faculty_name, faculty_room, faculty_type, faculty_description
  • Student Entity : Attributes of Student are student_id, student_college_id, student_name, student_mobile, student_email, student_username, student_password, student_address
  • Teacher Entity : Attributes of Teacher are teacher_id, teacher_exam_id, teacher_name, teacher_mobile, teacher_email, teacher_username, teacher_password, teacher_address
  • Course Entity : Attributes of Course are course_id, course_student_id, course_registration, course_name, course_type, course_year, course_description
  • Subject Entity : Attributes of Subject are subject_id, subject_course_id, subject_student_id, subject_name, subject_type, subject_description

Description of Faculty Management System Database :

  • The details of Leave is store into the Leave tables respective with all tables
  • Each entity (Subject, Student, Course, Faculty, Leave) contains primary key and unique keys.
  • The entity Student, Course has binded with Leave, Faculty entities with foreign key
  • There is one-to-one and one-to-many relationships available between Course, Teacher, Subject, Leave
  • All the entities Leave, Course, Student, Subject are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Faculty Management System tables for fast query execution.
Faculty Management System ER Diagram
Get 6 diagrams only in 300/- or $6.99 USD.
Call or WhatsApp us on +91-8470010001 for more details.

Project Category

Related Entity Relationship Diagram (ERD)

Library Management System ER Diagram

Library Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Library Management System Entity. The entity-relationship diagram of Library Management System shows all the visual instrument of database tables and the relations between Books, Librarian, Student, Address etc. It used structure data...
Contract Management System ER Diagram

Contract Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Contract Management System Entity. The entity-relationship diagram of Contract Management System shows all the visual instrument of database tables and the relations between Authoring, Reporting, Contract, Tenders etc. It used structure...
Restaurent Management System ER Diagram

Restaurent Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Restaurent Management System Entity. The entity-relationship diagram of Restaurent Management System shows all the visual instrument of database tables and the relations between Employees, Sells, Restaurent, Orders etc. It used structure...
Leave Management System ER Diagram

Leave Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Leave Management System Entity. The entity-relationship diagram of Leave Management System shows all the visual instrument of database tables and the relations between Branch, Leave, Company, Employee etc. It used structure data and to...
Fashion Model Management System ER Diagram

Fashion Model Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Fashion Model Management System Entity. The entity-relationship diagram of Fashion Model Management System shows all the visual instrument of database tables and the relations between Models, Events, Fashion, ##keyword6## etc. It used...
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...

Customer ER Diagram

This ER (Entity Relationship) Diagram represents the model of Customer Entity. The entity-relationship diagram of Customer shows all the visual instrument of database tables and the relations between Order, Sales, Customer, Payment etc. It used structure data and to define the relationships between...
Blogging System ER Diagram

Blogging System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Blogging System Entity. The entity-relationship diagram of Blogging System shows all the visual instrument of database tables and the relations between Blog Category, Blog Type, Blog, Technology Blog etc. It used structure data and to...
Reseller Management System ER Diagram

Reseller Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Reseller Management System Entity. The entity-relationship diagram of Reseller Management System shows all the visual instrument of database tables and the relations between Order, Company, Reseller, Company Type 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...