HRD Management System ER Diagram

Posted By freeproject on July 17, 2017

This ER (Entity Relationship) Diagram represents the model of HRD Management System Entity. The entity-relationship diagram of HRD 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 HRD Management System functionalities. The main entities of the HRD Management System are Employee, Trainings, Appraisals, Departments, Salary and Salary slip.

HRD 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 HRD 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 HRD Management System tables for fast query execution.
HRD 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)

Banking Management System ER Diagram

Banking Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Banking Management System Entity. The entity-relationship diagram of Banking Management System shows all the visual instrument of database tables and the relations between Employees, Fixed Deposit, Customer, Current Account etc. It used...
University Bulletin Board ER Diagram

University Bulletin Board ER Diagram

This ER (Entity Relationship) Diagram represents the model of University Bulletin Board Entity. The entity-relationship diagram of University Bulletin Board shows all the visual instrument of database tables and the relations between University News, News Category, University, Result News etc. It...
Leave Approval System ER Diagram

Leave Approval System ER Diagram

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

Movie Library Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Movie Library Management System Entity. The entity-relationship diagram of Movie Library Management System shows all the visual instrument of database tables and the relations between Movie Type, Shows, Movie Library, Login etc. It used...
Gym Management System ER Diagram

Gym Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Gym Management System Entity. The entity-relationship diagram of Gym Management System shows all the visual instrument of database tables and the relations between Package, Payment, Gym, Member etc. It used structure data and to define...
Error Tracking System ER Diagram

Error Tracking System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Error Tracking System Entity. The entity-relationship diagram of Error Tracking System shows all the visual instrument of database tables and the relations between Tracking, Developer, Error, Project etc. It used structure data and to...
Pharmacy Management System ER Diagram

Pharmacy Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Pharmacy Management System Entity. The entity-relationship diagram of Pharmacy Management System shows all the visual instrument of database tables and the relations between Medicines, Company, Pharmacy, Sells etc. It used structure data...
Railway Enquiry System ER Diagram

Railway Enquiry System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Railway Enquiry System Entity. The entity-relationship diagram of Railway Enquiry System shows all the visual instrument of database tables and the relations between Timetable, Stations, Trains, Routes etc. It used structure data and to...
Fast Food Corner Portal ER Diagram

Fast Food Corner Portal ER Diagram

This ER (Entity Relationship) Diagram represents the model of Fast Food Corner Portal Entity. The entity-relationship diagram of Fast Food Corner Portal shows all the visual instrument of database tables and the relations between Items, Receipts, Foods, Bill etc. It used structure data and to...
Product Supply Management System ER Diagram

Product Supply Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Product Supply Management System Entity. The entity-relationship diagram of Product Supply Management System shows all the visual instrument of database tables and the relations between Supply, Stocks, Product, Accounts etc. It used...