Rojgar Mitra –A Portal for Perfect

BCS-064
Rojgar Mitra
( A Portal for Perfect Jobs )

submitted by:

YOGESH SAXENA
Programm :- BCA
Enrolment No:- 175980074
Study Center :- CCIT ( 0730 )

Under the Guidance of:

Mr. PRASUN VERMA

( Submitted to the School of Computer & Information Sciences,

In partial fulfillment of the requirements )

For the degree of

Bachelor of Computer Applications ( BCA )
( 2019 )

Indira Gandhi National Open University

Maidan Garhi, New Delhi – 110 068
~1~
 Rojgar Mitra –A Portal for Perfect

TITLE OF THE SYNOPSIS

Rojgar Mitra
( A Portal For Perfect Jobs )

~2~
 Rojgar Mitra –A Portal for Perfect

Table of Contents
1. Title of the Project 3

2. Introduction and Objectives of the Project 4 -5

3. Project Category 6

4. Analysis (DFD’s, ER Diagram/Class Diagrams etc.) 7 - 14

5. A Complete structure which includes:

i. Number of modules and their description. 15
ii. Data Structure as per the project requirements
for all the modules. 16 - 17
iii. Process Logic of each module. 18 - 21
iv. Report generation. 22

6. Tools/Platform, Hardware & Software requirement

specification 23

7. Testing 24 -25

8. Security Mechanisms 26

9. Future Scope and further enhancement of the project. 27

~3~
 Rojgar Mitra –A Portal for Perfect
10. Bibliography 28

1) Introduction
In current Competitive Environment everyone who are hunting for job actually are
not aware of how to prepare their resume and hunt for right jobs for which their
profile is suitable. Through this job portal job seeker get an automated solution
where he or she can get registered and post their resumes so that they can come
across right opportunity and even can take advice from experts to make polished
and professional resume, these experts can even help candidate market their
strengths, potentials and accomplishments better. Consultants and Employers as
well can get through with beneficial services to approach right candidate. Key
Features of Consultant Business Management Services help in storing the corporate
details, Posting the job details, scheduling the interview, storing the interview
/placement status, raising the bill and even viewing the report. This complete web
portal provides various helpful services to Job Seekers like Create and posts your
Online Resume, Store cover letter for applying the dream jobs, View your Job
Application, Create your Job Manager for getting immediate matched jobs.

Employer Benefits, Expand your job exposure , Reach target candidates fast, Reduce
your cost per hire, Get Genius solutions online now, Purchase job packs, Get resume
access, Sign up for an employer membership, to Consultant like Account For New
Consultant ,Registered Consultant ,Consultants Benefits & Solutions, Get Right
Resume in Shortest Time, Paperless database hence paperless office, Track

~4~
 Rojgar Mitra –A Portal for Perfect
placement progress and billing through CVMS by maintaining complete MIS,
Organize Walk-In Interview in shortest time.

2) Objective
Objectives Of the Project

1) This is a web-based Job Portal intended to provide automated solution to Job

Seekers as well as Employers on the basis of various categories of Jobs, Job
Requirement in different Cities of India and even abroad.
2) This job Portal provides some innovative features
a. Providing platform to other consultant is highly commendable.
b. It is extremely User friendly.
c. Help placing candidates with high focused on the profile and business
requirement.
3) Job Seekers from different areas and of various profiles can register and make
there resume available to consultants and employers as well.
4) Even if job seeker does not have idea about resume making and other job
criteria then he or she can directly take suggestions from career counseling
zone.
5) Consultants and Employers from different locations get registered and post the
job according to the requirement so that job seekers can look for it and apply for
same if they have desired profile.
6) Provides Services to Employers
i. Get Access to the largest Database of Jobseeker in India and abroad.
ii. Post Your Quality Jobs and recruit most suitable candidates from
Genius with the help of ERM.
~5~
 Rojgar Mitra –A Portal for Perfect
iii. Electronic Recruitment Management for recruiting candidate.
7) Conduct Online Recruitment Test to recruit efficiently.
8) Schedule walk-in Interview.

3)Project Category

Client-Server Application (RDBMS)

RDBMS stands for Relation Database Management System. The RDBMS is responsible
for:
1.) Maintaining the relationships between data in the database.
2.) Ensuring that data is stored correctly- that the rules defining the
relationships between data are not violated.
3.) Recovering all data to a point of known consistency in the event of a system
failure
4.) RDBMS also provides referential integrity i.e. Primary Key-Foreign Key and
Unique Key-Foreign Key.
SQL Server is designed to be a client server system. Client server systems are
constructed so that the database can reside on a control computer known as a Server
and be shared among several users.
SQL Server can work with thousands of client applications simultaneously.

Transact-SQL:-

SQL Server user Transact-SQL as its database query and programming language SQL is
a set of commands that allows the user to specify the information to be retrieved or

~6~
 Rojgar Mitra –A Portal for Perfect
modified with Transact SQL. We can access data and query, update and manage
relational database system.

4) ANALYSIS (DFDs, ER DIAGRAM/CLASS

DIAGRAM)

DATA FLOW DIAGRAMS

Represents External Entity

Represents the Process

Represents the flow of Control/Data

Represents Database

Employer
Job Seeker Seeker Qualified
Information Candidate
rojgarmitra.co
m
Employer
Employer info.
Job Information Job Seeker
Consultant Consultant info

~7~
 Rojgar Mitra –A Portal for Perfect

Context Level diagram

Job Seeker Module:

Register Save
2 3
New
Jobseeker

Registratio
Jobseeker n process
JobSeeker
New

Login 1 Retrieve Details

Check
Job Seeker Authentication

valid Update
Return
Failure
Valid
Valid 5
Change Login
7 Details
Unauthorized 4
Jobseeker Check Inbox

6 Update
Retrieve Change
Details
Details

JobseekerInbox

1st level DFD

~8~
 Rojgar Mitra –A Portal for Perfect

JobSeeker

Retrieve Details

Jobseeker Name 1.1 1.2

Accept Fetch
And Password jobseeker JobseekerName
Name & and Password
Password

Check for
Authorization

1.3
Check for same
or not

5.1
Changing Change login
details
Process

5.2
Fetch username
Retrieve Details
and password

JobSeeker
Change username and
Password

5.3
Update username
Update and password

~9~
 Rojgar Mitra –A Portal for Perfect
2nd level DFD

Employer Module:

Register
Save
2 3
New Registratio
Employer

Employer n process
New

EmployerRegistration

Login 1 Retrieve Details

Check
Employer Authentication

valid Update
Return
Failure
Valid
Valid 5
` Change Login
7 Details
Unauthorized 4
Employer Check Inbox

6
Retrieve Send
Details
Requiremetns

EmployerInbox
Save

JobDetails

~ 10 ~
 Rojgar Mitra –A Portal for Perfect
1st level DFD

EmployerRegistration

Retrieve Details

EmployerID,
Name 1.1 1.2
Accept Fetch Employer
And Password Employer ID ID,
Name & Name and
Password Password

Check for
Authorization

1.3
Check for same
or not

6 6.1
Employer Send Fills all fields
Requirements

Save

JobDetails

2nd level DFD

~ 11 ~
 Rojgar Mitra –A Portal for Perfect

Consultant Module:

Register Save
2 3
New Registratio
Consultant

Consultant n process
New

ConsultantReg

Login 1 Retrieve Details

Check
Consultant Authentication
Update
valid
Return
Failure
Valid
Valid 5
Change Login
7 Details
Unauthorized 4
Consultant Check Inbox

Valid
6
Retrieve Search 8
Details Job Send Job to
outsiders

JobDetails
save
Search

1st level DFD

~ 12 ~
 Rojgar Mitra –A Portal for Perfect

ConsultantReg

Retrieve Details

ConsultantID,
Name 1.1 1.2
Accept Fetch
And Password ConsutantID, ConsultantID,
Name & Name and
Password Password

Check for
Authorization

1.3
Check for same
or not

6.2
Cosultant 6.1 Search Job as
Search Per employer
requirement

Fetch 6.3
send mail
JobDetails Save Save

JobSeekerInbox
EmployerInbox

2nd Level DFD

~ 13 ~
 Rojgar Mitra –A Portal for Perfect

Passwor Category Key

d Skill
Experience
Salar Skills Descriptio
y n
Gender Exp
Resume Job ID

Education
Name

DO
JobSeeker B Search
JobDetails
For job
Job_Seeker j
n
Job_Seeker n Job_Seeker
Education Job_Seeker

ID
Post
n n Job
Post
resume
Post
Job
No of
n m
employee
No of s
employee ID
s Revenue n Phone
Addres
Consultant
m s Employer
Stat
Job_Seeker Phone Job_Seeker e
Job_Seeker Job_Seeker
Company Category
name Name
Name Addres
s No of ID
Categor Offices Compan
y y name
ER Diagram Compan
y Type
~ 14 ~
 Rojgar Mitra –A Portal for Perfect

5) A complete structure which includes

i) Number of modules and their description:

 Job Seeker:-It involves creating new account so that job seeker can get
registered and post his or her resume on net. candidate can take
suggestions from experts in case of inability to strike right job because of
lacking knowledge of creating professional resume and other details
etc…...Job messenger can also be created so that immediate matched jobs
will directly sent to the candidate’s mail-id. New account detail is getting
stored in Job Seekers database.

 Employer:-Free account for employers where company Type, No. OF
Employers, turnover and contact details etc... get stored in employers
database. After getting registered Employer can post the job requirements,
key skills and eligibility criteria they are looking for. Even employer can
look for already posted resume of job seekers and can send alert messages
to matched profiles.

 Consultants: - This module is more or less as Employer module but

consultant comes between jobseekers and companies. Consultant get
registered first by opening new account and provide details about his own
company like URL details, revenue, Category and all. After getting
registered Consultant can post the job requirements, key skills and
eligibility criteria they are looking for. Consultant can look for already
posted resumes of job seekers according to their requirement and send
alert messages to matched resume, store interview, placement status and
all.

~ 15 ~
 Rojgar Mitra –A Portal for Perfect

 Search Jobs Module: - This module is divided into three parts. Job seeker
can directly look for appropriate opening according to their profile, city,
category and company.

ii) DATA STRUCTURE (LIST OF TABLES USED)

JobSeeker Database:

Fields DataType Description

UserID bigint(8), Unique user id
Primary key
UserName varchar(50) Login name of user
Password varchar(50) User password
PasswordQuestion varchar(50) Password question
PasswordHint varchar(50) Password question answer
Name varchar(50) Name of user
Gender varchar(50) Gender of user
MaritalStatus varchar(50) Marital status of user
DateOfBirth varchar(50) Birth date of user
Nationality varchar(50) Nationality of user
Address varchar(50) Address of user
PinCode bigint(8) Pin code
Phone bigint(8) Contact Number of user
EmailID varchar(50) EmailID of user
ResumeHighlights varchar(50) Highlight of resume
KeySkills varchar(50) User key skills
HighestDegree varchar(50) Highest degree got by user
TotalExperience varchar(50) Experience of user
CurrentSalary varchar(50) Salary status of user
Category varchar(50) Category of user
PreferredLocation varchar(50) Location preferred by user
ResumeTitle vicar(50) Title of resume
Resume varchar(50) Copy of resume
Active bit(1) Variable having value 1

~ 16 ~
 Rojgar Mitra –A Portal for Perfect

Consultant:

Field DataType Description

ConsultantID varchar(50), Unique ID for consultant
Primary key start with ‘C’ followed by 3
integers .for ex. C023
ConsultantName varchar(50) Name of consultant
Password varchar(50) Login password
PasswordQuestion varchar(50) Password question
QuestionAnswer varchar(50) Password question answer
CompanyName varchar(50) Name of consultant company
CompanyType varchar(50) Type of consultant company
Category varchar(50) Category in which consultant deals
Employees bigint(8) Number of employees work
Offices bigint(8) Number of offices
Date varchar(50) Date of registration
Address varchar(50) Address of consultant office
City varchar(50) City name
PinCode bigint(8) Zip code
Phone bigint(8) Contact number
Fax bigint(8) Fax number
Revenue varchar(50) Income of consultant
Active bit(1) Variable having value 1

~ 17 ~
 Rojgar Mitra –A Portal for Perfect

Employer Table:
Field DataType Description
EmpID varchar(50), Unique ID for employer
Primary key start with ‘E’ followed by 3
integers .for ex. E053
EmployerName varchar(50) Name of employer
Password varchar(50) Login password
PasswordQuestion varchar(50) Password question
QuestionAnswer varchar(50) Password question answer
Description varchar(50) Description about employer
CompanyName varchar(50) Name of employer company
CompanyType varchar(50) Type of employer company
Address varchar(50) Address of employer office
City varchar(50) City name
State varchar(50) State name
PinCode bigint(8) Zip code
Phone bigint(8) Contact number
Fax bigint(8) Fax number
Active bit(1) Variable having value 1

EmpInbox (Inbox of Employer):

Field DataType Description
JobID bigint(8), Unique Job ID
Primary key
UserName varchar(50) Name of user
KeySkills varchar(50) Key skills of jobseeker
CompanyName varchar(50) Name of employer company
EmployerName varchar(50) Employer name
Experience varchar(50) Experience of jobseeker
EmailID varchar(50) Email ID of jobseeker
ContactPerson varchar(50) Person to whom meet
Place varchar(50) Place where meet
DateOfInterview smalldatetime Interview date

~ 18 ~
 Rojgar Mitra –A Portal for Perfect
Active bit(1) Variable having value 1
JobDetails:

Field DataType Description

ID bigint(8), Unique ID
Primary key
EmpID varchar(50) Employer ID
EmployerName varchar(50) Employer name
CompanyName varchar(50) Name of company
ConsultantID varchar(50) ID of consultant
NumberOfVacencies bigint(8) Number of vacancies
Post varchar(50) Post for which vacancies made
Qualification varchar(50) Qualification of candidate
Experience bigint(8) Experience required in year
KeySkills varchar(50) Key skill required
ContactPerson varchar(50) Person to whom meet
Place varchar(50) Place of meeting
DateOfInterview smalldatetime Interview date
Shift varchar(50) Shift type
PickAndDrop varchar(50 Pick and drop facilities
Meal varchar(50 Meal facility
Active bit(1) Variable having value 1

JobseekerInbox:

Field DataType Description

JobID bigint(8), Unique JobID
Primary key
UserName varchar(50) Name of user
From varchar(50) By whom mail is sent
KeySkills varchar(50) Key skills of jobseeker
EmailID varchar(50) EmailID of jobseeker
Experience varchar(50) Experience of jobseeker
CompanyName varchar(50) Name of employer name
EmployerName varchar(50) Employer name
ContactPerson varchar(50) Person to whom meet
Place varchar(50) Place where meet
DateOfInterview smalldatetime Interview date
Active bit(1) Variable having value 1
~ 19 ~
 Rojgar Mitra –A Portal for Perfect

For JobSearch(Outsiders):
Field DataType Description
KeySkills varchar(50) Key skills of jobseeker
Experience varchar(50) Experience of jobseeker
CompanyName varchar(50) Name of employer name
Location varchar(50) Company location
Active bit(1) Variable having value 1

Country Table:

Field Length Constraints Data Type

Country id 5 P.k Bigint
Country Name 25 Not null Varchar

State Table:-

Field Length Constraints Data Type

State id 5 P.k Bigint
State Name 25 Not null Varchar
Country id 5 F.k Varchar

City Table:-

Field Length Constraints Data Type

City id 5 P.k Bigint
City Name 25 Not null Varchar
State id 5 F.k Varchar

~ 20 ~
 Rojgar Mitra –A Portal for Perfect

iii) PROCESS LOGIC

a) Job-Seeker:-

 Create and post your Online Resume

 Use your Resume to apply jobs online
 Store cover letter for applying the dream jobs
 View your Job Application
 Create your Job Manager for getting immediate matched jobs

b) Employer:-
 Create New Employer Account
 Registered Employer
 Employer Benefits
 Expand your job exposure
 Reach target candidates fast
 Get resume access
 Sign up for an employer membership

c) Consultant:-
Account For New Consultant
 Registered Consultant

 Consultants Benefits & Solutions

 Get Right Resume in Shortest Time

 Paperless database hence paperless office

 Organize Walk-In Interview in shortest time

~ 21 ~
 Rojgar Mitra –A Portal for Perfect
iv) Report Generation Process:
Below given reports will be generated during this project
a) Job-Seeker Report: - This report aims at the description of the Job-Seeker and
their information as ID, Name, Address and etc. so that Job-Seeker related
request/queries can be made fast. This table also indicates the required or
desired information of the Job-Seeker.
b) Complaint Report: - This report aims at the description of the complaint rendered
by the different-different Job-Seeker. This report shows of focus on the
complaint which have been rendered but still to be decision-taken. This report
won’t only show the complaint rendered by the Job-Seeker but also the
complaint rendered by the Employer and Consultant as well.

c) Employer Report: - This report aims at the details of the employers are
categorized into different-different category. Employers are identified with their
Emp_ID. Employer who firstly must be registered to the geniusJobs System and
he or she make a fast access to your (Job-Seeker) information and resume as
well.
d) Consultant Report: - This report is mainly used to describe the no. of Consultant
in the organization. Consultants are first categorized into Location-Wise. In this
table, a special field “Status” is to be taken to show the status of the Consultant
status whether or not the consultant is running or doing its job property.
e) Job-Information Report: - This report mainly aims at the information Job
rendered to the Job-Seeker by the geniusJobs System according the Job-Seeker
experience or education or key skills.

~ 22 ~
 Rojgar Mitra –A Portal for Perfect

6) HARDWARE AND SOFTWARE

SPECIFICATIONS

Hardware Specification

 Pentium D 3.0 GHz

 1 GB RAM

 1 GB Server RAM

 160 GB HDD

 160 GB Server HDD

Software Specification

 Windows 7 or Later

 ASP.NET with C#

 SQL Server2000

~ 23 ~
 Rojgar Mitra –A Portal for Perfect

7) Testing
Software testing is a critical element of software quality assurance and represents
the ultimate review of software specification, design and coding. The increasing
visibility of software as a system element and the attendant “costs” associated with
a software failure are motivating forces for well planned, thorough testing. It is not
unusual for software development organization to expend 40 percent of total
project effort on testing. Hence the importance of software testing and its
implications with respect to software quality can’t be overemphasized. Different
types of testing have been carried out for this system, and they are briefly
explained below.

Types of Testing:

Two main types of testing have been carried out to ensure that this system is a
quality product, namely the Unit Testing and Integration Testing.

Unit Testing:

Unit Testing focuses verification effort on the smallest unit of software

design module. Using the detailed description as a guide, important control paths are
tested to uncover errors within the boundary of the module. The various modules
that have undergone types of input data were given to ensure the consistency of the

~ 24 ~
 Rojgar Mitra –A Portal for Perfect
module and to ensure that information properly flows into and out of the program
unit under test. The database integrity is validated during all steps in the execution.

Integration Testing:

Integration testing is a systematic technique for constructing the program

structure while at the same time conducting tests to uncover errors associated with
interfacing. The objective is to take unit-tested modules and build a program
structure that has been detected by design. There are two types of integration testing
namely, Top-Down Integration and Bottom-Up Integration. For the system a
combination of both the types known as Sandwich Testing has been used. The Top-
Down Integration was used during the integration of the various Masters and the
Bottom-up Integration method was used during the integration of the various
modules of the process generation and the report generation.

The various validations done in this system are given below:

Consultant Login Screen:

 The Consultant id & password are checked. If he is not a valid person he can’t enter
into the system, and also he will remain in the login page only because he is not
authenticated.
 If he is a valid person he will get the menu of options to proceed further

~ 25 ~
 Rojgar Mitra –A Portal for Perfect
Similarly for login of Employers & Job Seekers also. Not only for login screens but also
for registration, forgot password, edit profile, adding/updating/deleting/getting
details of industry types, qualifications, job ads etc. all are tested accordingly

8) SECURITY MECHANISMS

VALIDATION CHECKS

1. Date Validation: The validation on date type has been specified to be of format

MM/DD/YY. Any other format is unacceptable.

2. Client Authentication: When a user logs on the system to access data from table

and database, the password is needs to be checked.

3. Password change Validation: Only authorized clients are allowed to change the

password before changing it to the new one.

4. Mailing Labels Validation: Only those Job-Seekers who are active in our database

will have labels generated.

5. Numeric Validation: There are some fields which only accept Integer values such

that Contact No, Pin Code etc.

~ 26 ~
 Rojgar Mitra –A Portal for Perfect

9) Future Scope Of PROJECT

1. Some new services can be added as and when required so that more job-seekers,
employers, consultants explore it and refer it to others.

2. Job Fairs related activities like  Past Job Fairs,  Media Coverage, Photo Gallery in
which almost every weekend we will presents an opportunity in various cities to
thousands of job seekers to meet some of the top companies in various industries and
get employed. Available Positions will be Sales, Healthcare, Information Technology,
Finance, Management, Retail, Administration, BPO and more in Jobs Fairs!
So, whether jobseekers will be looking for a better job, re-entering the workforce or
are just starting your career, don't miss the opportunity to meet with top-notch
employers in your local market!.

3. Some more user-friendly environment can be provided By Mobile Application.

Further Enhancement in project

1. Enhancement of our proposed system would be in terms of connectivity with the

rest of the departments so that information is made available throughout the
organization which leads to efficiency and speeding up of a number of processes.
2. Centralized Database in the main server could establish connections with each and
every zonal head office via satellite communication.

~ 27 ~
 Rojgar Mitra –A Portal for Perfect

10) Bibliography
 Database System Concepts By Sumita Arrora

 Software Engineering By IGNOU Blocks

 System Analysis & amp; Design By Whitten

 Professional ASP.NET by Geeksforgeeks

 Professional C# By IGNOU Blocks

Websites:

 http://www.geekyshow.com
 http://www.tutorialspoint.com
 http://codeproject.com
 http://www.w3schools.com

~ 28 ~