Employee Management System ER Diagram

Posted By freeproject on July 17, 2017

This ER (Entity Relationship) Diagram represents the model of Employee Management System Entity. The entity-relationship diagram of Employee Management System shows all the visual instrument of database tables and the relations between Salary, Experience, Employee, Attendance etc. It used structure data and to define the relationships between structured data groups of Employee Management System functionalities. The main entities of the Employee Management System are Employee, Salary, Leaves, Experience, Login and Attendance.

Employee Management System entities and their attributes :

  • Employee Entity : Attributes of Employee are employee_id, employee_name, employee_mobile, employee_email, employee_username, employee_password, employee_address
  • Salary Entity : Attributes of Salary are salary_id, salary_employee_id, salary_amount, salary_total, salary_type, salary_description
  • Leaves Entity : Attributes of Leaves are leave_id, leave_employee_id, leave_type, leave_status, leave_to, leave_from, leave_description
  • Experience Entity : Attributes of Experience are experience_id, experience_employee_id, experience_year, experience_type, experience_description
  • Login Entity : Attributes of Login are login_id, login_user_id, login_role_id, login_username, login_password, login_lastlogin
  • Attendance Entity : Attributes of Attendance are attendance_id, attendance_employee_id, attendance_student_id, attendance_type, attendance_description

Description of Employee Management System Database :

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

Mobile Phone Billing System ER Diagram

Mobile Phone Billing System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Mobile Phone Billing System Entity. The entity-relationship diagram of Mobile Phone Billing System shows all the visual instrument of database tables and the relations between Customers, Tarrifs, Bills, Payments etc. It used structure...
Faculty Management System ER Diagram

Faculty Management System ER Diagram

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...
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...
Marrige Buero Management ER Diagram

Marrige Buero Management ER Diagram

This ER (Entity Relationship) Diagram represents the model of Marrige Buero Management Entity. The entity-relationship diagram of Marrige Buero Management shows all the visual instrument of database tables and the relations between Registration, Photograps, Partners, Multipile Types etc. It used...
Garment Shop Management System ER Diagram

Garment Shop Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Garment Shop Management System Entity. The entity-relationship diagram of Garment Shop Management System shows all the visual instrument of database tables and the relations between Inventory, Payment, Brands, Sales etc. It used...
Customer Track System ER Diagram

Customer Track System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Customer Track System Entity. The entity-relationship diagram of Customer Track System shows all the visual instrument of database tables and the relations between Documents, Login, Customer, Payments etc. It used structure data and to...
Student Feeback System ER Diagram

Student Feeback System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Student Feeback System Entity. The entity-relationship diagram of Student Feeback System shows all the visual instrument of database tables and the relations between Feedback, Faculty, Student, Subject etc. It used structure data and to...
Library Information System ER Diagram

Library Information System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Library Information System Entity. The entity-relationship diagram of Library Information System shows all the visual instrument of database tables and the relations between Book Maintenance, Membership Management, Student, Member etc....
Payroll Management System ER Diagram

Payroll Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Payroll Management System Entity. The entity-relationship diagram of Payroll Management System shows all the visual instrument of database tables and the relations between Salary, Appraisals, Payroll, Payments etc. It used structure data...
Alumni Information System ER Diagram

Alumni Information System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Alumni Information System Entity. The entity-relationship diagram of Alumni Information System shows all the visual instrument of database tables and the relations between College, Social Network, Alumni, College News etc. It used...