pre post recruitment

7/30/2019 Pre Post Recruitment

1/32

1. INTRODUCTION

1.1 ORGANIZATION PROFILE

"MEENAKSHI & CO" is one of the leading companies in HR Services. The

company is involved Business divisions are HR (Recruitment and Staffing solutions)

and Web Applications Development. HR (Recruitment and Staffing) and Web

Applications Development are two key areas.

Established in 1994, MEENAKSHI & CO is one of the leading full service

recruitment solutions company in India. We offer a wide range of recruitment

solutions like Recruitment, Staffing, Executive Search, RPO. Our solutions can be

configured to address your business needs.

MEENAKSHI & CO, has a pan India presence, with offices in Mumbai,

Bangalore, Delhi, Chennai and Pune. This gives the ability to tap the best of talent

available in India and also provide clients personalized account management.

MEENAKSHI & CO holistic approach to recruitment ensures a correct fit

both technically and culturally with our client's organization. At focus we believe in

the Partnership Approach with our clients and consider ourselves as an extension of

clients.

The company always aspires to add value to our clients, maintain a very high

level of confidentiality and help the customer at all stages of the recruitment

procedure. It is extremely well networked with the best of talent at all times and our

research team helps in providing a great insight into narrowing down our search

making it more relevant and specific.

The company services have been appreciated by our customers and

MEENAKSHI & CO has won several awards and citations from various clients.

MEENAKSHI & CO has also been awarded as the fastest growing Mid-sized

recruitment firm by ERA, the Chamber of commerce for the recruitment industry in

February 2008.

1


2/32

1.2 ABOUT THE PROJECT

The "PRE POST RECRUITMENT" is an application which handles the

various activities of the recruitment department in MEENAKSHI & CO and

Publishers.

This project is helpful in recoding the details of the candidates appearing for

an interview. It manages the details like the personal details of the candidate - name,

age, address, educational qualification, etc. it also maintains the details like how the

candidate knew about job openings like Paper AD - which paper - Job Website -

which job websites, or by any Consultant - Name , Address , consultant fees or % of

salary. This project keeps track of the candidates who are enrolled for the interview

and their interview date and other details.

The details of interview like the candidates attended the interview and their

performances are handled by this module. The details of various tests like Aptitude

test, Technical session, Communication skills and their score are managed by this

project. Various reports can be generated by this tool like candidate report,

performance report which is very useful for the management.

The project is developed with VB.NET as front end tool and Ms-Access as the

backend for database.

The modules covered in the project are

Personal Details

Appointment details

Performance details

Job details

Reports

Personal Details

This module is helpful in recoding the details of the candidates appearing for

an interview. It manages the details like the personal details of the candidate - name,

2


3/32

age, address, educational qualification, etc. it also maintains the details like how the

candidate knew about job openings like Paper AD - which paper - Job Website -

which job websites, or by any Consultant - Name , Address , consultant fees or % of

salary.

Appointment details

This module keeps track of the candidates who are enrolled for the interview

and their interview date and other details. Performance details


performance are handled by this module. The details of various tests like Aptitude

test, Technical session, Communication skills and their score are managed by this

module.

Job details

This module gives the details of the candidates who are recruited for company

and the details department and the designation for which they are selected and their

proposed joining date.

Reports

Various reports can be generated by this tool like candidate report,

performance report which is very useful for the management.

3


4/32

2. SYSTEM ENVIRONMENT

2.1 HARDWARE SPECIFICATION

PROCESSOR : Pentium IV

MEMORY SIZE : 1 GB RAM

HARD DISK : 80 GB

DISPLAY : 15" TFT Monitor

KEYBOARD : Samsung 104 Keys

2.2 SOFTWARE SPECIFICATION

OPERATING SYSTEM : Windows XP

FRONT - END : Visual basic.NET 2003

BACK - END : Ms-Access 2000

4


5/32

2.3 SOFTWARE FEATURES

The .NET Framework is a new computing platform that simplifies application

development in the highly distributed environment of the Internet. The .NET

Framework is designed to fulfill the following objectives:

To provide a code-execution environment that guarantees safe

execution of code, including code created by an unknown or semi-

trusted third party.

To provide a consistent object-oriented programming environment

whether object code is stored and executed locally, executed locally

but Internet-distributed, or executed remotely.

To make the developer experience consistent across widely varying

types of applications, such as Windows-based applications and Web-

based applications.

To provide a code-execution environment that minimizes software

deployment and versioning conflicts.

To provide a code-execution environment that eliminates the

performance problems of scripted or interpreted environments.

New Features in Visual Studio .NET

A number of additions have been made to Windows Forms in this release.

FolderBrowserDialog Component

The Windows Forms FolderBrowserDialog component is a modal dialog box

that is used for creating, browsing, and selecting folders.

Security in Windows Forms

A fundamental aspect of programming is making sure your applications are

secure. In Windows Forms, a great deal of work has been done to make this as easy as

possible for developers. Nonetheless, there are important issues to be aware of.

Nonrectangular Windows Forms

5


6/32

It is easy to customize the shape of Windows Forms. All that is required for

nonrectangular forms is an image file and a few property settings.

Windows Forms Designer for Managed Extensions for C++

Visual C++ introduces a rapid application development solution for creating

your Windows Forms applications in Managed Extensions for C++. For details, see

Managed Extensions for C++ Windows Applications.

Smart Device Programmability

Visual Basic .NET now allows you to develop rich applications for resource-

constrained devices. You can use the tools provided by Visual Studio .NET and the

.NET Compact Framework, a subset of the .NET Framework, to create, build, and

debug applications that run on smart devices.

While almost the entire Visual Basic language is supported for device

development, certain Visual Basic .NET features were changed or dropped to

accommodate for the inherent differences in device applications.

Ms-Access 2000

On a program of software that can help us to access data and perform

operations it is called a "Data Base Management System". The DBMS whose design

is based on the ; Relational Theory is called "The Relational Database Management

System" or RDBMS.

MS-Access is the default background for Visual Basic. Creating tables and

making data entries in MS-Access are made easier. It has the advantage of querying.

It is more faster in retrieving data can also be external to the database. It has enriched

data types.

MS-Access provides access to many concurrent users to the order of

thousands managing large amount of data could present administrative and

performance challenges.

MS-Access is a RDBMS, offers capabilities of both Relational and Object

Oriented database systems. It supports very large databases that could containhundreds of terabytes of information. The records are represented in a flat two-

6


7/32

dimensional table with rows and columns. Each column has an unique name. all

elements in each column are of same kind.

Features of MS-ACCESS:

Wizards and builders.

Macros.

Windows based application

Large data management capacity.

Importing, exporting and linking external files.

Built-in security.

7


8/32

3. SYSTEM STUDY AND DESIGN

To develop an user friendly software that meets the user needs any time.

Information can be created and altered by administrator. In the system the customer

can access the product catalog of the organization.

3.1 EXISTING SYSTEM

The system phase studies the problem, identifies alternate solution, evaluates

those solutions and finally recommends the best solution. The system study gives the

structure and function of the system. The system study can be performed only on

existing system. The system study gives an idea of the user requirements.

The Primary Objective of the existing system is to achieve competitiveness.

Increases the customer satisfaction through shorter delivery cycle

Data tampering is reduced

Provides security that protect against outsider crime

Reduces cost of operations

Observation

The observation is helpful to understand and study the entire system. By

observing, we can understand the working of the existing system. It also validates the

data gathered by other means. It also gives a better understanding of the workload and

pressures faced.

Limitations of the existing system, the exact measurement is not possible in

the system study. It will take more time in speed and accuracy is very low. Then the

uncertainly is Incused.

8


9/32

3.2 SYSTEM DESIGN

System design centers the software engineering and applied science regardless

of the software process model that is used. Once the software requirements have been

analyzed and specified, tests that are in the building and verifying the software is

done. Each activity transforms information in a number that ultimately results in

validated computer software.

System design is a process of planning a new system or to the complement of the

existing system. The design based on the limitation of the existing system. The

requirements specification gathered in the phase of system analysis.

3.2.1 Logical Design

3.2.1.1 Context Analysis Diagram

A Context Diagram confines project scope to an agreed limit by obtaining

agreement from the customer on the data flows that are included in the scope of a

project. The Context Diagram focuses on relationships with external entities and

identifies the information that is exchanged between these external entities and the

business system under review. The external entities themselves are outside the scope

of the project but the data flows between the entities and the business system are

within the project scope.

Fig 1

9

Pre Post

Recruitment


10/32

3.2.1.2 Data Flow Diagram (DFD)

Data Flow diagram is a graphical representation of the "flow" of data through

in information system. DFD's can also be used for the visulalization of data

processing. on a DFD's data items flow from an external data source or an internal

data store to an internal data store or an external data sink, via an internal process. a

DFD' provides no information about the timings of process, or about whether

processes will operate in sequence or in parallel. it is therefore quite different from a

flowchart which shows the flow of control through an algorithm, allowing to

determine what operation will be performed, in what order, and under what

circumstances but nt what kinds of data it be input to and output from the system over

where the data will come from and go to, where the data will be stoud. This is the

graphical representation of the data processes and used in the support of an

information system they describe system as collections of data that are manipulated

by functions. Data can be organised in several way. The basic elements are

Bubbles

Arrows

Open boxes

Input/output boxes

10


11/32

DFD FOR FABRIC ROLL CUTTING

Basic DFD Notations

- Source (or) Designation

- Process

- Data Storage

- Data Flow

11

Candidate

DetailsCompany

CandidateCandidate

Name,

Address

CandidateName, Address

Level 0

Interview &

Performance

Details

InterviewCandidate

id, score

Enroll

Level 1

Selection

Details SalaryCandidate

id, basic,

net

Dept Departmentname

Level 2

SelectionDepartment

name, design

Fig 0.1

Fig 1.1

Fig 2.1


12/32

3.2.1.1 Entity-Relationship Diagram

ER diagram is a model that describes the store layout of a system at high level

abstraction. The diagram is based on the three primitive concepts entities, relations

and attributes. E-R diagram enables to examine and highlight the data structure and

relationship between the data stores in data flow diagram based on the information

provided by the E-R diagram, the kind of keys or indexes needed to access the data

base can be determined. E-R diagram can express the overall logical structure of a

database graphically .E-R diagrams are simple and clear __ qualities that may well

account in large part for the widespread use of the E-R model. Such a diagram

consists of the following major components.

Rectangles which represent entity sets

Ellipses which represent attributes

Diamonds which represent relationship sets

Lines which link attributes to entity sets and entity sets to relationship sets

- Entity

- Relationship

- Attribute

- Link

12


13/32

ENTITY RELATIONSHIP DIAGRAM

1-m one to many

m-1 many to one

m-m many to many

Dcode

Candidate

Salary

InterviewPre Post

Recruitment

cid

cname

name

DOJDname

Desg

m m

m

Selection

cnam

e

ida

teapt

Tech

Comm

Perform

comment

net

LIC

PF

HRA

basic

cname

cid

Phone

City

Address

DOB

Sex cname

m

Fig 1

13


14/32

3.2.2. Physical Design

3.2.2.1. Database Design

In system design it is necessary to develop a conceptual model of data, which

specifies the relationship between data. This is used to group data into a number of

tables. The tables are organized to:

Reduce duplication of data.

Simplifying functions like adding, deleting and changing data.

Select data required for processing.

The method of organizing and structuring data into tables is known as

normalization. The collection of tables of data is called database. Using the entity

relationship diagram, the table have been designed and normalized. The tables are

shown, from pages

14


15/32

TABLE NAME : Candidate

DESCRIPTION : This table contains details about candidate.

PRIMARY KEY : Cid

Field name Data type Description

cid Text(10) Candidate Id

Cname Text(25) Candidate name

Sex Text(8) Candidate sex

Dob Date/time Date of Birth

Qual Text( 10) Qualification

Addr Text(50) Candidate address

City Text(30)

Pincode Text(6)

Phone Text( 10) Telephone number

Media. Text(25)Media by which the candidate came to know about the

job opportunity

Comments Text (150) comments

Table 1

TABLE NAME : Depart

DESCRIPTION : This table contains details about depart.

Field name Data type Description.

Dcode Text(lO) Department code

Dname Text(25) Department name

Table 2

15


16/32

TABLE NAME : Enroll

DESCRIPTION : This table contains details about enroll.

PRIMARY KEY : cid

Field name Data type Description.

cid Text(lO) Candidate id


Edate Date/time Unroll date

Idate Date/time Interview date

Table 3

TABLE NAME : Interview

DESCRIPTION : This table contains details about interview.

PRIMARY KEY : cid

Field-name Data type Description.

cid Text(10) Candidate id


Idate Date/time Interview date

Apt Number(3) Aptitude Test

Tech Number(3) Technical session

Comm. Number(3) Communication skills

Perform Number(3) Total Score

Comment Text(50) Remarks

Table 4

16


17/32

TABLE NAME : salary

DESCRIPTION : This table contains details about salary.

PRIMARY KEY : cid


cid Text(10) Candidate id


Basic Number(5) Basic salary

HRA Number(3) Allowances

PF Number(3) Provident fund

LIC Number(3)

Net Number(6) Net .salary

Table 5

TABLE NAME : selection

DESCRIPTION : This table contains details about selection.

PRIMARY KEY : cid


cid Text (10) Candidate id


DOJ Date/time Dale of joining

Dcode Text(10) Department code

Dname Text(25) Department name

Desg Text(25) Designation

Table 6

3.2.2.2. Input design

Based on the user requirements and the detailed analysis of the existing

system, the new system must be designed. This is the phase of system designing. It isthe most crucial phase in the developments of a system. The logical system design

17


18/32

arrived at as a result of systems analysis is converted into physical system design.

Errors committed by data entry operator can be controlled by the input design.

The following approaches have been incorporated into the input design of the

proposed system.

Consistent format

A fixed format is adopted for displaying the title and the messages. Bach

screen has a status line, which displays the operation that can, be performed after data

entry.

Department details

Department form handles the department details in the company.

Interactive dialogue

The system participates in. interactive dialogue and is able to cope with

missing or omitted information. It covers the dialogue by retaining adequate

information between each dialogue.

Candidate form

Candidate form manages the details like the personal details of the candidate -

name, age, address, educational qualification, etc. it also maintains the details like

how the candidate knew about; job openings like Paper AD which paper - Job

Website - which job websites, or by any Consultant - Name , Address , consultant fees

or % of salary.

User friendliness

Appropriate messages are provided to the user to inform of what is happening.

Errors are used to indicate the error code and specific error message.

Formatted screen

Data entry screens have been, designed which are similar in formatting source

documents. Help screens have been designed the user to enter data without confusion.

The Following are the input forms used in the project

18


19/32

Master form

Master form contains all the menus for accessing the different forms in the

project.

Enrollment form

Enrollment form keeps track of the candidates who are enrolled for the

interview and their interview date and. other details.

Interview details


performance are handled by this form.. The details of various tests like Aptitude lest,

Technical session, Communication skills and their score are managed by this form.

Performance details form

The details of the marks scored, by the candidates are listed in this form so

that the selection of candidates can be made easy.

Selection details form

Selection details form, gives the details of the candidates who are recruited for

company and the details department and the designation for which they ore selected

and. their proposed joining date.

Salary details form

Salary details form, gives the details of the salary fixed for the candidates who

are selected in the interview.

19


20/32

Form 1

Form Name : Personal Details

Description : This form contains details about personal

F

Geethanjali Printers

Personal Details

Personal Details

Meenakshi & Co

Personal Details

Priya

20


21/32

Form 2

Form Name : Personal Details

Description : This form contains details about Personal

Meenakshi & Co

Department Details

21


22/32

Form 3

Form Name : Candidate Details

Description : This form contains details about candidate

110

M.B.A

Meenakshi & Co

Candidate Details

22


23/32

Form 4

Form Name : Enrollment Details

Description : This form contains details about enrollment

110

03/12/2010

03/15/2010

Meenakshi & Co

Enrollment Details

23


24/32

Form 5

Form Name : Interview Details

Description : This form contains details about interview

110

03/15/2010

Meenakshi & Co

Interview Details

24


25/32

Meenakshi & Co

Performance Details

Form 6

Form Name : Performance Details

Description : This form contains details about performance

25


26/32

Form 7

Form Name : Selection Details

Description : This form contains details about selection

Meenakshi & Co

Selection Details

26


27/32

Form 8

Form Name : Salary Details

Description : This form contains details about salary

Meenakshi & Co

Salary Details

27


28/32

3.2.2.3. Output design

The output from the system is either by screen or by hard copies. Output

design aims at communicating the results of the processing to the users. The reports

are generated to suit the needs of the users. The reports have to be generated with

appropriate levels.

The objective of any information system is the generation of the reports. The

output provides direct source of Information to the user and so it is the most in the

design phase. They also provide a permanent hard copy of the results.

The output design should he well framed and it contains all the required

information and should be well formatted avoiding complexity in. getting information

from the input. So a lot of care has been taken, while designing the output. The output

design should contain all the user requirements specified in the study phase

Interview report

The details of interview conducted and the marks scored by the candidates arc

listed in this report.

Candidate report

This report lists out the details of candidates appearing for the interview.

Department report

The details of various departments in the company ore listed in this report.

Reports

Various reports can be generated by this tool like candidate report,

performance report which is very useful, for the management.

Selection report

The details of the candidates who arc selected in the interview are listed in thisreport.

Salary report

The salary fixed for the selected candidates is reported in this report.

28


29/32

Report 1

Report Name : Candidate Details

Description : This report contains details about candidate

29


30/32

Report 2

Report Name : Interview Details

Description : This report contains details about interview

30


31/32

5. CONCLUSION

The project "PRE POST RECRUITMENT" has been developed with giving

due care of the drawbacks of existing system. It is designed in such a way to remove

all problems in, the existing manual system.

The software had been tested successfully and it was also found that it is

working correctly as power user requirements.

The scope of the project is still extendable. The software has tested

successfully and it was also found that is easily up gradable. The application can be

enhanced in the future with the needs of the company since Ms-Access is backend and

is also portable. The database and the information can be update to the latest coming

versions.

There are also possibilities for enhancing and. further developing the project

with customized reports according to the latest information's and needs of the

company, since the coding are in procedural block formats , altering the code is also

made easy.

Thus the project " PRE POST RECRUITMENT " can be enhanced for

further future requirements of the company

31


32/32

6. BIBLIOGRAPHY

Books

Alan Simpson, "Mastering MS Access for Windows'9, BPB Publications,

Roger.S.Pressman "Software Engineering A Practioners Approch" Tata

McGraw Hill Edition

Renu Vig, Ekta walia,"Fundamentals of DBMS", Irwin McGraw Hill

Publication, First Edition, 1995.

Lee, "Introduction to System Analysis and Design"" - Galgotia Book Source

Publications

PKCM Bride, "Programming in Visual Basic", RPB Publication, 1999.

Desai Bipin.C,"Introduction to Database Management System", Tata McGraw

Hill Publication, Second Edition, 1998.

Jeffrey P. McManus, "VB.NET Developer's Guide to XML, and ADO.NET",

Addison Wesley

Elias.M. Awad," System Analysis and Design", Galgotia publications, Second

Edition, 1993.

Michael MCKelvy,"Visual Basic 6.0", Tata McGraw Hill Publication, Fourth

Edition, 1997.

Websites

www.sazele.org

http://www.google.com/conceptsofdatabases.html

http://www.w3schools.com/online_examples_for_visual_basic.html
http://www.sazele.org/http://www.google.com/conceptsofdatabases.htmlhttp://www.w3schools.com/online_examples_for_visual_basic.htmlhttp://www.sazele.org/http://www.google.com/conceptsofdatabases.htmlhttp://www.w3schools.com/online_examples_for_visual_basic.html

pre post recruitment

Documents