Hanoi-Aptech Computer Education Group 266
Marvell Consultancies Ltd
Documentation
Group 266
Group Member
Student 384484: Bui Van Thang
Student 303230: Dao Thi Uyen
Student 339624: Tran Van Manh
Student 409096: Vu Xuan Viet
Instructor Phung Anh Tan
- Hanoi, 22 /1/ 2011
Marvell Consultancies Ltd
Page 1 of 34
Hanoi-Aptech Computer Education Group 266
INDEX
1.Problem Definition 5
Our clients Marvell Consultancies ltd., is a Recruitment (consultancy) Agency firm
that bridges the gap between the Job providers and the job seekers. It maintains the
details of both, the job providers and the seekers and act accordingly as per their
requirements. Due to the rapid increase of IT Companies, etc… and as well the seekers,
the demand for the consultancies has been increased, as they are one of the sources for
recruitment. So in order to maintain and retain the customers and clients, it want an
application to be developed which meets the requirements and increase the comfort level
to both the job seekers and the Providers 5
5
The firm’s (Marvell Consultancies Ltd.) main work is to accumulate the records of
the vacancies in companies, and maintain the records of the registered candidates with the
firm, as well they search in some of the job sites for the candidates who meet the profile
of the vacancies that are needed to be filled, so that they can reach up to a maximum
number of people and they on behalf of the company (client) conduct part of the
recruitment process, and then forward the candidate profile who is through their

recruitment process to their client for further process of the recruitment. They also need
to maintain the list of the candidates who have come for the interview and of those who
are through the recruitment process and are guided to attend for further rounds of
interview at the client’s office, for easy reference 5
After a candidate who was sent through the firm gets selected and join their company, the
company (client) will pay as per their contract with the firm. They used to calculate the
payments that are received and that are to be received and maintain the list of the
payment company wise, for easy reference 5
They use heavy paper work to store the details of the candidates who register, (along
with the skills, background and experience) those who attended for the interview along
with the result of the interview conducted at the firm, and as well they maintain the
separate records of the companies depending on the priority and vacancies including the
payment 5
It is a tedious job to regularly update the details of the vacancies as they keep on
changing, as it includes searching the details of the company as it is maintained in files
(as some of the companies consider other consultancies also and they themselves also
recruit by giving advertisement in the newspapers, some of the jobsites, etc…), so they
need to regularly check with the clients and update the details based on which the
recruitment takes place 6
If the Candidate is through with the whole interview process and joined the
company, then the client’s pay money to the firm for the service provided as per their
contract like if 1 – 30 candidates are hired they are provided with 5% of the candidates
salary per each candidate, and for 30 – 100 candidates the firm is paid 8% of the
candidate’s salary per each candidate, and for 100 – 250 the firm will be paid 10% per
each candidate as per their salary, and for 250 – 500 they will be paid 15% and for 500
and above it will be 20% of the candidate’s salary per head. Also the payment depends on
the relationship of the client with the firm and as well with the number of jobseekers
recruited and they are taken in to their company (Client’s) 6
They want to incorporate a system application to be developed that maintains the
details of the customers and that of the clients along with the payments, number of

vacancies, which are to be updated regularly as they keep on changing from time to time.
Marvell Consultancies Ltd
Page 2 of 34
Hanoi-Aptech Computer Education Group 266
When they open a profile of a candidate they should be able to know his qualification,
experience, and as well the contact information as they need to be contact when ever
his/her profile is matching with the required profile for a job vacancy to come to the
office for attending the interview. First few rounds like aptitude and technical round tests
are to be conducted and if the candidate is through it he/she will be permitted for the next
rounds of the interview, which is to be conducted by the client alone at their office.
Similarly when a profile of the Client is opened they should no the details of the
company, vacancies, skills required and as well about the location. Also there should be
provision for searching the vacancies from the Client’s module and as well the names of
the Jobseekers based on the skills, Location and Experience 6
They want the system to be in a modular form where Registration of the job seekers
and the client is maintained in modules, which comprises of the contact details and the
personal information of each. And there is a profile module, which holds the information
of the candidate’s experience, skills acquired and location he is willing to apply for.
There should be an option for searching skill wise, experience wise and location wise, so
that the time for retrieving the details is reduced. Another module for the Vacancies
where all the information of the vacancies of the company is gathered along with the
requirements for the positions that is vacant 6
It should include sub-modules like the Details of the clients/customers, requirements
such as skills, location and experience required for a particular job separately in both the
modules like Client and Customers. They should also maintain a sub-module, which
includes who attended for the recruitment and the marks or grade secured in the process,
and the ones who are short listed for the further rounds of the interview are maintained
and the ones who got finally selected by the client in the customer’s module, where as in
the Client’s activity sub-module the details of the job seekers (referred by the firm) who
are hired and that of those who are not hired, for easy reference for the calculation of the

payments, as well to keep track of the customers who were not selected so that they can
refer them to the other companies based on their profile, etc… In the Payments sub-
module, which is to be included in the Clients Module, the details of the previous
payments and that of the current are to be maintained. The payments depend on the
relation ship with the company and as well with the number of seekers hired from the
firm 7
Thus by this system application they want to reduce the paper work and time
consumption and as well they want to make it an easy reference for all the functions of
the firm 7
►Non-Financial : 7
►Financial : 8
The charges vary depending on the type of relationship with the client and as well the
number of candidates hired. As the details of the candidates and the client’s are
maintained separately activity wise, it has become easier to calculate the charges and to
regularly keep track of the payments. The firm should be able to retrieve the details of the
payments of any particular period 8
Registration of the candidates before attending for the interview 8
Calculation of the payments as per the firms policy 8
Maintenance of the records in a modular form like Client and the customer, and in turn in
sub-modular form so that they can keep track of the records, there by reducing the time
consumption and slipups and the huge amount of paperwork 8
Regularly updating the details of the job vacancies and that of the candidates 8
Marvell Consultancies Ltd
Page 3 of 34
Hanoi-Aptech Computer Education Group 266
This application of our still limited in many professional, and it only meets for fewer
users 8
2.Customer Requirements Specification 10
10
View Statistic 11

11
2.2.2: Normal Users 11
Log out 11
Job seekers management 12
Select Job Seekers for Job Provider 12
Payment management 12
Statistic work’s result 12
Architecture & Design of Project 13
Table 2 Class : captures classification that Client and Job Seeker want to register 23
31
Vacancies management 31
31
Invoice management 31
32
3.Task Sheet 33
4: Checklists 34
Marvell Consultancies Ltd
Page 4 of 34
Hanoi-Aptech Computer Education Group 266
1. Problem Definition
1.1. Problem Abstraction
Our clients Marvell Consultancies ltd., is a Recruitment (consultancy) Agency firm
that bridges the gap between the Job providers and the job seekers. It maintains the
details of both, the job providers and the seekers and act accordingly as per their
requirements. Due to the rapid increase of IT Companies, etc… and as well the
seekers, the demand for the consultancies has been increased, as they are one of the
sources for recruitment. So in order to maintain and retain the customers and clients,
it want an application to be developed which meets the requirements and increase the
comfort level to both the job seekers and the Providers
.

1.2. The Current System
The firm’s (Marvell Consultancies Ltd.) main work is to accumulate the records
of the vacancies in companies, and maintain the records of the registered
candidates with the firm, as well they search in some of the job sites for the
candidates who meet the profile of the vacancies that are needed to be filled, so
that they can reach up to a maximum number of people and they on behalf of
the company (client) conduct part of the recruitment process, and then forward
the candidate profile who is through their recruitment process to their client for
further process of the recruitment. They also need to maintain the list of the
candidates who have come for the interview and of those who are through the
recruitment process and are guided to attend for further rounds of interview at
the client’s office, for easy reference.
After a candidate who was sent through the firm gets selected and join their
company, the company (client) will pay as per their contract with the firm.
They used to calculate the payments that are received and that are to be
received and maintain the list of the payment company wise, for easy reference.
They use heavy paper work to store the details of the candidates who register,
(along with the skills, background and experience) those who attended for the
interview along with the result of the interview conducted at the firm, and as
well they maintain the separate records of the companies depending on the
priority and vacancies including the payment.
Marvell Consultancies Ltd
Page 5 of 34
Hanoi-Aptech Computer Education Group 266
It is a tedious job to regularly update the details of the vacancies as they keep
on changing, as it includes searching the details of the company as it is
maintained in files (as some of the companies consider other consultancies also
and they themselves also recruit by giving advertisement in the newspapers,
some of the jobsites, etc…), so they need to regularly check with the clients and
update the details based on which the recruitment takes place.

If the Candidate is through with the whole interview process and joined the
company, then the client’s pay money to the firm for the service provided as per their
contract like if 1 – 30 candidates are hired they are provided with 5% of the
candidates salary per each candidate, and for 30 – 100 candidates the firm is paid 8%
of the candidate’s salary per each candidate, and for 100 – 250 the firm will be paid
10% per each candidate as per their salary, and for 250 – 500 they will be paid 15%
and for 500 and above it will be 20% of the candidate’s salary per head. Also the
payment depends on the relationship of the client with the firm and as well with the
number of jobseekers recruited and they are taken in to their company (Client’s).
1.3. The Proposed System
They want to incorporate a system application to be developed that maintains the
details of the customers and that of the clients along with the payments, number of
vacancies, which are to be updated regularly as they keep on changing from time to
time. When they open a profile of a candidate they should be able to know his
qualification, experience, and as well the contact information as they need to be
contact when ever his/her profile is matching with the required profile for a job
vacancy to come to the office for attending the interview. First few rounds like
aptitude and technical round tests are to be conducted and if the candidate is through
it he/she will be permitted for the next rounds of the interview, which is to be
conducted by the client alone at their office. Similarly when a profile of the Client is
opened they should no the details of the company, vacancies, skills required and as
well about the location. Also there should be provision for searching the vacancies
from the Client’s module and as well the names of the Jobseekers based on the skills,
Location and Experience.
They want the system to be in a modular form where Registration of the job seekers
and the client is maintained in modules, which comprises of the contact details and
the personal information of each. And there is a profile module, which holds the
information of the candidate’s experience, skills acquired and location he is willing
to apply for. There should be an option for searching skill wise, experience wise and
location wise, so that the time for retrieving the details is reduced. Another module

for the Vacancies where all the information of the vacancies of the company is
gathered along with the requirements for the positions that is vacant.
Marvell Consultancies Ltd
Page 6 of 34
Hanoi-Aptech Computer Education Group 266
It should include sub-modules like the Details of the clients/customers, requirements
such as skills, location and experience required for a particular job separately in both
the modules like Client and Customers. They should also maintain a sub-module,
which includes who attended for the recruitment and the marks or grade secured in
the process, and the ones who are short listed for the further rounds of the interview
are maintained and the ones who got finally selected by the client in the customer’s
module, where as in the Client’s activity sub-module the details of the job seekers
(referred by the firm) who are hired and that of those who are not hired, for easy
reference for the calculation of the payments, as well to keep track of the customers
who were not selected so that they can refer them to the other companies based on
their profile, etc… In the Payments sub-module, which is to be included in the
Clients Module, the details of the previous payments and that of the current are to be
maintained. The payments depend on the relation ship with the company and as well
with the number of seekers hired from the firm
Thus by this system application they want to reduce the paper work and time
consumption and as well they want to make it an easy reference for all the functions
of the firm.
►Non-Financial :
• Maintaining a single application that holds all the details of the clients and
as well that of the customers in a modular form.
• Maintaining separate records of the details like personal profiles of the client
and that of the customers who had registered with the firm, Requirements
based on the skills, technology, salary, location, Company, Marks, etc… and
as well the payments in sub-modules so as to keep track of the details and as
to make it easy to regularly update the details.

• There should be a search option in both the modules (Client and the customer)
for searching the details based on the requirements like the skills, experience,
etc… so as to reduce the time consumption
• Based on the relation ship with the client and the number of jobseekers hired
from this firm they will be charged.
• Maintaining separate list of the candidates who have attended for the
interview and that of those who are short listed and then sent to the Client’s
office for further rounds of interview and that of those who are being absorbed
by the company
Marvell Consultancies Ltd
Page 7 of 34
Hanoi-Aptech Computer Education Group 266
• By providing an option for the updating the data, it has still become easier to
maintain the records, thereby reducing the huge amount of paper work and the
time consumption for searching and updating the details
• There should be an option for Adding, deleting, updating and saving the
records so that the data cannot be loosed.
• Also there is an option for fetching the details of the activities, payments for
any particular period, so that they can regularly keep track of it.
►Financial :
The charges vary depending on the type of relationship with the client and as well the
number of candidates hired. As the details of the candidates and the client’s are
maintained separately activity wise, it has become easier to calculate the charges and
to regularly keep track of the payments. The firm should be able to retrieve the
details of the payments of any particular period.
Functional Requirements :
Registration of the candidates before attending for the interview.
Calculation of the payments as per the firms policy
Maintenance of the records in a modular form like Client and the customer, and in turn in
sub-modular form so that they can keep track of the records, there by reducing the

time consumption and slipups and the huge amount of paperwork.
Regularly updating the details of the job vacancies and that of the candidates.
1.4. Boundaries of the System
This application of our still limited in many professional, and it only meets for fewer
users.
1.5. Hardware and Software Requirements
1.5.1. Minimum Requirements
Client Server
Hardware Pentium IV,600MHz
Ram 512GB
Pentium IV, 2.0MHz
Ram 1GB
Software JDK 1.4.1 (or later )
Window XP or over
JDK 1.4.1 (or later )
SQL server 2005
Window XP or over
NetBeans 5.1 (or later)
Marvell Consultancies Ltd
Page 8 of 34
Hanoi-Aptech Computer Education Group 266
1.5.2. Recommended Requirements
Client Server
Hardware Pentium IV,1.2MHz or
more better
Ram 1GB or more better
Pentium IV,3.0 MHz or more
better
Ram 2GB or more better
Software JDK 1.4.1 (or later )

Window XP or over
JDK 1.4.1 (or later )
SQL server 2005
Window XP or over
NetBeans 5.1(or later)
Marvell Consultancies Ltd
Page 9 of 34
Hanoi-Aptech Computer Education Group 266
2. Customer Requirements Specification
2.1. Users of the System
- Admin.
- Login.
- Log out.
- Normal Users Management.
- Message management
- View static.
- Normal Users.
- Login.
- Log out.
- Job seekers Management.
- Job provider Management.
- Select Job Seeker for Job Provider.
- Payment Management.
- Statistic work’s result.
2.2. System functions
Main function: - Users Management.
- Job seekers Management.
- Management job provider.
- Management Payment.
- Statistic and Report works.

2.2.1: Admin
• Login
Description To allow the admin login
Input User Name and Password
Process Check valid Name and Password in database
Output Display the result login
• Log out
Description
Allow the admin log out.
Input
Action to logout
Process
escape from program's system
Output
Display message and exit system
Marvell Consultancies Ltd
Page 10 of 34
Hanoi-Aptech Computer Education Group 266
• Users management
Description
Manager can add, edit, delete, view, search, view history of User.
Input
Information of charges
Process
Insert, update, display, search or delete information into database.
Output
Display message box successful or unsuccessful
• Message management
Description
Manager can delete, view message send for User.

Input
Information of charges
Process
display or delete information into database.
Output
Display message box successful or unsuccessful
• View Statistic

2.2.2: Normal Users
• Login
Description To allow the admin login
Input User Name and Password
Process Check valid Name and Password in database
Output Display the result login
• Log out
Description
Allow the admin log out.
Input
Action to logout
Process
escape from program's system
Marvell Consultancies Ltd
Page 11 of 34
Description Statistic work’s result
Input
Statistic Requirement
Process
Process Statistic data with requirement
Output
Statistics Result

Hanoi-Aptech Computer Education Group 266
Output
Display message and exit system
• Job seekers management.
Description
Manager can add, edit, view, search or delete information of job seeker
Input
Information of charges
Process
Insert, update, view, search or delete information into database.
Output
Display message box successful or unsuccessful
• Job provider management.
Description
Manager can add, edit, view, search or delete information of job provider.
Input
Information of charges
Process
Insert, update, view, search or delete information into database.
Output
Display message box successful or unsuccessful
• Select Job Seekers for Job Provider
Description
Choice Job Seekers who response Requirements of Jobprovider
Input
List of Job Seekers
Process
Check all job seekers who response Requirements of Jobprovider and
move to a new list is Interview
Output

Valid List of Job seekers
• Payment management
Description
Calculate Money which Client will pay
Input
Number job Seekers who are choosen , list their ID , Client’s ID
Process
Calculate Money and delete Job Seekers’s ID from List Job Seekers
Output
Number of Money which Client will pay
• Statistic work’s result
Description
Statistic work’s result
Input
Statistic Requirement
Process
Process Statistic data with requirement
Marvell Consultancies Ltd
Page 12 of 34
Hanoi-Aptech Computer Education Group 266
Output
Statistics Result
Architecture & Design of Project
2.3. Data Flow Diagram
LEVEL 0 – Context Diagram
Note:
Marvell Consultancies Ltd
Page 13 of 34
Consultancies
Management

Process
UserAdministrators
Process
External Entity
Data store
Data flow
Hanoi-Aptech Computer Education Group 266
Marvell Consultancies Ltd
Page 14 of 34
Administrator
1.1
Authenticatio
n
1.2
User
Management
1.3
Job seeker
Management
User
1.4
Job provider
Management
Hanoi-Aptech Computer Education Group 266


LEVEL 1: Application Process
Marvell Consultancies Ltd
Page 15 of 34
Administrator

1.5
Vacancies
Management
1.6
Payment
Management
1.7
View Statistic
User
1.8
Message
Management
Hanoi-Aptech Computer Education Group 266
LEVEL 1.1: Authentication process
Marvell Consultancies Ltd
Page 16 of 34
User
1.1.1
Login
1.1.2
Log out
1.1.3
Change
Info
Administrator
User
Administrator
1.2.2
Edit Profile
1.2.3

Delete User
1.2.1
Add new
User
User
Hanoi-Aptech Computer Education Group 266
Marvell Consultancies Ltd
Page 17 of 34
Administrator
1.2.5
Search
Information
of Users
User
1.2.4
View
Information
of Users
Administrator
1.2.6
History of
user
History_user
User
WorkTime
Administrator
1.2.7
Send
message for
user

User
Message
User
1.3.1
Add new
Job Seeker
1.3.2
Edit Profile
1.3.3
Search
Information
of Job
Seeker
Interview
Jobseeker
1.3.4
Delete
job Seeker
1.3.5
View Of
information
job Seeker
User
Interview
Jobseeker
Hanoi-Aptech Computer Education Group 266
LEVEL 1.2: User Management Process

LEVEL 1.3: Job seeker management Process
Marvell Consultancies Ltd

Page 18 of 34
Users
1.4.1
Add new
Job Provider
1.4.2
Edit Profile
1.4.3
Search
Information
of Job
Provider
Interview
Client
1.4.4
Delete
job provider
1.4.5
View Of
information
job provider
User
Interview
client
Hanoi-Aptech Computer Education Group 266
LEVEL 1.4: Job Seeker Management Process
Marvell Consultancies Ltd
Page 19 of 34
Hanoi-Aptech Computer Education Group 266
Marvell Consultancies Ltd

Page 20 of 34
User
Vacancies
1.5.2
Update
Vacancies
1.5.1
Add New
Vacancies
1.5.3
Delete
Vacancies

1.5.3
View
Vacancies

Hanoi-Aptech Computer Education Group 266

LEVEL 1.6: Payment management process
Marvell Consultancies Ltd
Page 21 of 34
User
Interview
1.5.4
Filter Job
Seeker For
Each
Vacancies


Skills
Interview_ Detail
JobSeeker
Vacancies
LEVEL 1.5: Vacancies management process
User
1.6.1
Payment
management

Jobseeker
Payment
Vacancie
s
Interview_detail
File Exel
Hanoi-Aptech Computer Education Group 266
LEVEL 1.7: View Static Management Process
LEVEL 1.8: Message management Process
Marvell Consultancies Ltd
Page 22 of 34
1.7.1
Statistics
Jobseekers
Users

Administrator
1.7.2
Statistics
Job

providers
1.7.3
Statistics
Payment
Payment
Client
Jobseeker
Administrator
User
1.8.2
Delete
message
1.8.1
View
message
User
Message
Hanoi-Aptech Computer Education Group 266
2.4. Entity Relationship Diagram (Table Design)
2.5. Database Structure
Table 1 Client: captures information of the job providers
Client
Fields Data type Size Null References Description
clt_ID Int No Primary Key Story the ID of job providers
clt_Name Nvarchar 150 No Store the Name of job providers
clt_Address Nvarchar 150 No Store the Address of job providers
clt_Email Varchar 50 No Store the Email of job providers
clt_Phone Varchar 20 No Store the Phone of job providers
clt_About Text No Store the About of job providers
clt_Website Varchar 50 Yes Store the Website of job providers

clt_Status Tinyint No Store the state
Status 0: disabled Client
Status 1: Avaiable CLient
Table 2 Class : captures classification that Client and Job Seeker want to register
Class
Fields Data type Size Null References Description
class_ID Tinyint No Primary Key ID of Class
Marvell Consultancies Ltd
Page 23 of 34
Hanoi-Aptech Computer Education Group 266
class_Name Nvarchar 30 No Name of Class
Table 3 Vacancies: captures the details of Vacancies
Vacancies
Fields Data type Size Null References Description
vas_ID Int No Primary Key Store the ID of Vacancies
Clt_ID Int No Foreign key
(clt_ID)
Store the ID from Client table
Job_ID Int No Foreign key
(Job_ID )
Store the ID from Job table
Class_ID Tinyint Yes Foreign key
(Class _ID )
Store the ID from Class table
vas_Quantity Int No Store the Quantity of Vacancies
Level_ID Tinyint No Foreign key
(Level _ID )
Store the ID from Level table
vas_Exp Tinyint No Store the Exp of Vacancies
Location_ID Tinyint No Foreign key

(Location _ID )
Store the ID from Location table
vas_Salary Decimal No Store the Salary of Vacancies
vas_DatePost Datetime No Store the DatePost of Vacancies
vas_DeadLine Datetime No Store the DateLine of Vacancies
vas_Status Tinyint No Store the Status of Vacancies
0 : Vacancies is unprocess
1: Vacancies is processing filter
2: Vacancies was processed filter
3: Vacancies is wating Respond
from Client
4 : Vacancies is Finished
Table 4 Payment: captures the details payment of job providers
Payment
Fields Data type Size Null References Description
pat_ID Int No Primary Key Store the ID of Payment
Vas_ID Int No Foreign key
(Vas_ID )
Store the Vas_ID of Vacancies
pat_NumberPas
s
Datetime No Store the Date of payment
Total_Pay Decimal No Store total of Pay of payment
pat_Status Tinyint No Store the status of Payment
Table 5 Jobseeker: captures information of the jobseekers
Marvell Consultancies Ltd
Page 24 of 34
Hanoi-Aptech Computer Education Group 266
Jobseeker
Fields Data

type
Size Null References Description
jor_ID Int No Primary Key Store the ID of Jobseeker
Job_ID Int No Foreign key
(Job_ID )
Store the ID from Job table
Class_ID Tinyint Yes Foreign key
(Class_ID )
Store the ID from Class table
Level_ID Tinyint No Foreign key
(Level_ID )
Store the ID from Level table
jor_Exp Tinyint No Store the Exp of Jobseeker
Location_ID Tinyint No Foreign key
(Location_ID )
Store the ID from Location table
jor_Education Nvarchar 150 No Store the School which Jobseeker
learn
jor_Salary Decimal No Store the Salary of Jobseeker
Jor_Name Nvarchar 50 No Store the Name of Jobseeker
jor_Age Tinyint No Store the Age of Jobseeker
jor_Gender Varchar 10 No Store the Gender of Jobseeker
jor_Address Nvarchar 100 No Store the Address of Jobseeker
jor_Email Nvarchar 30 Yes Store the Email of Jobseeker
jor_PhoneNumb
er
Varchar 20 No Store the Phone number of
Jobseeker
jor_Image Varchar 150 No Store the Image of Jobseeker
jor_Status Tinyint No Store status of Jobseeker

0: Not be Selected
1: waiting Client’s Respond
2: Selected
Table 6 User: captures information of the Users
User
Fields Data type Size Null References Description
ID Int No Primary Key ID of User
UserName Varchar 50 No Name of User
PassWord Varchar 20 No Password of User
FullName Nvarchar 20 No Full name of User
Address Nvarchar 50 No Address of User
NumberPhone Varchar 20 No Number phone of User
Permission Tinyint No Permission of User
Table 7 Interview: captures the details Interview between Marvell Consultancies Ltd and
jobseekers
Marvell Consultancies Ltd
Page 25 of 34