Employee Data Management System DBMS Project ER Diagram

 Employee Management System DBMS Project ER Diagram

The Employee Management System Entities are represented by this ER (Entity Relationship) Diagram. Employee Management System's entity-relationship diagram depicts all of the visual instruments of DBMS as well as the relationships between Salary, Experience, Employee, Attendance, and so on. It was used to describe the linkages across structural groups of data of Employee Management System features using data structures. Employee, Salary, Leaves, Experience, Login, and Attendance are the core entities of the Employee Management System.

Employee Management System Entities Details:

The following entities are defined by the ER model:

Employee Attributes: -  EmpId , FullName ,  FirstName , MiddleName , LastName , empEmail , empContactNo , empGender , isActive , DateOfBirth , ResidentalAddress , PermenantAddress , CityId , CountryId , CreatedDate , UpdatedDate .

 

Role Attributes: -  RoleId , RoleName , Description , CreatedDate.

 

Login Attributes: -  LoginId , EmpId , RoleId , Username , PasswordId, CreatedDate.

 

PasswordLog Attributes: -  PasswordId,  EmpId , isResetPassword , PassLog1 , PassLog2 , UpdatedDate.

 

EmployeeRole Attributes: -  EmployeeRoleId , RoleId , EmpId ,Role, Description , CreatedDate .

 

Department Attributes: -  DeptId , DeptName , Description.

 

EmpDepartment Attributes: -  EmpDeptId , EmpId , DeptId , comments , CreatedDate.

 

Qualification Attributes: -  QualificationId , EmpId , DegreeName ,Position , description , CreatedDate .

 

Salary Attributes: -  SalaryId , EmpId , RoleId , BasicSalary , MedicalAllowance , TravelAllowance , RentAllowance , TotalAmount , CreatedDate.

 

Leave Attributes: -  LeaveId , EmpId , RoleID , LeaveMonth , fromDate , toDate , Reason.

 

WeekDays Attributes: -  WeekId , DayName.

 

Attendence Attributes: -  AttendenceId , EmpId , WeekId , Attendence , duration , CreatedDate .

 

Holiday Attributes: -  HolidayeId , fromDate , toDate , HolidayName , Description .

 

PayRoll Attributes: -  PayRollId , EmpId , RoleID , SalaryID , Leave , Attendence , Holiday , Report , CreatedDate.

Also Visit: Employee Management System DBMS Project Create Database, Create Tables Using SQL Server