Human Resource Management System ER Diagram

Subscribe our YouTube channel for latest project videos and tutorials Click Here

Posted By freeproject on July 17, 2017

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

Human Resource 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
  • Trainings Entity : Attributes of Trainings are training_id, training_employee_id, training_registration, training_name, training_type, training_year, training_description
  • Appraisals Entity : Attributes of Appraisals are apprasail_id, apprasail_employee_id, apprasail_name, apprasail_type, apprasail_description
  • Departments Entity : Attributes of Departments are department_id, department_name, department_place, department_type, department_description
  • Salary Entity : Attributes of Salary are salary_id, salary_employee_id, salary_amount, salary_total, salary_type, salary_description
  • Salary Slip Entity : Attributes of Salary Slip are salary_slip_id, salary_slip_employee_id, salary_slip_name, salary_slip_date, salary_slip_number, salary_slip_type, salary_slip_description

Description of Human Resource Management System Database :

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

Dental Hospital Management ER Diagram

Dental Hospital Management ER Diagram

This ER (Entity Relationship) Diagram represents the model of Dental Hospital Management Entity. The entity-relationship diagram of Dental Hospital Management shows all the visual instrument of database tables and the relations between Patient, Nurses, Dental Problems, Medicines etc. It used...
Mobile Shop Management System ER Diagram

Mobile Shop Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Mobile Shop Management System Entity. The entity-relationship diagram of Mobile Shop Management System shows all the visual instrument of database tables and the relations between Customers, Sells, Mobile, Stock etc. It used structure...
Hotel Room Management System ER Diagram

Hotel Room Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Hotel Room Management System Entity. The entity-relationship diagram of Hotel Room Management System shows all the visual instrument of database tables and the relations between Room, Payment, Hotel, Hotel Employee etc. It used structure...
Internet Cafe ER Diagram

Internet Cafe ER Diagram

This ER (Entity Relationship) Diagram represents the model of Internet Cafe Entity. The entity-relationship diagram of Internet Cafe shows all the visual instrument of database tables and the relations between Internet, Bills, Users, Login etc. It used structure data and to define the relationships...
Inventory System ER Diagram

Inventory System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Inventory System Entity. The entity-relationship diagram of Inventory System shows all the visual instrument of database tables and the relations between Category, Warning, Goods, Manager etc. It used structure data and to define the...
Telephone Billing Payment System ER Diagram

Telephone Billing Payment System ER Diagram

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

Computerized Examination System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Computerized Examination System Entity. The entity-relationship diagram of Computerized Examination System shows all the visual instrument of database tables and the relations between Papers, Results, Exams, Questions 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...
Event Tracker ER Diagram

Event Tracker ER Diagram

This ER (Entity Relationship) Diagram represents the model of Event Tracker Entity. The entity-relationship diagram of Event Tracker shows all the visual instrument of database tables and the relations between Tracking, Party, Event, Video etc. It used structure data and to define the relationships...
Poll Survey System ER Diagram

Poll Survey System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Poll Survey System Entity. The entity-relationship diagram of Poll Survey System shows all the visual instrument of database tables and the relations between Users, Survey, Polls, Registration etc. It used structure data and to define...
Call FreeProjectz WhatsApp FreeProjectz