Loyalty business tracker application system project is developed in java programming language. Main objective of this project is to design a database application which will have different permissions for users to access it from different levels in side organization. 

Loyalty Business Tracker Application System

This application is web based application where users can access details through online but cannot modify database details.

Modules Overview:

There are four modules in this application employee, employer, administrator and visitor.

Admin : Admin is the primary user who will have access to every element of the application he can add, delete, modify details of every module. Other two modules comes under admin module. 

Employer: This module will manage details of every employee who is working in organization . Each employee comes under employer module and admin can access details of employer module.

Employee:  This module is for single user who can access database and view his details like salary, leaves, attendance details..etc.

Youtube video link to view design details.

http://www.youtube.com/watch?v=u_GCUS6C1Do&feature=youtu.be

How to Run Loyalty Business Tracker Application System:

softwares required:
jdk 1.5.0
Tomcat 5.0.27 or latest
Oracle 8i
create user in oracle
user name:pmis
Password:pmis
syntax:
create user <username> identified by <password>
grant dba to <username>
conn <username>/<password>
Copy all the tables

create dsn name -pmis

copy the application folder in tomcat webapps folder .
run tomcat server.
open the browser and type the localhost address i.e., http://localhost:<port number>/<application name>

 Database Design Details:

create table employee(empid number(5) primary key,
password varchar2(8),
cpassword varchar2(8),
fname varchar2(12),
lname varchar2(12),
mname varchar2(12),
dob varchar2(14),
hiredate varchar2(14),
sex varchar2(6),
Designation varchar2(12)
);

create table loanissue(ewfid varchar2(5),
empid number(5),
desigcode varchar2(12),
typeloan varchar2(12),
amount varchar2(12),
status varchar2(12)
);

create table mpfissue(empid number(5),
mpfid varchar2(12));

create table ewfissue(empid number(5),
ewfid varchar2(12));

create table leave_trans(empid number(12),fromdate varchar2(23),
todate varchar2(23),
Reason varchar2(23));

create table(MAILFROM VARCHAR2(50), MAILSUB VARCHAR2(50), MAILDESC VARCHAR2(2000));

create table design(projectno number(5),title varchar2(23),module varchar2(23),dt varchar2(23),moduleused varchar2(23),summary varchar2(89));

create table coding(projectno number(5),title varchar2(23),module varchar2(23),dt varchar2(23),frontend varchar2(23),backend varchar2(23),server varchar2(23), database varchar2(23),summary varchar2(23));

create table testing(projectno number(5),title varchar2(23),module varchar2(23),dt varchar2(23),testing varchar2(23),bugs varchar2(23),loc varchar2(23), summary varchar2(23));

create table analysis (
PROJECTNO NUMBER(5),
TITLE VARCHAR2(23),
MODULE VARCHAR2(23),
DT VARCHAR2(23),
ANALYSIS VARCHAR2(23),
SUMMARY VARCHAR2(83));

Download Loyalty Business Tracker Application System Project