BCSP064

Project Proposal on
ONLINE JOB PORTAL

Submitted By
xxxxxxxxxxxxx
Enrollment No.:xxxxxxxxxx
Under the Guidance Of
Mr.xxxxxxxxxxxxx

Submitted to the school of computer and information science,

IGNOU in partial fulfillment of the requirements for the award of
the degree

Bachelor’s
in
Computer Application
September 17, 2023

INDIRA GANDHI NATIONAL OPEN UNIVERSITY

MAIDAN GARHI
New Delhi – 110068
Contents

1 Introduction and Objectives 2

1.1 Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
1.2 objectives . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3

2 Project Category 4

3 Analysis 6
3.1 DFD . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
3.1.1 O Level DFD . . . . . . . . . . . . . . . . . . . . . . . . . 6
3.1.2 1 Level DFD . . . . . . . . . . . . . . . . . . . . . . . . . 7
3.1.3 2 Level DFD . . . . . . . . . . . . . . . . . . . . . . . . . 8
3.2 ER Diagram . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10

4 Complete Structure 11
4.1 Module Description . . . . . . . . . . . . . . . . . . . . . . . . . . 11
4.2 Data Structure . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
4.3 Database Design . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
4.4 Process Logic Diagram . . . . . . . . . . . . . . . . . . . . . . . . 11
4.5 Testing Details . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
4.6 Report Generation . . . . . . . . . . . . . . . . . . . . . . . . . . 11

5 Tools / Platform 13

6 Project Place 14

7 Future scope and further enhancement 15

1
Chapter 1

Introduction and Objectives

1.1 Introduction
Online Job Portal provides the users, ability to register to this application
and search for jobs, apply jobs, manage their accounts. Each and every user
will have an account with their profile. On the other hand, Recruiters those
are willing to publish the jobs for their company to job seekers, can register
to job portal and get their own account created and can post jobs to portal.
Registered Recruiters can add or remove jobs and these jobs can be seen by
various user and they can contact the concern person for the job. Main aim of
the web application is to make a user friendly platform where, applicant can
search jobs and apply job easily and is accessible to everyone who is interested.
The purpose of the application is to provide job portal for job seekers, to submit
their CV and apply for jobs, where Recruiters can select best employers from
available candidate profile.
Existing System:–
The existing system is a manual system of limitations like accuracy, expense,
low speed and efficiency and unformatted outputs. In the existing system, all
data processing is done manually. All the fields and record books are replaced
by software systems when there are a lot of issues such as retrieval and stor-
age of the information and keeping track of them becomes a tedious task. By
implementing a computerized system, the limitation in the present system will
be reduced. Manpower can be reduced and accuracy can be increased to man-
ifold. Consumptions of the time can be reduced by the implementation of the
proposed system.
Proposed System:–
In the proposed system we propose to computerize the existing system activities.
In the existing system, all data processing is done manually. When there are a
lot of issues such as retrieval and storage of the information and keeping track
of them becomes a tedious task. The proposed system is aimed at eliminating
the limitations of existing system via increasing speed of information retrieval,
by increasing processing speed, data security and hence gives accurate reports.
It fully satisfies user needs. Almost all the limitations of the existing system are
reduced in a great manner. Details are stored in various files from which data
can be accessed and manipulated easily.

2
1.2 objectives
ˆ Provides the searching facilities based on various factors such as job va-
cancies, job details and Bio data.
ˆ Provides facility to apply for job as per the Job Seeker’s choice.

ˆ Jobseeker is able to view the updated notices and job details.

ˆ Administrator contact number and e-mail is available homepage.

ˆ It also manages the Job vacancies, job details, bio data and details.

ˆ It tracks all the information of job vacancies, their details and bio data of
job seekers.
ˆ Shows all the information and description of vacancies.

ˆ To increase efficiency of managing the Job vacancies and job details.

ˆ Manage the information of job seeker and Recruiters.

ˆ Editing and updating of profiles is provided.

ˆ Recruiter and Job seeker both can give feedback to this.

ˆ Recruiter and Job seeker both can view feedback also.

ˆ Less manpower needed for this application.

3
Chapter 2

Project Category

RDBMS, or Relational Database Management System, is a category of soft-

ware used for managing relational databases. These databases store data in a
structured manner using tables with rows and columns. RDBMS systems are
widely used in various industries and applications to organize, store, retrieve,
and manipulate data efficiently.

Here are some project categories related to RDBMS:

Database Design and Modeling: Projects in this category involve designing
the structure of a relational database. This includes defining tables, relation-
ships between tables, data types, and constraints. Tools like Entity-Relationship
Diagrams (ERD) and database modeling software are commonly used.
Data Migration and ETL: Projects involving data migration often require
transferring data from one RDBMS to another or from non-relational data
sources into an RDBMS. ETL (Extract, Transform, Load) processes are cru-
cial in such projects to ensure data consistency and integrity.
Database Administration: This category includes projects related to the
day-to-day management and maintenance of an RDBMS. Tasks may involve
optimizing queries, performing backups and restores, managing user access, and
monitoring database performance.
Web Development with RDBMS: Many web applications rely on RDBMS
systems to store and manage data. Projects in this category could include devel-
oping e-commerce websites, content management systems, or social networking
platforms that interact with an RDBMS to store and retrieve data.
Business Intelligence and Reporting: In this category, projects involve using
RDBMS data to create dashboards, reports, and analytics tools. Tools like SQL,
BI software (e.g., Tableau, Power BI), and data warehousing are often used.
Inventory Management Systems: Designing and implementing inventory
management systems for businesses to track and manage their inventory effi-
ciently. This often involves an RDBMS to store product information, stock
levels, and transaction records.
Customer Relationship Management (CRM) Systems: Developing CRM sys-
tems that help businesses manage customer data, interactions, and relationships.
These systems typically use an RDBMS to store customer information.
Human Resource Management Systems (HRMS): Creating HRMS software
to manage employee records, payroll, and other HR-related data using an RDBMS.

4
 E-commerce Platforms: Building online shopping platforms that use RDBMS
for product catalogs, customer accounts, order processing, and inventory man-
agement.
Healthcare Information Systems: Developing systems for healthcare institu-
tions to manage patient records, appointments, and billing using an RDBMS.
Financial Systems: Creating financial management and accounting software
that relies on an RDBMS to handle transactions, ledger entries, and financial
reporting.
Educational Management Systems: Designing systems for educational in-
stitutions to manage student records, class schedules, and grading using an
RDBMS.
Geographical Information Systems (GIS): Developing GIS applications that
use spatial data stored in an RDBMS to analyze and visualize geographic infor-
mation.
When working on RDBMS projects, it’s important to choose the right database
management system (e.g., MySQL, PostgreSQL, Oracle, SQL Server) based on
your project’s requirements and scalability needs. Additionally, understand-
ing SQL (Structured Query Language) is essential for effectively working with
relational databases.
My Project is web based RDBMS Project and i am using MYSQL as Database
Management Tools.

5
Chapter 3

Analysis

3.1 DFD
3.1.1 O Level DFD

6
3.1.2 1 Level DFD

7
3.1.3 2 Level DFD

8
9
3.2 ER Diagram

10
Chapter 4

Complete Structure

4.1 Module Description

4.2 Data Structure
4.3 Database Design
4.4 Process Logic Diagram
4.5 Testing Details
4.6 Report Generation

Field Name Data Type Allow Null Costraint

Mid int NOT PK
Fname nvarchar(50) YES

Table 4.1: MessageMst

11
Field Name Data Type Allow Null Costraint
Adminid Bigint NOT PK
Password varchar(20) NOT

Table 4.2: Admin

12
Chapter 5

Tools / Platform

13
Chapter 6

Project Place

14
Chapter 7

Future scope and further

enhancement

15