Full text

(1)

BY

Master of Computer Application

Roll No: 001010503024

Registration No: 113606 Of 2010-2011

Examination Roll No: MCA-3213020

UNDER THE GUIDANCE OF

Dr. ANUPAM SINHA

Professor, Department of Computer Science and Engineering,

Jadavpur University

(2)

DEPARTMENT OF COMPUTER SCIENCE AND

ENGINEERING

FACULTY OF ENGINEERING AND

TECHNOLOGY

JADAVPUR UNIVERSITY

TO WHOM IT MAY CONCERN

This is to certify that the work embodied in this thesis entitled “ONLINE JOB PORTAL”

has been satisfactorily completed by Pavel Ray (Reg. No. 113606 of 2010-2011, Roll No.

MCA

-

3213020). It is a bona-fide piece of work carried out under my supervision and

guidance and may be accepted in partial fulfillment of the requirements for the awarding of

the Master of Computer Application degree of the Department of Computer Science and

Engineering, Faculty of Engineering & Technology, Jadavpur University, during the academic

year 2012-2013. The project results presented in the thesis have not been included in any

other paper submitted for any degree to any other University or Institute.

I wish him every success in life.

……….

Project Guide

Prof. Anupam Sinha

Department of Computer Science & Engineering

Jadavpur University, Kolkata – 700032

……….

Prof.

Sivaji Bandyopadhyay

Head of the Department,

Computer Science & Engineering,

Jadavpur University, Kolkata -700032

(3)

JADAVPUR UNIVERSITY

FACULTY OF ENGINEERING AND

TECHNOLOGY

DECLARATION OF ORIGINALITY

AND

COMPLIANCE OF ACADEMIC ETHICS

I hereby declare that this thesis contains literature survey and original research work

by the undersigned candidate, as part of requirements of the degree of MASTER OF

COMPUTER APPLICATION of Jadavpur University.

All information in this document have been obtained and presented in accordance

with academic rules and ethical conduct.

I also declare that, as required by these rules and conduct, I have fully cited and

referenced all material results that are not original to this work.

Name :

Pavel Ray

Registration No :

113606 of 2010-2011

Roll No :

MCA-3213020

(4)

JADAVPUR UNIVERSITY

FACULTY OF ENGINEERING AND

TECHNOLOGY

CERTIFICATE OF APPROVAL

This is to certify that the thesis entitled “Online Job Portal” is a bona-fide record of

work carried out by Pavel Ray for the award of the degree of Master of Computer

Application in the Department of Computer Science & Engineering, Jadavpur University,

during the period December 2012 to May 2013. It is understood that by this approval the

undersigned do not necessarily endorse or approve any statement made, opinion expressed

or conclusion drawn therein, but approve the thesis only for the purpose for which it is

submitted.

1.

………..

2.

………..

(5)

ACKNOWLEDGEMENT

I express my thanks and full-hearted gratitude to my respected teacher, supervisor

and guide of my project Prof. Anupam Sinha, Department of Computer Science and

Engineering, Jadavpur University, for his full guidance and entire support in completing this

project successfully. I am very much thankful to him for the constant encouragement and

continuous inspiration that he has given to me.

Finally I convey my real sense of gratitude and thankfulness to all my friends and

family members for their unconditional support and encouragement during my project work

without which I would hardly be capable of producing this huge work.

……….

Pavel Ray

Exam Roll : MCA – 3213020

Registration No. : 113606 of 2010-2011

Master of Computer Application

(6)

Table of Contents

1. INTRODUCTION………...7 2. PURPOSE……….…...…7 3. SCOPE………...7 4. INTENDED AUDIENCE……….7 5. OBJECTIVE……….….8 6. DETAILS REQIREMENT………..……8 7. FUNCTIONAL REQUIREMENTS………9 8. PREREQUISITES………...9 9. TECHNOLOGIES STACK………..10 10. METHODOLOGY ……….………11 11. WATERFALL MODEL……….12 12. METHOLODGY CONTD……….………..13 13. SYSTEM SPECIFICATION………15

14. COST ESTIMATION MODEL………..16

15. DATA MODEL………..…17

16. FUNCTIONAL REQUIREMENT………..20

18. ASSUMPTION FOR ONLINE JOBPORTAL………..21

19. DFD FOR ONLINE JOBPORTAL……….22

20. ER-DIAGRAM………..29

21. HOW TO RUN THE PROJECT ………31

22. SCREEN SHOTS………..………33

23. FUTURE SCOPE..………41

(7)

I

NTRODUCTION

Viewing available jobs, or applying for the job at the agency can be done for which job seekers has to go to the agency and check the available jobs at the agency. Job seekers check the list of jobs available and apply the job. Then the agency will show available jobs for the job seeker for his qualifications and then updates the jobs database.

Purpose

The purpose of designing the online job portal is to give the job seekers a platform for finding a right and a satisfactory job according to their qualification. It also connects the job seekers with the major agencies.

Scope

The scope of the online job portal includes:

The Online job Portal System that is to be developed provides the members with jobs information, online applying for jobs and many other facilities. The basic scope of the project is given as under. Job Seekers Area

Recruiters Area Administrator’s Panel

Intended Audience

This document depicts the low level design document of the Online Job portal project. This document includes the identified classes and relationship between the classes, functional architecture and sequence diagram of the major functional requirements.

(8)

Objective

This document is created for documenting all major classes which are used in project. The relationship between the classes and how the classes are interacting (Process flow / DFD diagram) are documented in low level design document.

The low level design document is generally created before start the actual development of the project. So the low level design document helps the developer to get enough information about the development process of the projects.

Details Requirement

This Project Provide a common platform for job seekers and Recruiters. The Job Seekers can able to register for this site & get the opportunity for job according to his/her qualification. They also get the information about the well known Hotels, Restaurants and Shopping malls etc.

The Online Job portal Project will be having another major part that is administration part. The Admin user can able to login into the application for managing the information if any modified is required.

The Online Job Portal System is a package to be used by agencies to improve the efficiency of business. The Online Job Portal System to be developed benefits greatly the members. The system provides jobs catalogue and information to members and helps them decide on the jobs to apply. The Admin can keep the jobs catalogue updated all the time so that the members (Job seekers and the agencies) get the updated information all the time.

The main users are users: Admin, Members who are the Job seekers and the agencies. After long discussion with our mentor team, we have taken a decision to implement requirements in this project which are documented in “Functional Requirement” section.

(9)

Functional Requirements:

Function Requirements

Description

Priority

About the Online Job portal Provide a common platform for job seekers and Recruiters.

1

Recruiter post Jobs When Recruiter post the job in this site According matching profile user see the jobs

1

User Apply Jobs If user profile matches then he/she can apply jobs.

1 Admin manage jobs Admin Can see the details of a job posted and if

necessary can delete it.

2

Admin Manage Recruiter Admin can verify the Recruiter also & check the Company Details and if necessary can delete.

2 Admin manage Job Seekers Admin can verify the Jobseekers and check the

Details and if necessary can delete the jobseeker.

2

Manage Job post Recruiter can check the number of jobseekers that applied in the job posted by that Recruiter and can also delete the posted job.

1

Upload CV User can Upload his/her curriculum vitae. 1 Download Forgot Password User Can Download his/her own Password if

he/she forgot password.

1 Jobseekers Search Jobs(Anonymous

Users)

Jobseekers can search job according his/her key skill or job category basis.

1

Prerequisites

Following are the prerequisites of the “Online Job portal” project.

(10)

Technologies Stack

The Online Job portal web application will be implemented in Java/J2EE and it will be hosted/deployed in free application server (i.e. GlassFish 3.0).

As per discussion with Mentor (College), following technologies, tools and software’s will be used in Online Job portal web application –

1.

HTML

[Hyper Text Markup Language, It is used to create static web pages]. 2.

Jsp

[Java Server Pages, It is used to create dynamic web content] .

3.

Java Script

[JavaScript (JS) is an interpreted computer programming language. It was

originally implemented as part of web browsers so that client-side scripts could interact with the user].

4.

AJAX

[AJAX is an acronym for Asynchronous JavaScript And XML]. 5.

CSS

[Cascading style sheet].

6. MVC Architecture.

7. Core Java.

8. Jdk 1.6 or above.

9. GlassFish3.0.

10. Oracle 10g.

11. Jdbc-odbc Connector jar for Oracle (ojdbc14.jar).

12. NetBeans IDE 7.2.

(11)

Methodology

The waterfall model is a sequential design process, often used in software development

processes, in which progress is seen as flowing steadily downwards (like a cascade of

waterfall) through the phases of Conception, Initiation, Analysis, Design, Construction,

Testing, Production/Implementation, and Maintenance.

(12)

Waterfall Model:

The name of this model is justified by the diagrammatic representation which resembles a

cascade of waterfall. It consists with intuitive set of phases. It has 6 phases:

1. Requirements 2. Design

3. Implementation 4. Verification 5. Maintenance

The different phases starting from feasibility study to integration and testing phase & delivery is known as developmental pan. At the end of developmental part, product is to be delivered to customer and maintenance commences after that.

An activity that’s spans all phases of any software development is project management. Even though conveniently omitted in the life cycle diagram, project management nevertheless is an important activity in the life cycle and deals with the managing the effort at all stages of product development and maintenance.

Analysis:

a. The model enforces discipline in software development process overcoming

unstructured code and fixed processes.

b. Allow a nicely understood theoretical flow in cascading manner.

c. Documented approach, design documentation, code documentation, database

manual, operational manual etc.

d. Easier to maintain

e. Progress is measures by producing crude and executable systems presented to

stakeholders and improving them

(13)

Methodology contd.

1)

Feasibility Study:

Feasibility studies aim to objectively and rationally uncover the strengths and weaknesses of an existing business or proposed venture, opportunities and threats as presented by the environment, the resources required to carry through, and ultimately the prospects for success. In its simplest terms, the two criteria to judge feasibility are cost required and value to be attained.

2)

Requirement analysis and specification:

The goal of the requirement analysis and specification phase is to clearly understand the customer requirements and to systematically organize the requirements into a specification document.

The main activities carried out during requirements analysis and specification phase are of two types as follows:

Requirements gathering and analysis Requirements Specification

The main purpose of the requirements analysis activity is to analyze the collected

information to obtain a clear understanding of the product to be developed, with a view to removing all ambiguities, incompleteness, and inconsistencies from the initial customer perception of the problem.

The SRS document is the final outcome of the requirements analysis and specification phase. There are 3 main types of problems in the requirements that the analyst needs to identify and resolve:

Ambiguity Inconsistency

Incompleteness. Other steps are discussed accordingly.

1.1 Feasibility Study-:

The feasibility study of a project can be ascertained in terms of technical and economic factors or both. A feasibility study is documented with a report showing all the ramifications of the project.

Five common factors of Feasibility Study:

(14)

Technical Feasibility:

Technological feasibility is carried out to determine whether the company has the capability, in terms of software, hardware, personnel and expertise, to handle the completion of the project. Since we are using J2EE and SQL Server, technically our project is feasible.

Economic Feasibility:

Economic analysis is the most frequently used method for evaluating the effectiveness of a new system. More commonly known as cost/benefit analysis, the procedure is to determine the benefits and savings that are expected from a candidate system and compare them with costs. If benefits outweigh costs, then the decision is made to design and implement the system. An entrepreneur must accurately weigh the cost versus benefits before taking an action.

Legal feasibility:

Determines whether the proposed system conflicts with legal requirements e.g. a data processing system must comply with the local Data Protection Acts.

Operational feasibility:

Operational feasibility is a measure of how well a proposed system solves the problems, and takes advantage of the opportunities identified during scope definition and how it satisfies the

requirements identified in the requirements analysis phase of system development.

Schedule feasibility:

A project will fail if it takes too long to be completed before it is useful. Typically this means estimating how long the system will take to develop, and if it can be completed in a given time period using some methods like payback period. Schedule feasibility is a measure of how reasonable the project timetable is.

(15)

System Specification

Hardware:

IBM compatible , Intel Pentium 4,Intel core-i3 based PC with a monitor ,keyboard and mouse, system must have 1 GB Ram, Hard disk 80 GB or of available memory………

Operating System:

Windows XP or Windows 7 or Windows 8.

S/W needed:

Standard web browser, Oracle 10g, Glassfish 3.0 with NetBeans 6.1 IDE or Upgrade version , MVC Architecture.

Standarbrowser:

(16)

Cost Estimation Model

Cocomo model for Online Jobportal:

The online job portal has average complexity and fair flexibility. Thus it is classified as organic project.

a. effort=2.4*(size)^1.05 PM

b. Time to development=2.5 *(effort)^0.38Months where,

effort = number of staff months(PM)

size = no of lines of code to complete product time=total months

The Project code=4000 LOC=4 KLOC[WE KNOW 1 KLOC=1000 LOC] Project is 4.0 KLOC

a.effort=2.4*4.0^1.05=10.29 PM

b. time= 2.5*10.29^0.38=6 months(development time) cost per month=10000/-

(17)

Data Model

Table: CITY

Column N am e Dat a T ype Nullabl e Def ault Primar y K ey

CTYID NUMBER No - 1

CID NUMBER No - -

CTYNAME VARCHAR2(300) No - -

Table: AD MIN

Column N am e Dat a T ype Nullabl e Def ault Primar y K ey

ID VARCHAR2(300) No - 1

FNAME VARCHAR2(300) Yes - -

LNAME VARCHAR2(300) Yes - -

PASS VARCHAR2(300) Yes - -

REGISDATE DATE Yes - -

Table: C AT EG ORY

Column N am e Dat a T ype Nullabl e Def ault Primar y K ey

ID NUMBER No - 1

NAME VARCHAR2(300) No - -

Table: COU NTRY

Column N am e Dat a T ype Nullabl e Def ault Primar y K ey

CID NUMBER No - 1

CNAME VARCHAR2(300) No - -

(18)

Column N am e Dat a T ype Nullabl e Def ault Primar y K ey

JOBAPPID VARCHAR2(300) No - 1

JOBID NUMBER No - -

USERID VARCHAR2(50) No - -

JOBTIME TIMESTAMP(6) No - -

JOBDATE DATE Yes - -

STATUS VARCHAR2(1) No - -

Table: US ER _DET AI LS

Column N am e Dat a T ype Nullabl e Def ault Primar y K ey

USERID VARCHAR2(50) No - 1 FNAME VARCHAR2(50) No - - LNAME VARCHAR2(50) No - - PASSWORD VARCHAR2(50) No - - SQ VARCHAR2(300) No - - ANS VARCHAR2(300) No - - GEN VARCHAR2(10) No - - DOB VARCHAR2(10) No - -

COUNTRY VARCHAR2(50) Yes - -

CITY VARCHAR2(50) Yes - -

CONTACT VARCHAR2(20) No - -

EXP VARCHAR2(10) No - -

HQ VARCHAR2(30) Yes - -

MARKS VARCHAR2(10) Yes - -

BOARD VARCHAR2(100) Yes - -

OQ VARCHAR2(100) Yes - -

CATEGORY VARCHAR2(50) No - -

KEYSKILL1 VARCHAR2(50) No - -

KEYSKILL2 VARCHAR2(50) Yes - -

KEYSKILL3 VARCHAR2(50) Yes - -

KEYSKILL4 VARCHAR2(50) Yes - -

KEYSKILL5 VARCHAR2(50) Yes - -

PJLOC VARCHAR2(50) No - -

RESUME VARCHAR2(300) Yes - -

(19)

Table: REC RUITE R_DET AI LS

Column N am e Dat a T ype Nullabl e Def ault Primar y K ey

RID VARCHAR2(300) No - 1

CNAME VARCHAR2(300) Yes - -

RNAME VARCHAR2(300) Yes - -

ADDRESS VARCHAR2(3000) Yes - -

COUNTRY VARCHAR2(300) Yes - -

CITY VARCHAR2(300) Yes - -

PIN VARCHAR2(300) Yes - -

CONTACT VARCHAR2(300) Yes - -

SECONDARYCONTACT VARCHAR2(300) Yes - -

COMWEBSITE VARCHAR2(300) Yes - -

RRTIME TIMESTAMP(6) Yes - -

PASSWORD VARCHAR2(300) No - -

(20)

Functional Architecture

(21)

Assumption: Admin

 Admin can log-in the system.

 Manage users

 Manage Recruiters

 Manage Jobs

Assumption: Users

 User can register in the system

 User can log-in the system

 User can Upload CV

 User can Download Forgot Password

 Search jobs

 Apply jobs

 Update profile Details

 Make Professional Resume(payment details)

Assumption: Recruiters

 Recruiters can register in the system

 Recruiters can log-in in the system

 Jobs post

 Delete jobs

 Update jobs

(22)

ONLINE JOB PORRTAL USER ADMIN 0 1. US ER DE TA IL S F O R RE GI ST ER 2 . I D & P A S S W O R D F O R L O G I N 3 . J O B S E A R C H D E T A I L S 4. U SE RI D W IT H U P D A T EI N F O 5. GE NR AT E PA Y M EN T ID 1. GE NE RA TE D US ER ID & PA SS W O RD 2. L O GI N P R O FI LE G E N E R A T E D 3 . S E A R C H R E S U L T 4 . A C K F O R U P D A T I O N 1 A D M IN ID & P A SS W O R D F O RL O GI N 3. M AN AG E JO B DE TA ILS 4 M A N A GE RE CR UI TE R DE TA IL S 1. A D MI N PR OF IL EG E N ER AT ED 3 A C K F O R M A N A G E J O B D E T A I L S 2 . A C K F O R M A N G E U S E R D E T A I L S 3 RE CR UI TE R ID & PA SS W O R D FO R LO 1 .J O B P O S T D E T A IL S 4 J O B I D F O R U P D A T I O N 2 R E C R U IT E R D E T A IL S 5A PP R O V AL DE TA IL S F O R RE CR UI T 5 AC K FO R JO B AP PR O VA L 4 .JO BI DF OR UP DA TI ON OF JO B 3 RE CR UIT ER PR OFI LE DE TAI LS OP EN ED 2 PR OV ID EI D &P AS S W OR D 1 JOB ID GE NE RAT ED 5 . P A Y M E N T D E T A IL S 2 M A N A G E U SE R D ET AI LS A C K F O R R E C R U I T E R D E T A I L S

(23)

DFD FOR ONLINE JOBPORTAL LEVEL 1 (ADMIN)

ADMIN

LOGIN

ADMIN ID & PASSWORD FOR LOGIN

ADMIN LOGIN PROFILE OPENED D6 ADMIN

MANAGE JOB 1

2

MANAGE JOB DETAILS

ACK FOR MANAGING JOB

D3 JOB_POST

D5 CATEGORY

MANAGE

RECRUITER D4 RECRUTER_DETAILS

MANAGE RECRUTER DETAILS

ACK FOR MANAGE RECRUTER DETAILS

MANAGE USERS

ACK FOR MANAGE USERS DETAILS

MANAGE USER DETAILS

D1 USER_DETAILS

3

(24)

DFD for online Job Portal LEVEL 1(Recruiter)

RECRUITER

REGISTATION 1.1

RECRUITER DETAILS

PROVIDE ID & PASSWORD

LOGIN

RECRUITER DETAILS FOR REGISTER

D4 RECRUITER_D ETAILS

1

D3 JOB_POST

PROVIDE ID& PASSWORD

POST JOB

P0.33

JOB ID & RID FOR UPDATION

POST JOB UPDATE

ACK FOR UPDATION

JOB POST DETAILS

ACK FOR JOB POST

APPROVAL OF JOBS

P0.44

ACK DETAILS FOR JOB APPROVAL

APPROVAL DETAILS FOR RECRUMENT

(25)

DFD for online Job Portal LEVEL 1(User)

USER

JOB SCARCH

P0.3

JOB SCARCH DETAILS

SCARCH RESULT FOR USER DETAILS

REGISTRATIO N

USER DETAILS FOR REGISTER

D3 JOB_POST

P0.1

D1 USER_DETAILS PROVIDE ID & PASSWORD

LOGIN P0.2

ID & PASSWORD FOR LOGIN

USER PROFILE DETAILS

APPLIING FOR JOB A C K F O R A P P L YI N G J O B

(26)

DFD FOR ONLINE JOBPORTAL LEVEL 2 (ADMIN MANAGES

USERS)

ADMIN DELETE USERS VIEW USERS CANDIDATE SELECTION

USER ID FOR DELETE USER

ACK FOR USER DELETION

USER ID FOR VIEWING USER

ACK FOR USER DETAILS

D1 USER_DETAILS

USER ID WITH JOB CRITERIA

LIST OF SORT LISTED CANDIDATES D3 JOB_POST

P0.11111

P0.22222

(27)

DFD FOR ONLINE JOBPORTAL LEVEL 2(USERS)

USER PAYMENT FOR USER PAYMENT DETAILS PAYMENT ID GENERATED D9 PAYMENT_USER RECRUTER PAYMENT FOR RECRUITER PAYMENT DETAILS PAYMENT ID GENERATED D10 PAYMENT_RECRUI TER

(28)

DFD FOR ONLINE JOBPORTAL LEVEL 2 (ADMIN

MANAGES JOBS)

ADMIN VIEW JOBS

P0.1111 JOB ID FOR VIEW JOB

ACK FOR VIEW JOB

DELETE JOB

P0.2222 JOB ID FOR DELETE JOB

ACK FOR DELETE JOB

DFD for online Job Portal LEVEL 2 (Admin manage Recruiter)

D3

RECRUITER_DETAILS

ADMIN DELETE

RECRUITER P0.3333

RID FOR DELETE RECRUTER

ACK FOR DELETE RECRUITER ACK FOR VIEWING DETAILS

D4

(29)

Entity Relationship (E-R) Diagram in DBMS

A graphical representation of the entities and the relationships between them. Entity

relationship diagrams are a useful medium to achieve a common understanding of data

among users and application developers.

(30)
(31)

How to Run The Project

Follow the below steps to run the project – 1. Open the NetBeans IDE

2. After Open your NetBeans IDE 3. Select the ‘jobportal’ project

4. Right Click on ‘Jobportal’ project, below screen will be displayed 5. Click on Run option

(32)

6.After that GlashFish 3.0 Webserver automatically Start with NetBeans IDE 7.Deafult Browser will be automatically open your web project

Now we can able to access the application using – http://localhost:8081/jobportal/

NOTE

: When we write our project in NetBeans IDE at the time Configure The Project & add

corresponding Jar files…

1.

We neend to add The odbc14.jar for Database Connectivity as follows……..

Write click on our project(ONLINE JOBPORTAL) sub folder “Libaries” …….>Add Jar

Folders…..>Goto

this

Path

C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib\ojdbc14.jar…>open.

(33)

Screen shots

1. Jobseekers Login Page:-

(34)

3. Admin Login Page: (Admin log-in via Url)

(35)
(36)
(37)
(38)

9. Job Details:

(39)
(40)

13. Recruiter’s Job posted page

(41)

Website development: Future Scope

For future development, we will first consider all previously assumed options which are not

yet developed. This we can make the website livelier in action, so that can be considered as

popular online job portal website.

At this some future development has to be taken into account, such as…..

 A payment system against a professional resume.

 Auto-Generated Mailing System informing both the Job-Seekers and the Recruiters.

 SMS-Alert direct phone.

 The errors occurred due to failure nature of the website has to be reduce as far

possible to make the site & more user friendly in nature.

 This website should be launched in World Wide Web (www) to have the live version

over the internet.

These failures will Emphasis the whole development procedure.

We should look for the whole prospective in the near future for a successful, most popular

and user-friendly website which will be frequently updated with some extra new features as

well as attractive altering ornamentations in the user interface.

(42)

Bibliography

To develop the web site certain helps are taken from different books of renowned authors. The references are, therefore, as follows…….

1. Java2 Complete Reference Author: Herbert Scheldt

Publisher: TMH , Edition –Seventh

2. HTML 5 Black Book

Author: Kogent Learning Solutions Inc. Publisher: Dremtech press

3. SQL/pl-sql

Author: Ivan bayross Publisher: bpb

4.Head First Java, 2/Ed(Cover Java 5.0) Author: Kathy Sierra, Bert Bates

Publisher: Shroff O Reilly

5. www.w3school.com (it helps HTML ,AJAX, JavaScript & etc) 6. www.roseindia.com

7. www.javapractice.com 8.www.avajava.com/tutorials 9. www.java-samples.com/jsp/

(43)

Figure

Updating...

References