EMPLOYEE PAY PROCESSING SYSTEM Project description : The purpose of this program is to provide a pay processing system that will maintain employee data, attendance data etc., and calculate the salaries of all employees of an organization. The user can opt for Employee Processing or attendance processing or reporting or help as shown here.
User Instructions The user will run the program called Payroll by double clicking the icon for the executable on the desktop. The user then select any of the menu options available on the menu. DESIGN DOCUMENTATION Requirements Output 1)Employee’s Department wise list 2) Salary Statement for a month
Input Employee data Attendance data
Data Validations Implemented through constraints on Oracle tables created through following SQL commands: CREATE TABLE EMPLOYEE123 ( EMPNO NUMBER(4) PRIMARY KEY, ENAME VARCHAR2(20) NOT NULL, GENDER CHAR(1), ADDRESS VARCHAR2(30) NOT NULL, CITY VARCHAR2(30) NOT NULL, DOB DATE, DOJ DATE, DESIGNATION VARCHAR2(20) DEFAULT ‘SALES EXECUTIVE’, DEPARTMENT VARCHAR2(15) NOT NULL, BASIC NUMBER(7,2) CHECK (BASIC BETWEEN 5000 AND 30000), PF NUMBER(6,2), GIS NUMBER(6,2), CCA NUMBER(6,2), HRA NUMBER(6,2), DA NUMBER(6,2), GROSS NUMBER(7,2), IT NUMBER(7,2), NET NUMBER(7,2)); CREATE TABLE ATTENDANCE 123 ( EMPNO NUMBER(4) REFERENCES EMPLOYEE(EMPNO), FOR_MONTH NUMBER(2) NOT NULL, YEAR NUMBER(4) NOT NULL, CLS NUMBER(2), PLS NUMBER(2), MLS NUMBER(2), LWP NUMBER(2) );