job centre presentation
TRANSCRIPT
![Page 1: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/1.jpg)
Patel Munvarhusen Patel Ankit
1
![Page 2: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/2.jpg)
Job CentreJob Centre
2
Project Profile
Scopes and Limitations
Screen Layouts
DFD
Project Definition
Tools Used
Use Case Activity Diagram
Data Dictionary
Future Enhancement
![Page 3: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/3.jpg)
3
![Page 4: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/4.jpg)
4
The system admin will have the ability to clean and clear and maintain database.
Administrator:1) Verify users account give them right to access the right.2) Block a users.3) Create Categories on job.4) Create Subcategories on the type of job.
Employers:1) Create vacancies for jobseekers2) Search candidates based on their profiles3) Can schedule an interview with technical professionals4) Can select interviewers 5) Can send email to selected candidates Jobseekers:1) Create an account with a complete profile2) Search for jobs with different categories3) Edit/update their profile4) Apply online for jobs5) Job seekers can view interview locations.
![Page 5: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/5.jpg)
5
Project Title : JobCentre (Job Portal)
Project Duration : Academic duration of MCA Semester – VI
Project Members : Patel Munvarhusen Patel Ankit
External Project Guide : Mr. Kailesh Solanki
Internal Project Guide : Mrs. Purvi Tailor
![Page 6: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/6.jpg)
6
Operating System : Microsoft Windows 7
Application Builder : Microsoft Visual Studio.NET 2010
Front End : ASP.NET, C#
Back End : SQL Server 2008
Documentation Tool : MS Word, MS Visio, E Draw
Presentation Tool : MS PowerPoint
![Page 7: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/7.jpg)
7
![Page 8: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/8.jpg)
8
![Page 9: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/9.jpg)
9
E/R Diagram
Context Diagram
Level Zero Diagram
Child diagram
![Page 10: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/10.jpg)
10
![Page 11: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/11.jpg)
11
Context Diagram
![Page 12: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/12.jpg)
12
Level Zero Diagram
![Page 13: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/13.jpg)
13
![Page 14: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/14.jpg)
14
![Page 15: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/15.jpg)
15
![Page 16: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/16.jpg)
16
Child Diagram ( 1.0 Manage Jobs)
![Page 17: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/17.jpg)
17
Child Diagram (2.0 Manage Profile)
![Page 18: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/18.jpg)
18
Child Diagram (3.0 Search JobSeeker)
![Page 19: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/19.jpg)
19
Child Diagram (5.0 Maintain Profile)
![Page 20: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/20.jpg)
20
Child Diagram (7.0 Manage Employers)
![Page 21: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/21.jpg)
21
Child Diagram (8.0 Manage Jobs)
![Page 22: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/22.jpg)
22
Child Diagram (9.0 Maintain System)
![Page 23: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/23.jpg)
23
Child Diagram (10.0 Manage Users)
![Page 24: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/24.jpg)
24
Administrator
Employer
Jobseeker
![Page 25: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/25.jpg)
25
Administrator (Use Case)
![Page 26: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/26.jpg)
26
Employer (Use Case)
![Page 27: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/27.jpg)
27
Jobseeker (Use Case)
![Page 28: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/28.jpg)
28
Administrator
JobseekerEmployer
![Page 29: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/29.jpg)
29
Admin (Login)
![Page 30: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/30.jpg)
30
Admin (Home Page)
![Page 31: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/31.jpg)
31
Admin (City)
![Page 32: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/32.jpg)
32
Admin (Add New City)
![Page 33: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/33.jpg)
33
Admin (Search City)
![Page 34: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/34.jpg)
34
Admin (Edit City)
![Page 35: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/35.jpg)
35
Admin (My Account)
![Page 36: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/36.jpg)
36
Admin (Change Password)
![Page 37: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/37.jpg)
37
Admin (Block Employers)
![Page 38: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/38.jpg)
38
Admin (Block Jobs)
![Page 39: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/39.jpg)
39
Admin (Deactivation)
![Page 40: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/40.jpg)
40
Admin (Report – List of Jobseekers)
![Page 41: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/41.jpg)
41
Admin (Report – List of Employers)
![Page 42: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/42.jpg)
42
Admin (Report – List of Jobs)
![Page 43: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/43.jpg)
43
Admin (Report – List Of applied Jobs)
![Page 44: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/44.jpg)
44
Admin (Report – Block List)
![Page 45: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/45.jpg)
45
Employer (Login)
![Page 46: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/46.jpg)
46
Employer (My Account)
![Page 47: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/47.jpg)
47
Employer (Edit Profile)
![Page 48: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/48.jpg)
48
Employer (Post Job)
![Page 49: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/49.jpg)
49
Employer (Manage Posted Jobs)
![Page 50: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/50.jpg)
50
Employer (Saved Profile)
![Page 51: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/51.jpg)
51
Employer (Deactivation)
![Page 52: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/52.jpg)
52
Jobseeker (Login)
![Page 53: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/53.jpg)
53
Jobseeker (Home)
![Page 54: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/54.jpg)
54
Jobseeker (My Profile)
![Page 55: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/55.jpg)
55
Jobseeker (Block Employers)
![Page 56: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/56.jpg)
56
Jobseeker (My Jobs - Matching)
![Page 57: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/57.jpg)
57
Jobseeker (My Jobs - Applied)
![Page 58: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/58.jpg)
58
Jobseeker (Search)
![Page 59: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/59.jpg)
59
Jobseeker (View - Search)
![Page 60: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/60.jpg)
60
Employer (Search)
![Page 61: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/61.jpg)
61
Employer (View jobseeker- Search)
![Page 62: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/62.jpg)
62
Employer (View jobseeker - contact)
![Page 63: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/63.jpg)
63
Employer (View jobseeker – contact (EMAIL))
![Page 64: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/64.jpg)
64
Employer (View jobseeker – contact(SMS))
![Page 65: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/65.jpg)
65
Table Name: tbl_loginDetail
Field Name Data Type Description Null Constratint
loginId int Id of User Login Primary Key
emaiId varchar(25) EmailId of User
password varchar(25) Password of User
questionOne int 1st Question for Forgot Password
questionTwo int 2nd Question for Forgot Password
answerOne varchar(25) 1st Answer for Remember Password
answerTwo varchar(25) 2nd Answer for Remember Password
userType varchar(25) Types of User
status varchar(10) Active/No Active
lastLoginDate Date Date of User last login
![Page 66: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/66.jpg)
66
Table Name: tbl_accounts
Field Name Data Type Description Null Constratint
userId Int Id of User Primary Key
username varchar(25) Name of User
Password varchar(25) Password of User
lastLoginDate Date Date of User last login
![Page 67: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/67.jpg)
67
Table Name: tbl_questions
Field Name Data Type Description Null Constratint
questioned Int Id of Question Primary Key
questionName varchar(25) Name of Question
![Page 68: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/68.jpg)
68
Table Name: tbl_country
Field Name Data Type Description Null Constratint
countryId Int Id of Country Primary Key
countryName varchar(20) Name of Country
![Page 69: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/69.jpg)
69
Table Name: tbl_state
Field Name Data Type Description Null Constratint
stateId Int Id of State Primary Key
countryId Int Id of Country Foreign Key
stateName varchar(20) Name of State
![Page 70: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/70.jpg)
70
Table Name: tbl_city
Field Name Data Type Description Null Constratint
cityId Int Id of City Primary Key
stateId Int Id of State Foreign Key
cityName varchar(20) Name of City
![Page 71: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/71.jpg)
71
Table Name: tbl_degree
Field Name Data Type Description Null Constratint
degreeId Int Id of Degree Primary Key
degreeName varchar(25) Name of Degree
degreeType varchar(10) Type of Degree
![Page 72: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/72.jpg)
72
Table Name: tbl_industry
Field Name Data Type Description Null Constratint
industryId Int Id of Industry Primary Key
industryName varchar(25) Name of Industry
![Page 73: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/73.jpg)
73
Table Name: tbl_functionalArea
Field Name Data Type Description Null Constratint
areaId Int Id of Functional Area Primary Key
areaName varchar(25) Name of Functional Area
![Page 74: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/74.jpg)
74
Table Name: tbl_jobseekerPersonal
Field Name Data Type Description Null Constratint
jobseekerId Int Id of Jobseeker Primary Key
jsLoginId Int Id of Jobseeker Login Foreign Key
jsFullName varchar(25) Name of Jobseeker
jsAddress varchar(50) Address of Jobseeker
jsGender varchar(10) Male/Female
jsCountryId Int Id of Country Foreign Key
jsStateId Int Id of State Foreign Key
jsCityId Int Id of City Foreign Key
jsMobileNumber varchar(20) Mobile Number of Jobseeker
jsPhoneNumber varchar(20) Phone Number of Jobseeker
jsEmailAlert varchar(25) Active/Block
jsDOR Date Date of Jobseeker Registration
jsStatus varchar(10) Active/Block
jsDOM Date Date of Modification
![Page 75: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/75.jpg)
75
Table Name: tbl_jobseekerProfessional
Field Name Data Type Description Null Constratint
professionalId Int Id of Professional Jobseeker Primary Key
jobseekerId Int Id of Jobseeker Foreign Key
areaId Int Id of Functional Area Foreign Key
industryId Int Id of Industry Foreign Key
Keyskills Varchar(50) Keyskills of Jobseeker
ExpYear Int Exp. of Jobseeker in Year
ExpMonth Int Exp. of Jobseeker in Month
SalaryLacs Int Salary in Lacs
SalaryThousand Int Salary in Thousand
showSalary varchar(10) Active/Block Sal to Employer
resumeHeadline varchar(20) Headline of Resume
preferedJobLocation varchar(20) Jobseeker’s Preferred Job Loc
resumePath varchar(50) Path of Jobseeker Resume
resumePostDate Date Post Date of Resume
![Page 76: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/76.jpg)
76
Table Name: tbl_jobseekerQualification
Field Name Data Type Description Null Constratint
QualId Int Id of Jobseeker Qualification Primary Key
jobseekerId Int Id of Jobseeker Foreign Key
basicQualification Int Basic Qualification of Jobseeker
pgQualification Int Post Graduate Qualification of JS
drQualification Int Doctrate Qualification of Jobseeker
courseOne varchar(20) 1st Course
courseTwo varchar(20) 2nd Course
courseThree varchar(20) 3rd Course
![Page 77: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/77.jpg)
77
Table Name: tbl_jobseekerEmployment
Field Name Data Type Description Null Constratint
empId Int Id of Jobseeker Employment Primary Key
jobseekerId Int Id of Jobseeker Foreign Key
companyName varchar(25) Name of Company
designation varchar(20) Designation of JS in Company
yearDuration Int Year of Jobseeker in Company
monthDuration Int Month of Jobseeker in Company
industryId Int Id of Industry Foreign Key
areaId Int Id of Functional Area Foreign Key
![Page 78: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/78.jpg)
78
Table Name: tbl_appliedJob
Field Name Data Type Description Null Constratint
applyId Int Id of Jobseeker Applied Job Primary Key
jobseekerId Int Id of Jobseeker Foreign Key
jobCode Int Code of Jobseeker’s Job Foreign Key
applyDate Date Date of Apply Job
![Page 79: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/79.jpg)
79
Table Name: tbl_employerDetail
Field Name Data Type Description Null Constratint
employerId Int Id of Employer Primary Key
empLoginId Int Id of Employer Login Foreign Key
empCompanyName varchar(25) Name of Employer Company
empCompanyAddress Varchar(70) Address of Employer Comp.
empCountryId Int Id of Country Foreign Key
empStateId Int Id of State Foreign Key
empCityId Int Id of City Foreign Key
empAreaID Int Id of Functional Area Foreign Key
empIndustryId Int Id of Industry Foreign Key
empContactPerson varchar(25) Contact of Employer
empDesignation varchar(20) Designation of Employer
empPhoneNumber varchar(15) Phone Number of Employer
empMobileNumber varchar(15) Mobile Number of Employer
empLogoPath varchar(50) Logo Path of Employer
empStatus varchar(10) Active/Block
empDOR Date Date of Employer Registrati.
![Page 80: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/80.jpg)
80
Table Name: tbl_JsBlockEmp
Field Name Data Type Description Null Constratint
blockId Int Id of Block User Primary Key
jobseekerId Int Id of Jobseeker Foreign Key
employerId Int Id of Employer Foreign Key
blockDate Date Date of JS Block Employer
![Page 81: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/81.jpg)
81
Table Name: tbl_empViewJs
Field Name Data Type Description Null Constratint
viewId Int Id of Employer View Jobseeker Primary Key
employerId Int Id of Jobseeker Foreign Key
jobseekerId Int Id of Employer Foreign Key
viewDate Date Date of View
![Page 82: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/82.jpg)
82
Table Name: tbl_Jobs
Field Name Data Type Description Null Constratint
jobCode Int Code of Job Primary Key
empId Int Id of Employer Foreign Key
countryId Int Id of Country Foreign Key
Stated Int Id of State Foreign Key
cityId Int Id of City Foreign Key
areaId Int Id of Functional Area Foreign Key
industryId Int Id of Industry Foreign Key
keyskills Varchar(50) Keyskills
Keywords Varchar(50) Keywords
jobTitle Varchar(25) Title of Job
jobDescription varchar(70) Description of Job
Postdate Date Date of Post Job
expiryDate Date Date for Expiry Job
Continue….....
![Page 83: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/83.jpg)
83
canProfileDescription varchar(70) Desc of candidate profile
workMinYear Int Minimum Work Year
workMaxYear Int Maximum Work Year
basicQualification Int Basic Qualification
pgQualification Int Post Graduate Qualification
drQualification Int Doctorate Qualification
companyName varchar(25) Name of Company
companyProfile varchar(70) Profile of Company
companyWebsite Varchar(25) Website of Company
showEmail Varchar(10) Active/Block
requireEmployee Int
minSalary Float Minimum Salary
maxSalary Float Maximum Salary
jobStatus Varchar(10) Active/Block/Expired
….. continue
![Page 84: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/84.jpg)
84
Table Name: tbl_empSaveJs
Field Name Data Type Description Null Constratint
saveId Int Id of saved profile Primary Key
employerId Int Id of Employer Foreign Key
jobseekerId Int Id of Jobseeker Foreign Key
saveDate Date Date of save JS Resume
![Page 85: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/85.jpg)
85
Table Name: : tbl_deactivatedUsers
Field Name Data Type Description Null Constratint
deactivateId Int Id of Deactivated User Primary Key
emailed varchar(25) Id of Email
userType varchar(10) Type of User
reason varchar(50) Reason for Deactivate
date Date Date of Deactivation
![Page 86: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/86.jpg)
86
Administrator
Employer
Jobseeker
![Page 87: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/87.jpg)
87
Administrator (Activity Diagram)
![Page 88: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/88.jpg)
88
Employer (Activity Diagram)
![Page 89: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/89.jpg)
89
Jobseeker (Activity Diagram)
![Page 90: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/90.jpg)
90
Reports will provide to employers.
Implement the use of PayPal with the system to manage transaction.
Administrator create different subadmin account and assign them work.
Admin and subadmin can confirm sending of email to the jobseeker.
Email and sms alert also send to the employer for give alert about
expiry date of posted jobs.
Send Email in HTML format to jobseeker for simplicity.
Email about job alert send to the jobseeker in regular time period or at
time where there is new job is posted. SMS about this also send to the
user.
![Page 91: Job centre presentation](https://reader035.vdocuments.us/reader035/viewer/2022062412/58eeee6a1a28ab77528b4643/html5/thumbnails/91.jpg)
91