TIMES JOB CONTENTS

1. ABSTRACT

2. INTRODUCTION

3. DESIGN PRINCIPLES & EXPLANATION

3.1. MODULES

3.2. MODULE DESCRIPTIOIN

4. PROJECT DICTIONARY

4.1. DATAFLOW DIAGRAMS

4.21. DATA DICTIONARY

5. BIBILIOGRAPHY

1. ABSTRACT

The TIMES JOB CONSULTANCY System is

Intermediate between Jobseekers and Employers.The

purpose is to enable the Jobseekers to search for the

jobs from any remote location. The Jobseeker can

Search for the jobs from any remote location. The

Jobseeker can Search for the jobs which with the

Consultancy without actually visiting the

Consultancy.

Obtaining a Reg. No and Password, the

Reg. No being unique does registraion for the

Jobseekers as well as Employers, who intends to

access the Consultancy online through web. After the

Employer gets his registration confirmed, he/she can

post jobs according to his requirements.

This Site Provides Good Study Material

to Jobseekers. Thus providing good subject to

Jobseekers, who are preparing for interviews?

2. INTRODUCTION

The main objective of TIMES Job Consultancy is

to make easy for job seekers for searching jobs and

recruiting for companies. It acts as a mediator

between the jobseekers and companies. Companies

ask required number of candidates and consultancy

for wad the list of candidates to the company. It also

sends a list of companies to jobseekers to which are

recruiting.

For a new user or general user there are

various modules helping him for entering into

consultancy. For a new user he has to enter their

details according to the registration form. He has to

select is own registration number through which he

has to login.

There are several modules that work once when the

user is logged in with his registration number and

password. The user can choose any of the

components displayed and can avail the services

according to his need.

Username and password is

given for each user so that the messaging servlet

recognizes them as user. Multiple logins with same

identity is not allowed.

PROPOSED SYSTEM:

The major prospect of this project is to make J2EE

enabled applications which is administrative based to

provide the complete information of the Job

consultancy’s that the job seeker can be made easy

in searching jobs and recruiting for companies.

BENEFITS OF PROPOSED SYSTEM:

Java enabled consultancy has changed the world in

the age of information technology therefore in the

arena of post globalization.

Every citizen of the world should have access to

the authorities. Using this application, individual

users can then place their own requirements and

hence can retrieve the information needed sitting at

their place. Multiple logins with same identity is not

allowed.

3. DESIGN PRINCIPLES & EXPLANATION

3.1. MODULESThis project is developed for job aspirants who are

in search of suitable job. This project will be helpful

for fresher as well as experienced professionals. It

keeps track of

strong reputation for a systematic and hands-on

approach to Human Resources Consulting. It also

undertakes to manage the needs for organizations

particularly small/medium and start-up companies on

an outstanding basis.

Job consultancy acts like a mediator between job seekers and company.

This project contains seven modules.

1. Job seekers Registration Form

2. Employee Registration Form

3. Company placing job requirements on the site

4. Consultancy checking with their database

5. Consultancy after conducting first round of

interview, short listed candidate details will be

send to company.

6. Company after conducting rounds of interviews,

selected candidates list will be send to

consultancy.

7. Job seekers deletion process.

3.2. MODULE DESCRIPTIOIN

1.Job seekers Registration Form

In this module we describe the job seekers details.

Consultancy will place registration form on the site.

In this job seekers interact with the consultancy. Job

seekers will take registration form from the site and

fill those forms and send to the consultancy.

Consultancy will store these registration forms in

their database.

2.Employee Registration Form: In this module we describe the company details.

Employees are interact with the consultancy.

Consultancy will provide registration form to the

company. Company will fill those form with their

details and send to the consultancy and these

details will be stored in consultancy database.

3.Company placing job requirements on the site:

In this module company will interact with

consultancy. Consultancy will place the form on the

site. This form is taken by the company. Company

will fill those form according to their requirements

and this form will be sent back to the consultancy.

Consultancy will store it in their database.

4.Consultancy checking with their database:

In this module consultancy will check both the

job seekers form and company

Requirement form. If they match the job seekers

names will be short listed. This short listed

candidates details will be stored in consultancy

database. Consultancy will inform to the short listed

candidates.

5.Consultancy after conducting first round of interview, short listed candidates details will be send to the company: In this module consultancy will conduct the

interview to the job seekers. Based on

their interview performance consultancy will short list

the job seekers and those short listed job seekers

names will be send to the company and also stored

in the consultancy database.

6.Company after conducting rounds of interviews, selected candidates details will send to the consultancy:

In this module company will conduct the interview to

the short listed job seekers. If they select in the

interview that selected job seekers details will be

send to the

Consultancy and consultancy will store this

information in their database.

7. Job seekers deletion process: In this module consultancy delete the job seekers

details who are not interact with consultancy in

particular period.

4. PROJECT DICTIONARY

4.1. DATA DICTIONARY

TIMES JOB CONSULTANCY

JobConsultanc

yServices

Request for registration form

Send registration form

Get registration form

Get call letter

Companies

Req for emp reg form

Receiving emp reg form

Submit the emp reg form

Req for comp req form

Receiving comp req form

Submit the req form

Sending shortlist details

Getting selected candidate details

Jobconsultancy

Taking both the formsSubmit the shortlist

details

Placing jobseekers &emp reg form

Job seeker

Job seeker

1

ValidationValidationprocessprocess

2

Validating constraints

3

Checking statusUser table db

Uname/pswd

Login

Forward resume

Db user table

Db constraint

Job Seeker Data Flow Diagram

consultancy 1

Validation process

2

CheckingResumes

Login,usr,pwd

filteration

Db companies

Db consultancy

3

Shortlisting

4 Selected candidates details wiillbe sent to company

Db Company

Consultancy Data Flow Diagram

Company

1

Validationprocess

Login,uname,pwd

2

Company placingRequirements

Db consultancy

Db companytable

3Shortlisting selected candidates details

Db Company

4Sending selected candidates details to consultancy

Db Consultancy

Company Data Flow Diagram

4.2 DATA DICTIONARY

TABLE NAME: LOGIN Name Type----------------------------------------- -------- ----------------------------REGNO VARCHAR2(20)PWD VARCHAR2(10)DOR DATEDLA DATESTATUS VARCHAR2(10)

When ever a new user registers with the Consultancy Register Number

and password are stored in login table

TABLE: GENERAL Name Type----------------------------------------- -------- ----------------------------REGNO VARCHAR2(20)NAME VARCHAR2(10)FNAME VARCHAR2(10)DOB DATEAGE NUMBER(10)HNO NUMBER(20)STREET VARCHAR2(20)CITY VARCHAR2(20)STATE VARCHAR2(20)COUNTRY VARCHAR2(20)PIN NUMBER(10)GENDER VARCHAR2(10)QUAL VARCHAR2(20)BRANCH VARCHAR2(10)YOP NUMBER(20)PERCENTAGE NUMBER(20)EXP VARCHAR2(20)EXPY NUMBER(10)PHONE NUMBER(20)EMAIL VARCHAR2(20)The personal details of the candidates are stored genral table.

TABLE NAME: EDUCATIONAL

SSC DataBase

Name Type ----------------------------------------- -------- --------------------------- REGNO VARCHAR2(20)SNAME VARCHAR2(20)PER NUMBER(20)YOP NUMBER(10)

The ssc details of the candidate will be stored in Educational table

Board Of Intermediate DataBase

Name Type ----------------------------------------- -------- --------------------------- REGNO VARCHAR2(20) INAME VARCHAR2(20) BRANCH VARCHAR2(20) IPER NUMBER(10) IYOP NUMBER(20)

The Intermediate details of the candidate will be stored in Educational

table

Under Graduation DataBase

Name Type ----------------------------------------- -------- --------------------------- REGNO VARCHAR2(20) UNAME VARCHAR2(20) COURSE VARCHAR2(20) UBRANCH VARCHAR2(20) UPER NUMBER(20) UYOP NUMBER(20)

The Under Graduation details of the candidate will be stored in

Educational table

Post Graduate DataBase

Name Type ----------------------------------------- -------- ---------------------------- REGNO VARCHAR2(20) PNAME VARCHAR2(20) PCOURSE VARCHAR2(20) PBRANCH VARCHAR2(20) PPER NUMBER(20) PYOP NUMBER(20) The Post Graduation details of the candidate will be stored in

Educational table

TABLE NAME: EXPERIANCE Name Type ----------------------------------------- -------- ---------------------------- CNAME VARCHAR2(20) DESG VARCHAR2(20) JDATE DATE EDATE DATE TOTE NUMBER(20) KSKILL VARCHAR2(20) REGNO NUMBER(20)The Experiance details of the candidate will be stored in Experiance

table

TABLE NAME: COMPANY INFORMATION

Name Type ----------------------------------------- -------- --------------------------- REGNO VARCHAR2(7)

CNAME VARCHAR2(20) PADD VARCHAR2(20) STRADD VARCHAR2(20) LOCATION VARCHAR2(20) CITY VARCHAR2(20) COUNTRY VARCHAR2(20) PINNO NUMBER(20) PHONE NUMBER(20) EMAIL VARCHAR2(20) GRADE VARCHAR2(10) STATE VARCHAR2(20) CCODE NUMBER(10)

The Company information details of the candidate will be stored in

Company Information table

TABLE NAME: COMPANY LOGIN

Name Type ----------------------------------------- -------- ---------------------------- REGNO VARCHAR2(7) PWD VARCHAR2(10)

When ever a new Company registers with the Consultancy Register

Number and password are stored in Company login table

TABLE NAME: ADD EMPLOYEE

Name Type ----------------------------------------- -------- ---------------------------- REGNO VARCHAR2(10) ENAME VARCHAR2(20) DESG VARCHAR2(20) DEPT VARCHAR2(20)

PHONE NUMBER(20) EMAIL VARCHAR2(20) ECODE VARCHAR2(10) PWD VARCHAR2(10)

The Employee details of the Company will be stored in this table

TABLE NAME: COMPANY REQUIREMENTS

Name Type ----------------------------------------- -------- --------------------------- COMPNAME VARCHAR2(20) JCODE VARCHAR2(20) QUAL VARCHAR2(20) CEXP VARCHAR2(20) CEXPY NUMBER(20) SALARY NUMBER(20) IDATE VARCHAR2(20) SKILL VARCHAR2(20) ECODE VARCHAR2(10) Company Requirements will be stored in Company Requirements table

TABLE NAME: COMPANY

Name Type ----------------------------------------- -------- ---------------------------- CNAME VARCHAR2(20) LOC VARCHAR2(20) CITY VARCHAR2(20) STATE VARCHAR2(20) COUNTRY VARCHAR2(20) PHONE NUMBER(10) EMAIL VARCHAR2(20)

CGRADE VARCHAR2(20)

Company Details will be stored in this table

TABLE NAME: EMPLOYEE

Name Type ----------------------------------------- -------- ---------------------------- ENO NUMBER(10) ENAME VARCHAR2(20) DES VARCHAR2(20) DEP VARCHAR2(20) PHONE NUMBER(10) EMAIL VARCHAR2(20)

Employee Details will be stored in this table

TABLE NAME: FILTER

Name Type ----------------------------------------- -------- --------------------------- REGNO VARCHAR2(20) NAME VARCHAR2(20) QUA VARCHAR2(20) EXP VARCHAR2(20) SKILL VARCHAR2(20)

Filtered Candidates Details will be stored in Filter table

TABLE NAME: COMPANY FILTER

Name Type

----------------------------------------- -------- --------------------------- CCODE VARCHAR2(20) CNAME VARCHAR2(20) SADD VARCHAR2(20) LOC VARCHAR2(20) CITY VARCHAR2(20) STATE VARCHAR2(20) COUNTRY VARCHAR2(20) PINNO NUMBER(20) EMAIL VARCHAR2(20) CGRADE VARCHAR2(20)

List of filtered Candidates details by Company will be stored in this

table

TABLE NAME: CONSULTANCY LOGIN

Name Type ----------------------------------------- -------- --------------------------- REGNO VARCHAR2(20)PASSWORD VARCHAR2(20)

Consultancy Register Number and password are stored in login table

TABLE NAME: SELECTED CANDIDATES

Name Type ----------------------------------------- -------- ---------------------------- REGNO VARCHAR2(20) COMNAME VARCHAR2(20) JOBTITLE VARCHAR2(20) DESG VARCHAR2(20) SALARY NUMBER(20) REQ DATE

Selected Candidates Details will be stored in this table