online job portal system
DESCRIPTION
Online Job Portal System Project Presentation in languages asp.net with c#TRANSCRIPT
A Project Presentation On ONLINE JOB PORTAL
03/10/13
1
IndexNo 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. Description Abstract(Project Profile) About the Organization Existing System Need For New System Minimum Hardware / Software Requirement Brief description of modules Project planning and gannt chart System Flowchart Data flow diagram (DFD) Data Dictionary ER diagram Brief Description of process 12.1)Process Description 12.2)Process Algorithm Input design Page no 3 4 5 6 7-8 9-10 11 12 13-16 17-28 29 30-33
1303/10/13
34-752
No 14 15 16 17 18
Description Output Design Testing Post implementation review Future Enhancement Bibliography
Page no 76-81 82-87 88 89 90
03/10/13
3
Abstract (Project Profile)Project Tittle Objective Online JobPortal
Job Portal is an application which connect company and job seekers where company can post a jobs and the job seekers can find and apply for their targeted jobs. Web Application ASP .NET with C# (.Net Framework 3.5) Microsoft SQL Server 2005 Crystal Report 10.5 , MS office 2003 , Flash 60 days
Types of application Front-end Tool Back-end Tool Other Tools Duration Time
03/10/13
4
Existing System
There is no Existing System in our Organization. All work are done manually.
03/10/13
5
Need For New System
1
Application will provide the ability to job seekers to create their profile, upload resumes, search for jobs & apply for multiple jobs. Application will provide the employers to create their accounts, search candidates, create various job postings, & track the applied candidates A new job inside the site that can send an e-mail to jobseeker account. Generate a different types of reports and different type of searching facilities.
2.
3.
4.
03/10/13
6
Minimum Hardware/Software RequirementHardware RequirementServer side Requirement:Processor: RAM:Hard disk:Core 2 duo 2 GB 80 GB
Client side Requirement:Processor: RAM:Hard disk:Pentium-IV 1GB 40 GB
03/10/13
7
Minimum Hardware/Software Requirement(con..)Software RequirementServer side Requirement:Operating System:Web Server:Windows Server 2003 IIS 6.0
Runtime environment .Net Framework 3.5 Back-end Tool:Microsoft SQL Server 2005
Client side Requirement:Operating System:Web-Browser:Windows XP or Any Compatible OS Internet Explorer 6.0 or Any compatible Browser
03/10/13
8
Brief description of Modules
Job Jobseeker can apply job. Job upload by employee. Admin can also manage upload job Employee can post job.
Manage Jobseeker & Employee Active or deactivate jobseeker & employee. Admin can manage jobseeker & employee
Notification admin send a mail to the jobseeker & employee.
Generate a Report Generate a report in our system. Generate report like posted job, applied job, feedback of job seeker and employee.
03/10/13
9
Project planning and gannt chartDevelopment Phase Requirement Gathering and Analysis Design Coding Testing Implementation & Deployment Total Time (Day) 60 Days 0 to 10 Day 11 to 20 Day 21 to 30 Day 31 to 40 Day 41 to 50 Day 51 to 60 Day Duration (Day) 10
15 25 5 5
60
03/10/13
10
System Flowchart
Start
Is Registered ? Yes Login
No
Registration
No Admin
Is Authenticate? Yes Company employee Jobseeker Search Jobs
Manage jobseekr & employee
Post jobs
Manage Job
View Jobseeker profile
Upload resume
Notification
Modify Posted jobs View applied jobs
Apply for jobs
View feedback Generate report Give Feedback
Modify applied job Give feedback
Logout 03/10/13 Stop 11
Data flow diagram(DFD) Context Level Diagram
View jobseeker & employee details, view feedback
Modify and view applied jobs, view feedback
ADMINModify jobseeker & employee ,get feedback
Online Job Portal
JOBSEEKERSearch & apply jobs, view company details, get feedback
Post a Job, get feedback
View jobseeker profile
COMPANY EMPLOYEE
03/10/13
12
First Level Diagram ( Admin)Username/ password details
ADMINAuthenticate Login info Request for company employee details
1.0 Registr ation Login
username and password
Tbl_admin_mstVerify username/pass word Add/Edit company employee details
2.0 Manage
Tbl_emp_mstView company employee details
employ Response company employee ee details employee info Request jobseeker details 3.0 Manage jobseek er
Add/ Edit jobseeker
Tbl_js_mstView/search jobseeker
Response jobseeker details
Jobseeker info Requesting for sending mail 4.0 Notificat ion View email id Generate report Give email id Jobseeker info 5.0 View feedback Feedback 6.0 generate report Report Details 13 Store Feedback
Response for sending mail
Give reply View feedback Request for report
Tbl_feedbackFetch Feedback data
ReportView Report
03/10/13
First Level Diagram ( Company Employee)Username/ password details
COMPANY EMPLOYEE
Authenticate Login info Request post job Receive post job details Job info Request for jobseeker details Response for jobseeker details
1.0 Registra tion &Login
username and password
Tbl_emp_mstVerify Username/ password
2.0 Manage Post job
Require post job
Tbl_emp_post_jobView post job details Request for available jobseeker details
3.0 view jobseeker
Tbl_js_mstView jobseeker details
Jobseeker info Request post job details
Response manage post job details job info Give reply View feedback
4.0 View applied job
Request for available job
Tbl_apply_jobView job post
Fetch feedbackdata 5.0
statusStore feedback
Tbl_feedback
03/10/13
14
First Level Diagram ( Jobseeker)Request for registration
JOBSEEKERGet registration data Search job
1.0 Registrat ion &loginLogin info
Request for registration
Tbl_js_mstResponse for registration data Search job
2.0 Search jobJob info
Tbl_post_jobResponce search job Request for job
Responce search job
Request
job details
Response manage job details
3.0 Apply job
View job post
Apply Job info Request upload resume
receive upload resume
4.0 upload resumeresume info
Require upload resume
Tbl_apply_jobView upload resume
Give feedback View feedback
Fetch feedback
5.0 Feedback
Tbl_feedback
Response feedback
Data dictionaryTable name Table Description Primary key Foreign Key :- tbl_admin_mst :- To keep detail of Admin : -Username :- --Data Type Nvarchar(10) Nvarchar(10) Varchar(15) Varchar(50) Varchar(20) Numeric(6) Varchar(20) Numeric(12) Nvarchar(30) Constraint Primary key Not Null Not Null Not Null Not Null Not Null Not Null Not Null Not Null Description Store the User Name Store the Password Store the Admin Name Store the Address Store the City Store the Pincode Store the State Store the Mobile No Store the Email Id
Sr. No. Field Name 1 2 3 4 5 6 7 8 903/10/13
Username Password Name Address City Pincode State Mobile_no Emailid
Continue
16
Data dictionaryContinueSr. No. Field Name 10 11 Sequrity_que Ans Data Type Varchar(30) Varchar(50) Constraint Not Null Not Null Description Store the Security Question Store the Answer
03/10/13
03/10/13
17
Data dictionaryTable name :- tbl_emp_mst Description :- To keep detail of Employer Primary key :- emp_username Foreign key :- --Sr. No. Field Name 1 2 3 4 5 6 7 8 9 Data Type Constraint Description Store the Employee id Store the Password Store the Company Name Store the Address Store the City Store the Pincode Store the State Store the Email id Store the Contact Person
Emp_username Nvarchar(15) Primary key Password Com_name Address City Pincode State Email_id Nvarchar(15) Not Null Varchar(20) Varchar(50) Varchar(20) Numeric(6) Varchar(20) Varchar(30) Not Null Not Null Not Null Not Null Not Null Not Null Not Null
Contact Person Varchar(20)03/10/13
Continue
18
Data dictionaryContinueSr. No. Field Name 10 11 12 13 14 Contact_no Description Category Sec_que Answer Data Type Numeric(10) Constraint Not Null Description Store the Contact No Store the Description Store the Category Store the security question Store the Answer
Nvarchar(20) Not Null Varchar(10) Varchar(30) Varchar(50) Not Null Not Null Not Null
03/10/13
19
Data dictionaryTable name :- tbl_js_mst Description :- To keep detail of Job Seeker Primary key :- Js_username Foreign Key :- --Sr. No. Field Name 1 2 3 4 5 6 7 8 9 1003/10/13
Data Type
Constraint
Description Store the Jobseeker id Store the Password Store the Security Question Store the Answer Store the First Name Store the Last Name Store the Gender Store the DOB Store the State20
Email Password Sec_que Answer F_name L_name Gender Dob State
Nvarchar(25) Not Null Nvarchar(10) Not Null Varchar(30) Varchar(50) Not Null Not Null
Js_username Nvarchar(10) Primary Key Store the Jobseeker Username
Nvarchar(15) Not Null Nvarchar(15) Not Null Bit Date/time Varchar(20) Not Null Not Null Not Null
Data dictionaryContinueSr. No. Field Name 11 12 13 14 15 16 17 18 19 20 City Address PhoneNo Pincode Key_skill Experience Salary Resume Abt_pre Job_pre Data Type Varchar(20) Nvarchar(50) Numeric(13) Numeric(6) Varchar(20) Numeric(3) Numeric(8) Nvarchar(40) Nvarchar(500) Varchar(50) Constraint Not Null Not Null Not Null Not Null Not Null Not Null Not Null Not Null Not null Not null Description Store the City Store the Address Store the Phone no Store the Pincode Store the Key Skill Store the Experience Store the Salary Store the Resume Store the info about employee Store the info of job prefrence
03/10/13
21
Data dictionaryTable name Table Description Primary key Foreign Key :- tbl_add_category :- To keep detail of job category : -cat_id :- --Data Type Int Varchar(30) Constraint Primary key Not Null Description Store the Job Category Id Store the Job Category
Sr. No. Field Name 1 2 Cat_id Add_category
03/10/13
22
Data dictionaryTable name :- tbl_add_job Table Description :- To keep detail of Job Primary key : - job_id Foreign Key :- cat_id(Ref:-tbl_add_category) Sr. No. Field Name 1 2 3 4 Job_id Cat_id Job_category Job_name Data Type Int Int Varchar(30) Varchar(30) Constraint Primary key Foreign key Not null Not null Description Store the Job Id Store the Job Category Id Ref:-tbl_add_category Store the Job Category Store the Job Name
03/10/13
23
Data dictionaryTable name Table description Primary Key Foreign key : - tbl_emp_postjob :- To keep detail of posted Job :- emp_username :- Emp_username, cat_id, job_id Data Type Nvarchar(10) Varchar(30) Varchar(30) Varchar(50) Varchar(20) Varchar(20) Numeric(3) Numeric(8) Varchar(50) Constraint Foreign key Not Null Not Null Not Null Not Null Not Null Not Null Null Not Null Description Store the Emp Username Store the Job Category Store the Job Name Store the Company Name Store the State Name Store the City Name Store the Js Experience Store the Salary Store the Js Qualification24
Sr. No. Field Name 1 2 3 4 5 6 7 8 9 Emp_username Job_category Job_name Company_name State City Experience Salary Qualification
03/10/13
Data dictionaryContinueSr. No. Field Name 10 11 12 13 14 15 16 Skills Basic_req Data Type Varchar(50) Varchar(20) Constraint Not Null Not Null Not Null Not Null Not Null Not Null Not Null Description Store the Js Skills Store the requirement of company Store the No Of Jobs Store the Job Post Starting Date Store the Job Post Ending Date Store the Category Id Ref:- tbl_add_category Store the Job Id Ref:- tbl_add_job
No_of_vacancy Numeric(5) Start_date Date/time Last_date Cat_id Job_id Date/time Int Int
03/10/13
25
Data dictionaryTable name : -tbl_apply_jobs Primary key:Foreign key : - js_username(Ref:-tbl_js_mst) Description :- To keep detail of Apply by Jobseeker
Sr. No. Field Name 1 2 3 Js_username Job_category Job_Name
Data Type Nvarchar(10) Nvarchar(30) Varchar(30)
Constraint Not Null Not Null Not Null
Description Store the username (Ref:-tbl_js_mst) Store the job Category Store the Job Name
03/10/13
26
Data dictionaryTable name :- tbl_feedback Description :- To keep detail of Employer & Job Seekers Feedback Primary Key:- feedback_id Foreign key :- Emp_username(Ref:-tbl_emp_mst), Js_username(Ref:-tbl_js_mst) Sr. No. Field Name 1 2 3 4 Emp_username Js_username Feedback Feedback_id Data Type Nvarchar(10) Nvarchar(10) Nvarchar(150) Int Constraint Foreign Key Foreign Key Not Null Primary key Description Store the Emp Username Ref:- tbl_emp_mst Store the Js Username Ref:- tbl_js_mst Store the Feedback Store feednack id
03/10/13
27
E-r DiagramEmail Username Js_username fname
ADMIN1
View1
M
JOBSEEKER1 1
manage
Emp_username
ApplyM M
M
EMPLOYEE1
1
post
JOB
Company nameGive
M
FEEDBACK
M
Give
manage Emp_feedback Emp_username
Process descriptionAdminNotification Admin can send mail to employee and jobseeker. Generate a report Admin can generate a various kind of report like posted job, apply job etc. Upload Job Employee can upload the job in the website.
Company EmployeePost job Employee can Post the job in the website. Search jobseeker This website will provide a facilities in which employee can search the jobseeker.
JobseekerSearch Job This website will provide a facilities in which user can easily search the job according to their location. Apply for job 03/10/13 Jobseeker can apply for multiple job.
29
11.2Process AlgorithmAdminStep 1 Step 2 Step 3 Step 4 :- Start :- Enter username and password. :- Check admin is authorized or not from Admin_table database. :-If authorized than get all its rights. And goto next step, if wrong then goto step 3. Step 5 :- Admin can confirm or deny employee and view employee detail. Step 6 :- Admin can manage jobseeker detail. Step 7 :- Admin can view reports. Step 8 :- Admin view feedback and give reply Step 9 :- If unauthorized than set message Unauthorized user. Step 10 :- logout Step 11 :- Stop
03/10/13
30
EmployeeStep 1 Step 2 Step 3 :- Start :- Enter username and password. :- Check employee is authorized or not from Employee_table database. Step 4 :- If authorized than get all its rights. And goto next step, if wrong then goto step4. Step 5 :- Employee can post a job. Step 6 :- Employee can view jobseeker detail. Step 7 :- Employee can give feedback. Step 8 :- If unauthorized than set message Unauthorized user. Step 9 :- Logout Step 10 :- Stop
03/10/13
31
JobseekerStep 1 Step 2 Step 3 Step 4 Step 5 step4. Step 6 Step 7 Step 8 Step 9 Step 10 Step 11 :::::::::::Start Fill Registration form and upload resume. Enter username and password. Check Jobseeker is authorized or not from Jobseeker_table database. If authorized than get all its rights. And goto next step, if wrong then goto Jobseeker view company detail. Jobseeker view company requirement and give feedback View reply given by admin. If unauthorized than set message Unauthorized user. Logout Stop
03/10/13
32
Input DesignHome Page
Description:-This is a home page that can display various menu.03/10/13 33
Home Page(continue..)
03/10/13
34
Admin Login
Description:- Admin can Login with currect username and password.03/10/13 35
Admin Login
03/10/13
36
Admin Profile
Description:- Admin can give the all the information.03/10/13
37
Admin Profile(Continue)
03/10/13
38
Admin update profile
Description:- Admin can update him profile.03/10/13 39
Admin update profile(continue)
03/10/13
40
Admin update profile view
Description:- Admin can view the update profile03/10/13 41
Job Upload
Description:- Admin can upload the category and job.03/10/13
42
Job Upload(Continue)
03/10/13
43
About Us
Description:- This is page for our company info.03/10/13 44
03/10/13
45
Contact Us
Description:- This page is display the contact details.03/10/13
46
Employee Registration
Description:- Admin can fill the information from employee.03/10/13 47
Continue
03/10/13
48
Employee Profile
Description:- Admin can fill the information from the employee.03/10/13 49
Continue
03/10/13
50
Email sent(employee)
Description:- When admin add employee then email sent to the employee.03/10/13
51
Employee Login
Description:-Here employee can login by input correct username and password.03/10/13 52
Employee Login
Description:-Please insert the valid username and password.03/10/13 53
Employee Login
Description:-Employee can give valid Username and Password.03/10/13 54
Post Job
Description:- Employer can post the job.03/10/13 55
Post Job(Continue..)
03/10/13
56
Jobseeker Signup
Description:-Jobseeker input the validate data from the this site.03/10/13 57
Jobseeker Signup(continue..)
03/10/13
58
Continue
03/10/13
59
Jobseeker signup
Description:-Here jobseeker can create an new account in site.03/10/13 60
Jobseeker signup(continue..)
03/10/13
61
Jobseeker signup(continue..)
03/10/13
62
Email sent(jobseeker)
Description:- When jobseeker is signup then email sent to the jobseeker03/10/13 63
Jobseeker Login
Description:-Here jobseeker can login by input correct username and password.03/10/13 64
Jobseeker Login
Description:-Insert the username and password.03/10/13 65
Jobseeker Login
Description:-Please insert the correct username and password.03/10/13 66
Jobseeker forgot password
Description:-Here jobseeker can change him password03/10/13 67
Continue
Description:-Here jobseeker can give valid answer.03/10/13
68
Continue
Description:-Jobseeker can insert the new password.03/10/13 69
Jobseeker forgot password(continue..)
03/10/13
70
Jobseeker change password
Description:- Jobseeker can change password03/10/13 71
Search Job
Description:-Here jobseeker can search job with select job category and job name03/10/13 72
Apply Job
Description:- Jobseeker can apply the job03/10/13 73
Feedback
Description:-Here jobseeker can give feedback to the site.03/10/13 74
Output DesignJob Upload
Description:-This page contain the information regarding job upload.03/10/13 75
Apply Job
Description:-This page contain the information regarding apply job.03/10/13 76
Feedback
Description:-This page contain the information regarding user feedback.03/10/13 77
Post Job
Description:-This page contain the information regarding post job.03/10/13
78
Jobseeker Information
Description:-This page contain the information regarding jobseeker information03/10/13 79
Company Employee Information
Description:-This page contain the information regarding employee information.03/10/13 80
TestingAdmin
Module Name : AdminDescription Status Tester Test Will perform to check whether the system work perfectly or not? Completed Patel Pranay A. Patel Nirmit K. Barot Naitik M. SCENAR SCENARIO IO ID 1.1 TEST CASES EXPECTED BEHAVIOR It should not let enter in admin module ACTUAL BEHAVIOR It will show message that enter Username or/and Password STATUS (PASS/FAIL) Pass
Valid input of Enter null in data for enter in Username or/and Admin login Password Enter wrong data of Username or/and Password
It should not let It will show message enter in admin that enter correct module Username or/and Password It will show admin home page.
Pass
Enter correct data It should let of Username enter in admin or/and Password module.03/10/13
Pass81
ContinueSCENARIO ID SCENARIO TEST CASES EXPECTED BEHAVIOR Input the Enter null in correct data to fields add Category id, Category Name, Job id,Job Name Enter correct data of all required field ACTUAL BEHAVIOR STATUS (PASS/FAIL)
1.2
It will not add the It will show message Pass Category id, that enter the data. Category Name, Job id,Job Name.
It should let add It will show the Pass Category id, message successfully Category Name, data added Job id,Job Name.
03/10/13
82
Company EmployeeModule Name : Company Employee Description Status Tester Test Will perform to check whether the system work perfectly or not? Completed Patel Pranay A. Patel Nirmit K. Barot Naitik M. SCENAR SCENARIO TEST CASES IO ID 1.1 Valid input data Enter null in for enter in Username or/and Company Password Employee login Enter wrong data of Username or/and Password EXPECTED BEHAVIOR It should not let enter in company employee module It should not let enter in company employee module ACTUAL STATUS BEHAVIOR (PASS/FAIL) It will show Pass message that enter Username or/and Password It will show Pass message that enter correct Username or/and Password
Enter correct data It should let enter in It will show Pass of Username company employee company employee or/and Password module. home page.03/10/13 83
ContinueSCENARIO ID SCENARIO TEST CASES EXPECTED BEHAVIOR ACTUAL BEHAVIOR STATUS (PASS/FAIL)
1.2
Input the Enter null in correct data to fields add Job Post,Give Feedback information Enter correct data of all required field
It will not add the It will show message Pass job post id,give that enter the data. feedback.
It should let add It will show the Pass job post message successfully id,feedback id. data added
03/10/13
84
JobSeekerModule Name : JobSeeker Description Status Tester Test Will perform to check whether the system work perfectly or not? Completed Patel Pranay A. Patel Nirmit K. Barot Naitik M. SCENAR SCENARIO TEST CASES IO ID 1.1 Valid input data Enter null in for enter in Username or/and JobSeeker login Password Enter wrong data of Username or/and Password EXPECTED BEHAVIOR It should not let enter in jobseeker module It should not let enter in jobseeker module ACTUAL STATUS BEHAVIOR (PASS/FAIL) It will show Pass message that enter Username or/and Password It will show Pass message that enter correct Username or/and Password Pass
Enter correct data It should let enter in It will show of Username jobseeker module. jobseeker home or/and Password page.03/10/13
85
ContinueSCENARIO ID SCENARIO TEST CASES EXPECTED BEHAVIOR ACTUAL BEHAVIOR STATUS (PASS/FAIL)
1.2
Input the Enter null in correct data to fields add Search Job,Apply Job,Give Feedback Enter correct data of all required field
It will not add the It will show message Pass Search job,Apply that enter the data. Job,Give Feedback
It should let add search job,apply job,Give Feedback.
It will show the Pass message successfully data added
03/10/13
86
Post Implementation Review
Post implementation review is conducted by Users and Analyst.
To
determine whether the system has met its objective, that is analysts, want to know if the performance level of Users has improved. If nothing is happening, one may question whether the system can be considered successful.
To evaluate the system, following questions are considered: How have the system changed the way in which operations are performed? How have system changed the completeness of the information? How have system changed the number of user? How have system changed the interaction between users?
03/10/13
87
Future Enhancement
Add an Employer user in the website. Send an Email verification to the users. Message send the jobseeker and company employee account.
03/10/13
88
Bibliography
Books:ASP.NET 3.5 in C# 2008 Matthew MacDonald and MarioSzpuszta Second Edition Apress Publication
Beginning.C.Sharp.2008.Databases.From Vidya Vral Agarwal and James Huddleston Ranga Raghuram, Syed Fahad Gilani, Jacob Hammer Pedersen, and Jon Reid Apress Publication
Websites: http://www.shine.com http://www.naukri.com http://www.monster.com
03/10/13
89
Thank You
03/10/13
90