RDBMS
RDBMS
RDBMS
SUBMITTED BY
ALISHA AHUJA
1420097
INTRODUCTION
The employee record system is very simple and for very beginner mini project. It is based on the
menu-driven program for elementary database management. It employ all the basic technique of
file handling in C. It consists of following features
1.1 Availability
It performs as a readily available source of information between the organization and the
employee. Contact information, salary information, posts, work schedule, education information
etc. is what most database systems consist of.
1.2 Efficiency
Employee database management systems are highly efficient. A member of the organization can
easily retrieve information about his/her colleague whenever required, and that too on short
notice. One can avoid making calls to the employee out on vacation just to retrieve an address to
send an important letter.
1.3 Accuracy
Since the information is mostly fed in by the employees themselves you can be sure the
information is accurate since its straight from the source. Moreover, an employee can access
their information at any time. Therefore, he/she can keep it updated and correct mistakes, if any.
1.5 Confidentiality
Specific information about the employee can not only be set to be kept private from public
viewing but can also be set to be kept private from anyone.It can insure availability, efficiency,
accuracy, updates on time-bound information, confidentiality etc. You can worry less about
managing a bulky dilapidated file or calling up your employees at inconvenient times or even be
stranded without crucial information with the employee database management system.
It is developed under Windows 95 that is why it is not compatible with new operating
system.
The human resource administrator falls short of controlling the employees activities in
analyzing his/her strengths and weakness.
2.1.1 Disadvantages
As current system is stand alone, normal employees cannot track their employee status.
The proposed system is intranet based system. So employee can also participate in this
system and can track their status.
The proposed system provides detailed general information about the employee along the
educational, skill and project details.
It enhances the human resource management in adding, viewing and updating employees
details and generates various reports regarding employees skill and experience.
The proposed system of human resource module is the right software to be incorporated
into the automation of human resource software for helping the organization needs with
respect to skillful human resource.
2.2.1 Advantages
Proposed system provides domain login facility so no need to remember user id and
password.
Objectives:
Methodlogy
Employee: When a new employee joins the company, his record is saved in the
database.
Workdays: the Admin has the authority to add the no of workdays of a company
per month.
Salary Calculation: Here salary is calculated for each employee based on their
attendance. As soon as the salary is paid to an employee, a salary slip will be
generated.
Salary Report: Here the user can look through the salary given to an employee
for a particular month and year.
Registration: As soon as the employee joins the company, the admin provides
unique username and password to him.
Display: A user can view information regarding employees working in that
company, products, dealers and a demand sheet to be submitted to the
manufacturers.
Logout: This module allows the user to Logout the application. Further
operations cannot be performed after user exit
Hardware Requirements
MEMORY SPACE:
Minimum
Recommended-
32 MB
64 MB
HDD
PROCESSOR
RAM
256MB or above
VIDEO
KEYBOARD
Software Requirements
OPERATING SYSTEM
- WindowsXP Professional
DEVELOPING LANGUAGE
- JAVA(jdk-7.9)
DATABASE
BACHELOR OT TECHNOLOGY
MAJOR PROJECT SYNOPSIS
SUBMITTED BY
SHIVAM GOURI
1420142
INTRODUCTION
The employee record system is very simple and for very beginner mini project. It is based on the
menu-driven program for elementary database management. It employ all the basic technique of
file handling in C. It consists of following features
1.1 Availability
It performs as a readily available source of information between the organization and the
employee. Contact information, salary information, posts, work schedule, education information
etc. is what most database systems consist of.
1.2 Efficiency
Employee database management systems are highly efficient. A member of the organization can
easily retrieve information about his/her colleague whenever required, and that too on short
notice. One can avoid making calls to the employee out on vacation just to retrieve an address to
send an important letter.
1.3 Accuracy
Since the information is mostly fed in by the employees themselves you can be sure the
information is accurate since its straight from the source. Moreover, an employee can access
their information at any time. Therefore, he/she can keep it updated and correct mistakes, if any.
1.5 Confidentiality
Specific information about the employee can not only be set to be kept private from public
viewing but can also be set to be kept private from anyone.It can insure availability, efficiency,
accuracy, updates on time-bound information, confidentiality etc. You can worry less about
managing a bulky dilapidated file or calling up your employees at inconvenient times or even be
stranded without crucial information with the employee database management system.
It is developed under Windows 95 that is why it is not compatible with new operating
system.
The human resource administrator falls short of controlling the employees activities in
analyzing his/her strengths and weakness.
2.1.1 Disadvantages
As current system is stand alone, normal employees cannot track their employee status.
The proposed system is intranet based system. So employee can also participate in this
system and can track their status.
The proposed system provides detailed general information about the employee along the
educational, skill and project details.
It enhances the human resource management in adding, viewing and updating employees
details and generates various reports regarding employees skill and experience.
The proposed system of human resource module is the right software to be incorporated
into the automation of human resource software for helping the organization needs with
respect to skillful human resource.
2.2.1 Advantages
Proposed system provides domain login facility so no need to remember user id and
password.
Objectives:
Methodlogy
Employee: When a new employee joins the company, his record is saved in the
database.
Workdays: the Admin has the authority to add the no of workdays of a company
per month.
Salary Calculation: Here salary is calculated for each employee based on their
attendance. As soon as the salary is paid to an employee, a salary slip will be
generated.
Salary Report: Here the user can look through the salary given to an employee
for a particular month and year.
Registration: As soon as the employee joins the company, the admin provides
unique username and password to him.
Display: A user can view information regarding employees working in that
company, products, dealers and a demand sheet to be submitted to the
manufacturers.
Logout: This module allows the user to Logout the application. Further
operations cannot be performed after user exit
Hardware Requirements
MEMORY SPACE:
Minimum
Recommended-
32 MB
64 MB
HDD
PROCESSOR
RAM
256MB or above
VIDEO
KEYBOARD
Software Requirements
OPERATING SYSTEM
- WindowsXP Professional
DEVELOPING LANGUAGE
- JAVA(jdk-7.9)
DATABASE