Minor Project Documentation
System: ONLINE JOB PORTAL
Environment:Microsoft .NET
Submitted by
ANIRBAN MUKHERJEE
SUHRITA SAHA
ONLINE JOB PORTAL SYSTEM Page 2
An Overview
Technology has changed the way job seekers search for jobs and employers find qualified
employees. While employers still advertise job openings through traditional advertising mediums,
such as local newspapers and magazines, today employers and job seekers turn to online job
portals to find employment matches. Job seekers can advertise their skills and search for available
positions, and employers can announce employment openings through job portals.
Job Seekers
The majority of job portals allow job seekers to sign up for a free account, which allows them to
search job openings posted by employers and post their resumes for employers to review. Portals
offer resume posting services, allowing job seekers to copy and paste resume information from a
word processing document or build a new resume with online tools. Job portals often offer the
option of submitting a completed resume, created from a word processing program such as
Microsoft Word. Job seekers can browse through job openings posted by employers and apply for
positions through the job portal.
Employers
Job portals provide a centralized location for employers to post information about job openings.
The majority of employment portals require a fee for employers to post job openings and respond
to resumes, with varying terms depending on the job portal. Employers can browse through job
seekers' resumes to find potential matches for job openings. Employers can utilize job portal
matching technology, allowing the system to find potential matches for employment openings.
Tools
Job portals often include tools and articles to help job seekers with their search. Job seekers can
use salary calculators to see where their income ranks within their industry and career mapping
technology to develop a long-term plan for career growth. Resources for job seekers include
information about effective cover letter writing, job search strategies, industry-specific resume
styles and salary negotiation techniques.
Networking
Employment portals offer community bulletin boards and forums designed to assist job seekers in
their employment search. Users can connect with other seekers or potential employers by
participating in forum conversations about sales, technology, the health care industry, government
jobs, restaurant employment and issues affecting recent college graduates.
Training
Employment portals offer online training and educational resources to help prepare job seekers for
the marketplace. Job seekers can find courses to improve marketing or typing skills and state-
specific programs to help prepare for insurance licensing exams. To advance their education, job
seekers can use employment portals to enroll in online certificate and degree programs through
accredited institutions.
ANIRBAN MUKHERJEE SUHRITA SAHA ARASHA DATTA RITUPARNA BISWAS
ONLINE JOB PORTAL SYSTEM Page 3
Objectives
Objectives of this site are as under:
To increase the business of Client.
To make it Global.
To facilitate job search.
To facilitate company so that it can search for best candidates available.
To help candidates to fetch a right job.
To act as a middle men connecting Job seeker and Provider.
Functionality
Case A - Job Seeker Administration
Job Seeker has to register himself with the site.
After success full Log in Job Seeker can register his resume.
Job Seeker Register his Bio Data in a particular Vacancy Category.
He can also update his resume.
He can search for Vacancy according to his skill set and can apply for a job.
He can check his Job Status i.e. from where does he get a response.
Case B - Job Provider Administration
Company has to register itself.
After success full Login Company can register Vacancy.
Registration for Vacancy will generate Vacancy Id.
Company can update a Vacancy.
Company can search for skill full candidate to fill up Job.
ANIRBAN MUKHERJEE SUHRITA SAHA ARASHA DATTA RITUPARNA BISWAS
ONLINE JOB PORTAL SYSTEM Page 4
Features
Front-End Features:-
Completely configurable site colors, icons and graphics
Jobs are categorized into multilevel categories for convenient browsing
Front page display for job categories, front page featured jobs and latest jobs
Job category ordering can be configured by the admin or can be set as alphabetic
Support for featured/paid job listings
Contact us form for getting feedback from visitors
Tell a friend system
Email verification (Can be switched on/off from admin panel)
Password retrieval system
In built ad management system for banner ads, text ads and affiliate ads.
Job Seeker’s Features:-
Maintain multiple resumes
View, edit, duplicate and send resumes
Mark resumes as searchable
Mark resumes as confidential
Maintain multiple cover letters
Duplicate cover letters
Advanced search for jobs
Save search results
Search jobs based on keywords, categories, locations etc.
Apply for jobs online in real time
View Company profiles
Keep track of the jobs for which you applied
Employer's End Features:-
Maintain multiple company profiles
Post multiple job offers
Edit / Remove job offers
Make your job offers featured
Other paid features like making offers bold, highlight etc.
Keep track of the applications received
Remove applications
Post logo for premium employer listing
Activate the search resume facility by paying fee based on requirements
ANIRBAN MUKHERJEE SUHRITA SAHA ARASHA DATTA RITUPARNA BISWAS
ONLINE JOB PORTAL SYSTEM Page 5
Admin Panel Features:-
Extensive usage stats (For categories, members, new sign ups, resumes, jobs etc.)
Recent stats for jobs posted today, yesterday and in last 7 days
Similar stats are available for resumes, employer sign ups, job seeker sign ups etc.
Job categories management console (multilevel)
Add / edit / remove categories
Category ordering for display on front-end
Shift jobs from one category to another
Highly configurable site parameters
Highly configurable layout parameters
Full control over site color scheme (directly from admin panel)
Create / Edit / Save as many color schemes desired
Fully customizable graphic elements (directly from admin panel)
Create / Edit / Save as many icon sets as you like
Switch ON-OFF email verification process
Configure all outgoing emails
Cleanup routines
Configure fees like job posting, premium membership, bold, featured job offers etc.
View all billing transactions
Add/edit/remove transactions
Location management console to add/edit/remove locations for which jobs can be posted
Extensive employer management console
Manage premium employers
Approve logos for premium employers
Extensive job seeker management console
View/Edit/Delete Members
Search members
Extensive jobs management console
Search/edit/delete/approve job offers
Extensive resume management console
Search/edit/delete/approve resumes
Extensive cover letter management console
Search/edit/delete/approve cover letters
Email Subscribers individually or collectively
Search subscribers
Visitor feedback section
Sponsored ad management
Support for banner ads, text ads and affiliate ads
Admin can Add / Edit / Delete / Approve / Disapprove any ad
ANIRBAN MUKHERJEE SUHRITA SAHA ARASHA DATTA RITUPARNA BISWAS
ONLINE JOB PORTAL SYSTEM Page 6
DRD – Data Flow Diagram
Symbols used in Data Flow Diagrams:-
circle
: Process
roundedrectangle : External Entity
: Data-Store
openrectangle
: Database
flatcylinder
: Data Flow
ANIRBAN MUKHERJEE SUHRITA SAHA ARASHA DATTA RITUPARNA BISWAS
ONLINE JOB PORTAL SYSTEM Page 7
DATA FLOW
DIAGRAM
Level-0
get opportunity
get applicants
give requirements
JOB SEEKERS JOB PROVIDERS
give qualifications
(users) (companies)
JOB PORTAL
MANAGEMENT
ANIRBAN MUKHERJEE SUHRITA SAHA ARASHA DATTA RITUPARNA BISWAS
ERS
applicant
NT
s)
get
JOB SEEKERS JOB PRO
(users) (comp
ANIRBAN MUKHERJEE
DATA FLOW DIAGRA
Level-1
get
send
vacancy
opportunity
create pofile
send resume
create profile
SUHRITA SAHA
st st
or or
JOB e e JO
SEEKERS re re PROVI
da da
MANAGEMENT tri tri MANAG
ta ta
ev ev
ARASHA DATTA
e e
da da
ta ta
ONLINE JOB PORTAL SYSTEM
DATABASE
RITUPARNA BISWAS
Page 8
USER COMPANY
ANIRBAN MUKHERJEE
DATA FLOW DIAGRAM
validates
validate
login / register
login / register
ACCOUNT Level-2
Details
search for openings
return search results
USER COMP.
LOGIN re LOGIN
find existing user find
gis existingcomp.
ter
SUHRITA SAHA
register new user
ne
RESUME w
JOB
Details co
SEARCH
m
store userresume pa
submit
submit
resume
vacancy
ny
retrieve
ARASHA DATTA
USER FIND COMP.
MNGMT. MATCH MNGMT.
notify company
notify user
about applicant
about opportunity
search in data-table
retrieve from data-table
retrieve
ONLINE JOB PORTAL SYSTEM
JOB OPPENINGS
RITUPARNA BISWAS
Details
Page 9
store vacancy details
ONLINE JOB PORTAL SYSTEM Page 10
ERD – Entity Relationship
Diagram
Entities:-
Job Seekers ( usr_usrid, usr_pswd, usr_name, usr_addrs, usr_email )
Job Providers ( co_usrid, co_pswd, co_name, co_addrs, co_email )
Resume ( r_qual1, r_qual2, r_qual3 )
Vacancy ( v_qual1, v_qual2, v_qual3 )
Newsletter ( nws_pno, nws_dt )
Admin ( ad_usrid, ad_pswd )
Relationship:-
Job Seekers Resume ( M : M )
Job Seekers Newsletter ( M : 1 )
Job Providers Vacancy ( M : M )
Job Portal Resume ( 1 : M )
Job Portal Newsletter ( 1 : 1 )
Job Portal Vacancy ( 1 : M )
Job Portal Admin ( 1 : 1 )
Symbols used in Entity Relationship Diagram:-
rectangle
: Entity Set
ellipse
: Attribute Property
diamond
: Relationship
ANIRBAN MUKHERJEE SUHRITA SAHA ARASHA DATTA RITUPARNA BISWAS
RITUPARNA BISWAS ARASHA DATTA SUHRITA SAHA ANIRBAN MUKHERJEE
usr_usrid usr_pswd co_pswd co_usrid
usr_name co_name
su
bsc
usr_addrs JOB SEEKERS rib JOB PROVIDERS co_addrs
es
usr_email co_email
submits NEWSLETTER submits
r_qual1 v_qual1
nws_pno p nws_dt
u
b
r_qual2 RESUME li VACANCY v_qual2
s
h
r_qual3 v_qual3
stored by JOB PORTAL stored by
manages
SYSTEMS
ADMIN
ad_usrid
DATABASE
ADMIN
ADMIN
ISA
ad_pswd
NETWORK
ADMIN
Page 11 ONLINE JOB PORTAL SYSTEM
ONLINE JOB PORTAL SYSTEM Page 12
SQL Codes and Structure of the
Tables
Job Seekers
SQL> create table jobseekers(usr_usrid varchar2(70), usr_pswd
varchar2(30),usr_namevarchar2(70),usr_addrs varchar2(70), usr_email varchar2(70));
Field Name Data Type
usr_usrid varchar2(70)
usr_pswd varchar2(30)
usr_name varchar2(70)
usr_addrs varchar2(70)
usr_email varchar2(70)
Job Providers
SQL> create table jobproviders(co_usrid varchar2(70), co_pswd
varchar2(30),co_namevarchar2(70),co_addrs varchar2(70), co_email varchar2(70));
Field Name Data Type
co_usrid varchar2(70)
co_pswd varchar2(30)
co_name varchar2(70)
co_addrs varchar2(70)
co_email varchar2(70)
Resume
SQL> create table resume(r_qual1 varchar2(70), r_qual2 varchar2(70), r_qual3 varchar2(70));
Field Name Data Type
r_qual1 varchar2(70)
r_qual2 varchar2(70)
r_qual3 varchar2(70)
Vacancy
SQL> create table vacancy(v_qual1 varchar2(70), v_qual2 varchar2(70), v_qual3 varchar2(70));
Field Name Data Type
v_qual1 varchar2(70)
v_qual2 varchar2(70)
v_qual3 varchar2(70)
ANIRBAN MUKHERJEE SUHRITA SAHA ARASHA DATTA RITUPARNA BISWAS
ONLINE JOB PORTAL SYSTEM Page 13
Newsletter
SQL> create table newsletter(nws_pno varchar2(70), nws_dt varchar2(70));
Field Name Data Type
nws_pno varchar2(70)
nws_dt varchar2(70)
Admin
SQL> create table admin(ad_usrid varchar2(70), ad_pswd varchar2(30));
Field Name Data Type
ad_usrid varchar2(70)
ad_pswd varchar2(30)
ANIRBAN MUKHERJEE SUHRITA SAHA ARASHA DATTA RITUPARNA BISWAS
