E-JOB ( Electronic-Job )
2007
Chapter 1
INTRODUCTION 1.1
Introduction to the Project The main objective of the project is to application for the job consultant to
provide jobs for jobseekers and job posting for job posters. This project is designed to provide an online job facilities, it is a global service job provide, which helps the valid users / clients who browse this website and apply for the job. This website is also helpful for those who are running organization / company to fulfill their requirement. The system is designed to allow only authorized jobseekers of online job consultant site to view jobs, to apply the job s and allow authorized job posters to post the job. So the authorized jobseeker and job poster of Online Job Consultant Site can enter into the system and others cannot get the service in this system. The administration person will provide the service for the authorized jobseeker and jobposters, depending on their category type their servicing facilities is provided. When the jobseekers apply for the job, then the administration person will compare the jobseekers details with the job requirement. If the jobseekers details are valid then only the jobseekers details will be provided for the jobposter. When the jobposters post the job, the administration person will check the details and the requirements of the jobposters and the job requirement details are provided for the view for the jobseekers.
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
1.2
2007
Benefits of Online Job Consultant Site Benefits of the company Customer service Shorten time and save money to jobseekers and jobposters Provide a user-friendly interface Avoid data inconsistency and maintain integrity
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
Chapter 2
LITERATURE SURVEY 2.1
Why ASP (Active Server Page) Active server page (ASP) is a server-side scripting technology that can be
used to create dynamic and interactive web applications. An ASP page is an HTML, page that contains server-side scripts, reusable Active X server components that are processed by the web server before being sent to the user’s browser. One can combine ASP with Extensible Markup Language (XML), Component Object. Active server pages are Microsoft’s solution to building advanced web sites, Many of the largest, most technologically demanding and most successful commercial web site running on the internet today are built using active server pages. They help to: •
Generate dynamic web pages. An active server page can display different content to different users or display different content at different time of the day.
•
Process the contents of HTML forms. Active server page to retrieve and respond to the data entered into an HTML form.
•
Create database-driven web pages. An ASP can insert new data or retrieve existing data form a database such as Microsoft SQL Server.
•
Track user sessions. Active Server pages can be used to store information about users from the moment they arrive to the web site until the moment they leave.
•
Customs components into the web site. Active server page scripts can be extended with custom server-side Microsoft Visual or Microsoft visual C++
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2.2
2007
Why Java Script is Us Java script is used for client side validation. Client side validation controls
perform input checking in serve code. When the user submits a form to the server, the validation controls are invoked to review the users input, control bye control. If an error has occurred in any of the input controls, the page itself is set to an invalid state so one can test for validity before code runs.
2.3
HTML (Hyper Text Markup Language) HTML is a language that puts the face on the web by helping to prepare
documents for online publication. These documents are also called as web documents and each HTML document is known as web pages. HTML is a standard language the all Web browser can understand and interpret. HTML is the way of representing text linking that text to other kinds of resources including sound files graphics files, multimedia files etc. that allows these kinds of data to be displayed together, to set them and reinforce one another. As delivered by the web server, HTML is nothing more than a plain text file. HTML instructions divide the text of a document into blocks called elements. It is used in this application for the following reasons: •
HTML provides the best way to deliver information on the web and also to gather data and deliver them back to the server.
•
HTML is easy to write.
•
HTML has a much smaller footprint, that is, download size of the application.
•
Almost every browser support HTML forms.
2.5
Why Oracle. A client application communication with oracle database engine must do so
using a programming interface. The client application calls functions from one of oracle interface.
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
This application development system from an extra layer that sits between the application development ad oracle interfaces. The client application together with the interface layer forms the client side of the setup.
Oracle database engine The database engine and the database together form the server side of the setup. A client application manipulates database by sending request to the database engine. Communication between a client application and a database engine take the form of Structured Query Language (SQL). The client application sends the SQL statements, the database engine process them and sends the result back to the client application. The database oracle is an object oriented relational database management system (RDBMS). The database itself is stored on one or more disk drives, and consists of the following objects. •
Tables, which hold the information in the database.
•
Key, which relate the information in one table to that in order.
•
Indexes, which allow quick access to information in the database.
•
Views, which are computed tables.
•
Stored procedures, which holds queries and commands that, may be executed by any client application.
•
The system table, which hold the information about the structure of the database.
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
Chapter – 3
SYSTEM ANALYSIS 3.1
Study of Existing System Presently job Consultant system is a manual system. All the information and activities relies on paper work or in a broken, distribute and isolated automation to maintain user details lot of time is spent.
3.2
Limitation of Existing System. Normally the manual system has several drawbacks. They are as follows:
•
Since the job consultant process is carried out manually, the system requires huge time.
•
In the system jobseekers and jobposters details are maintained in hard copies.
•
The system leads to huge amount of paper work.
•
The system process is slow, that is giving advertisement in newspapers, collecting the jobseekers details and jobposters details by hand or through post.
3.2
Limitation of Existing System. Normally the manual system has several drawbacks. They are as follows:
•
Since the job consultant process is carried out manually, the system requires huge time. In the system jobseekers and jobposters details are maintained in hard copies.
•
The system leads to huge amount of paper work.
•
The system process is slow, that is giving advertisement in newspapers, collecting the jobseekers details and jobposters details by hand or through post.
•
The system is slow because lot of time is spent is collecting, maintaining the user details.
•
MCTA
Tracking of any open issues is done manually and mistake prone.
B.SC(IT)
E-JOB ( Electronic-Job ) •
2007
The records are to be manually searched or complied to get any details, which is time consuming.
3.3
Problem Definition With respect to the standards followed in the analysis phase for the identification of the modules and sub modules with various functionalities are listed below. •
Registration details o Jobseekers details o Jobposters details
Resume details
Job posting details
Job applying details
Job searching details o With respect to date o With respect to company name o With respect to functional area o With respect to industry type o With respect to company website o With respect to state o With respect to city
Feedback details o Suggestions and expectations from jobseekers o Suggestions and expectations from jobposters
•
Company details o With respect to the company name.
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
3.4 Proposed system The proposed system Online Job Consultant site is implemented over ASP and Oracle8i. And this will include all the features carried out by manual system and also add certain features so that the package will form a definite improvement. It is proposed to make the system extremely user-friendly with well-designed screens and limited inputs. 3.4.1 Feature of the Proposed System •
Benefit to the Company: The Company can get regular report based on different criteria, also the overhead of maintaining hard copies can be avoided.
•
Customer Service: The web site never sleeps, so customer can transact with Online Job Consultant Site for 24 hours of the day.
•
Shorten time and save money to seekers and posters: The proposed system dramatically shortens time and save the cost for searching and posting the job.
•
Provide a user-friendly interface: This system is completely user friendly by enabling user-friendly environment.
•
Avoid data inconsistency and maintain integrity: The system ensures data integrity and avoids inconsistency along with the database and they’re by providing in built validation before posting data into the database.
•
Security feature: As the database lies only with administrator, only the administrator will be able to access or modify the database. Users can access that information which the administrator provides, but can’t modify it.
3.5
Feasibility study Feasibility study is a test of a proposal according to its workability, impact on
the organization, ability to meet user needs and effective use of resources. The objective of feasibility study is not to solve the problem but to acquire a sense of its scope.
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
The existing system is a manual system that requires a lot of paper work. And it consumes more time to process jobs available. Computer handles the proposed system so it gives accurate result and meets the results within a shorter time. 3.5.1
Operational Feasibility There is no difficulty in implementing the Online Job Consultant system, if the
user has the knowledge of usage and working of the system. As user manual will be designed about the system, it is assumed that user will not face any problem in running the system. The system does not affect the response rate of the computer. Needed assistance has been given to the user wherever needed, along with user manual, training and help menus. Thus the system is found to be operational. 3.5.2
Technical Feasibility It is essential that the process of analysis and the definition to be conducted is
parallel to an assessment of technical feasibility. The consideration that is normally associated with the technical feasibility includes the resource availability of the organization where the product is developed and implemented. This project is done using available software and it requires windows 2000 operation system, with external devices, which are very commonly used. 3.5.3
Economical Feasibility. The existing resources available in the company are sufficient for
implementing the proposed Online Job Consultant Site system and hence no extra cost has to be incurred to run the system. Thus, the system is economically feasible. 3.5.4
Time Feasibility Time Feasibility is determination of whether a proposed project can
implemented fully within a stipulated time frame. The time frame allotted for our project is four months, which was found acceptable.
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
Chapter 4
HARDWARE REQUIREMNTS
Client Side: Intel Pentium III processor 32 MB of RAM 40Mb Hard disk 10/100Mb NIC card Color Monitor Internet connectivity
Server side: High Performance Computer is serving including network administration. 256 MB SD Ram Inter Pentium III / IV processor Minimum storage capacity of 600 MB Hard disk. 10/100Mb NIC card Color Monitor Internet connectivity
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
Chapter 5
SOFTWARE REQUIREMNT SPECIFICATION 5.1
Introduction Software Requirement Specification is the starting point of the software
development activity. Software Requirement Specification describes completely the external behavior of the system, functions to be carried out, performance levels to be obtained and corresponding interface to be established. The purpose of software requirement specification is to bridge the communication gap between the client, the user and the developer. The online Job Consultant Site is used to search the jobs for the authorized jobseekers and is used to post the job from the authorized jobposters. 5.1.1 Purpose The purpose of this project is to replace inefficient manual job consultant system by online job consultant system by online job consultant system. It promotes interaction between the jobseekers and job posters where jobs can be searched and published through Online Job Consultant system. It enables frictionless interaction between jobseekers and jobposters. 5.1.2 Scope Creating a web-based job consultant system save time to both the jobseekers and jobposters. This system give 100% accurate result compared to manual system and here there is no chance of cheating from jobseekers and job posters. 5.1.3 Definition And Abbreviations Administrator: He is one who has central control over the system. Jobseekers
: The person who is search for new job.
Jobposter
: The company / organization.
MCTA
B.SC(IT)
E-JOB ( Electronic-Job ) ASP
-
Active Server Pages.
HTML -
Hyper Text Markup Language
XML -
Extensible Markup Language
IIS
-
Internet Information Server
IT
-
Information Technology
FTP
-
File Transfer Protocol
WWW -
Word Wide Web
VB
-
Visual Basic
SQL
-
Structure Query Language
ADO -
Active X Data Object
ODBC -
Open Database Connectivity
API
Application Programming Interface
-
ISAPI -
Internet Server Application Programming Interface
DFD -
Data flow Diagram
RDBMS -
Relational Data Base Management System
5.2
2007
General Description
5.2.1 Product perspective This software will be based on web based application. It would be a very userfriendly application and will guide the user throughout the application. 5.2.2. Product function The system is designed to allow authorized jobseekers of Online Job Consultant Site to view the jobs, to apply the jobs and allow authorized job posters to post the job. 5.2.3 User Characteristics The only authorized users of Online Job Consultant Site can enter into the system. Others cannot enter into this system.
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
5.3
2007
Functional Requirements
5.3.1 Inputs Depending upon the action being preferred by the users, the input is accepted with the help of the button selected. The inputs at the project level are collected based on the requirement viz. Login id and password Registration details of jobseeker and jobposter. Resume details of jobseeker. Job Posting details. Job searching and job applying details. 5.3.2 Processing Firstly, system checks for authentication of users. If the users are authorized to online job consultant site then the user is allowed to enter into the system otherwise it will show the error message. Valid jobseeker can search the jobs, which has been published in the Jobsite. If the jobseeker wants to apply for the job then the jobseeker can apply depending on his choice. Valid jobposter can post the jobs with their requirement. 5.3.3 Output The output of Online Job Consultant system is job posting to jobseekers.
5.4
Non – Functional Requirements
5.4.1 User Interface The system will provide an interface via the Internet that is easy to use. Little training is required to use this system. 5.4.2 Software and Hardware Consideration This online job consultant site system will be compatible with all types of PC and 100% compatible with computer system using Windows 2000 operating system. The computer system should be connected to the Internet, as well as each computer system should have Microsoft Internet Explorer 5.0 or above
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
5.4.3 Performance Characteristics All information regarding the performance Reporting / Analysis must be accessed and shown on the screen within 2 or 3 seconds after entering the required data. In general, barring any irregular occurrence, a user should be able to complete all transaction within 3 or 4 minutes. The total number of user who can use the system simultaneously is depending on the capacity on the Internet 5.4.5 Quality Issues The system should be e3xtremely reliable. All nor mal process should be 100% bug free. 5.4.6 System Modification Eventually the system may be evolved to allow user to store critical parameter range and values, to access the performance and analysis information, to generate the analysis report. The concerned authority of the Online Job Consultant Job Consultant Site will perform any and all changes to the system. 5.4.7 Documentation All documentation for the system should acceptable via the internet. The system is providing contact sensitive help as well. No technical documentation will provide. Since a maintenance required shall be perform only by the concerned authority person of Online Job Consultant site system.
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
5.5
2007
Design Constraints
5.5.1 Hardware Constraints Client Side Internet Connection. Server Side High performance computer configured as SERVER with all the software installed that are mentioned in hardware a software requirement. 5.5.2 Software Constraints. Client Side Microsoft Internet Explorer 5.0 or above Server Side Internet Information Server 5.0 Windows 2000 Oracle 8i Microsoft Internet Explorer 5.0 or above.
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
Chapter 6
SYSTEM DESIGN 6.1
Introduction An appropriate system design is that, which accurately translates a customer
requirement into finished software products or system. This phase commences once the logical model of the existing system is available. Design begins by using identified system problem as a basis for development of objectives for the new system. Design Techniques. •
DATA FLOWR DIAGRAM (PROCESS MODELING)
•
ENTITY RELATIONSHIP DIAGRAM (DATA MODELS)
6.2
Data Flow Diagram
DFD FOR ONLINE JOB CONSULTANT SITE Context Level DFD
Job Seekers Job Posters
Login I D Password Search job Post job
Monitoring Online Job Consultant Site
Administrator
Figure 6.1 Context level DFD of Online Job Consultant Site
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
LEVEL – 1 DFT
Change Registratio n Posters reply Job apply Update Seeker Registrationtist ration
New Job Seeker
Posters Reply
Login Id
Changing Resume
Registratio n Password
Job Seekers
Login id Password (Existing Jobseekers)
Login
Change Resum e
Login validatio n
Resume Fill resume
Job Changing PasswordSearching Resum e Job Search
Change Passwor d
A
Figure 6.2 Level 1 DFD of Online Job Consultant Site
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
By industry type
By functional area
Job Searching A
Job Seekers
Job apply
Job Searc h
Job Publish
Job Apply
Job poster registration
Job Searching
By Date
Advance search
Figure 6.3 Level 1 DFD of Online Job Consultant Site
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
Change Registratio n Job Posting Job Posting
Poster Registration
New Job Seeker Job Posters
Job posting details
Job Applier
Update
Login Id Registratio n Password
Login id Password (Existing Jobseekers)
Login validatio n
Apply Job Fill resume
Changing Password
Change Passwor d
Checking
Login
Figure 6.4 Level 1 DFD of Online Job Consultant Site
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
Job Poster Registration
Job Posting
Job apply
New Job Applier
Remove Job poster
Apply
Add
Remove
New jobs Remove
Administrator
Add
Remove Jobseekers
Login validation
Check
New Job posters
Add
New jobseeker s
Login
Job seeker registration
Figure 6.5 Level 1 DFD of Online Job Consultant Site MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
6.3
2007
Entity Relationship Diagram
ER Diagram for Online Job Consultant Site
Mail_id
Res_no
Off_No Mob_N
Pin_co Total_ex
State
Curr-
City DOB
UG_course
Sex
PG_course
Name
PPG_cours Jobseeker Registration
Pwd-answer
Reg_data
PwdLast_date
User_I
A
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
B
Comp_id
Last_dat Reg_da
Comp_na Jobseeker Registration
Website
Mail_id Per_des
Street City
Con_per
State
Turn_are Pin_cod
Fun_are Phone_no
MCTA
Fax_no
Ind_typ
B.SC(IT)
E-JOB ( Electronic-Job )
2007
Login_categor
Login_passwor
Status
Login_Id Job Post
A
LOGI N
Login
2
3 2 Job Post
Fills Resume
4
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
2
Job Apply
Ques_no
Count
Status
Reply
User_id
Comp_name Question Applied_date
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
3
Job Posting
Comp_Id
Status
HR_name
Last_date Posted_dat
Mail_id
Eligibility
Cont_no Requirement
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
4
User_id
To Write To_rea
User_nam Resume
To_speak
Pint code
Ppg_psn
Se_marks Se_mark
Ppg_mar
Se_psn
Pg_psnt
Pe_mark
Pg_mar Pe_psnt
MCTA
Ug_mark
Ug_psn
B.SC(IT)
E-JOB ( Electronic-Job )
2007
Chapter 7
DETAILED DESIGN 7.1
Purpose The document provides the detailed design specification for the requirement
specified in the system requirement specification. This also explains the functional specification of each individual sub-module involved. This document is intended to be a baseline for software development and testing 7.2
Flow chart
Login After registration the jobseekers of jobposters can login to get the service from this site. Start
Error Message No
Jobseekers Service page
Check Valid user
1
Check Valid user
Database Yes
2
Jobposters Service page
Stop Figure 7.1 Login MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
JOBSEEKR REGISTRATION The Jobseeker has to register before login to Online Job Consultant site. A valid data has to enter for registration.
Start
New Jobseeker Registration
New Jobseeker Registration
Message
No
If valid data
Yes
Database
Figure 7.2 Jobseeker Registration
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
JOBPOSTER REGISTRATION The Jobposter has to register before login to Online Job Consultant Site. A valid data has to enter for registration.
Start
New Jobseeker Registration
Accept Jobposter Details
Message
No
If valid data
Yes
Database
Figure 7.3 Jobposter Registration
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
Tables used in the ONLINE JOB CONSULTANT SITE NAME
: LOGIN
DESCRIPTION
: This table contains the Userid and Password details about Authorized users (Job seekers and posters) of Job consultant site.
PRIMARY KEY
: LOGIN_ID
FIELD NAME LOGIN_CATEGORY LOGIN_ID LOGIN_PASSWORD STATUS
DATA TYPE NUMBER(1) VARCHAR2() VARCHAR2() NUMBER(1)
DESCRIPTION USERS CATEGORY TYPE USERS IDENTIFICATION USERS PASSWORD USERS STATUS
NAME
: JOB APPLY
DESCRIPTION
: This table contains all the details about authorized job seekers
PRIMARY KEY
: USER_ID
FIELD NAME USER_ID COMP_NAME COMP_ID QUES_NO QUESTION REPLY APPLIED_DATE COUNT STATUS
MCTA
DATA TYPE VARCHAR2(15) VARCHAR2(25) VARCHAR2(20) NUMBER(4) VARCHAR2(30) VARCHAR2(30) DATE NUMBER(4) NUMBER (1)
DESCRIPTION USER IDENTIFICATION COMPANY NAME COMPANY IDENTIFICATION QUESTION NUMBERS QUESTION REPLY APPLIED DATE USER COUNT STATUS
B.SC(IT)
E-JOB ( Electronic-Job )
2007
NAME
: SEEKERS_REG
DESCRIPTION
: This table contains all the details about jobseekers
REFERENNCE
: LOGON (LOGIN_ID)
FIELD NAME USER_ID PWD_QUESTION PWD_ANSWER NAME SEX D_O_B CITY STATE PIN_CODE MAIL_ID RES_NO OFF_NO MOB_NO TOT_EXP CURR_IND CURR_FAREA UG_COURSE PG_COURSE PPG_COURSE REG_DATE LAST_DATE
MCTA
DATA TYPE VARCHAR2(15) VARCHAR2(55) VARCHAR2(20) VARCHAR2(20) VARCHAR(6) DATE VARCHAR2(12) VARCHAR2(20) NUMBER(6) VARCHAR2(20) VARCHAR2(14) VARCHAR2(20) NUMBER(10) VARCHAR2(11) VARCHAR2(46) VARCHAR2(40) VARCHAR2(8) VARCHAR2(8) VARCHAR2(8) DATE DATE
DESCRIPTION USER IDENTIFICATION PASSWORD QUESTION PASSWORD ANSWER JOBSEEKER NAME SEX DATE OF BRITH CITY NAME STATE NAME PINCODE MAIL_ID RESIDENCE PHONE NUMBER OFFICE PHONE NUMBER MOBILE NUMBER TOTAL EXPERIENCE INDUSTRY TYPE FUNCTIONAL AREA UNDER GRADUATION COURSE POST GRADUCATION COURSE P POST GRADUATION COURSE REGISTERED DATE LAST DATE
B.SC(IT)
E-JOB ( Electronic-Job )
2007
NAME
: SEEKERS_REG
DESCRIPTION
: This table contains all the details about jobseekers
REFERENCE
: LOGIN (LOGIN_ID)
NAME
: POSTERS_REG
DESCRIPTION
: This table contains all the details about authorized job seekers
REFERENCE
: LOGIN (LOGIN_ID)
FIELD NAME COMP_ID COMP_NAME WEBSITE STREET CITY STATE PIN_CODE PHONE_NO FAX_NO IND_TYPE FUN_AREA TURN_OVER CON_PERSON PER_DES MAIL_ID REG_DATE LAST_DATE
MCTA
DATA TYPE VARCHAR2(20) VARCHAR2(25) VARCHAR2(25) VARCHAR2(15) VARCHAR2(12) VARCHAR2(16) NUMBER (6) VARCHAR2(14) VARCHAR2(17) VARCHAR2(46) VARCHAR2(40) VARCHAR2(14) VARCHAR2(20) VARCHAR2(20) VARCHAR2(20) DATE DATE
DESCRIPTION COMPANY IDENTIFICATION COMPANY NAME COMPANY WEBSITE STREET NAME CITY NAME STATE NAME PIN_CODE PHONE_NUMBER FAX_NUMBER INDUSTRY TYPE FUNCTIONAL AREA YEARLY TURN_OVER CONTACT PERSON CONTACT PERSON DESIGNATION MAIL_ID REGISTERED DATE LAST DATE
B.SC(IT)
E-JOB ( Electronic-Job )
2007
NAME
: JOBPOSTING
DESCRIPTION
: This table contains the details about job posters and There requirement
PRIMARY KEY
FIELD NAME COM_ID HR_NAME E_MAIL CONT_NO REQUIREMENT ELIGIBILITY POSTED_DATE LAST_DATE STATUS
: USER_ID
DATA TYPE VARCHAR2(20) VARCHAR2(20) VARCHAR2(20) NUMBER(10) VARCHAR2(30) VARCHAR2(10) DATE DATE NUMBER(1)
DESCRIPTION COMPANY IDENTIFICATION HR NAME MAIL_ID CONT NUMBER JOB REQUIREMENT ELIGIBILITY FOR JOB POSTED DATE LAST DATE STATUS
NAME
: RESUME
DESCRIPTION
: This table contains the details about jobseeker
REFERENCE
: LOGIN (LOGIN_ID)
FIELD NAME USER_ID USER_NAME FATHER_NAME ADDRESS PIN_CODE SE_MARKS
DATA TYPE VARCHAR2(20) VARCHAR2(20) VARCHAR2(20) VARCHAR2(20) NUMBER(6) NUMBER(3)
SE_PSNT
VARCHAR2(4)
PE_MARKS
NUMBER(30
PE_PSNT
VARCHAR2(4)
UG_MARKS
NUMBER(3)
UG_PSNT
VARCHAR2(4)
PG_MARKS
NUMBER(4)
PG_PSNT
VARCHAR2(4)
MCTA
DESCRIPTION USER IDENTIFICATION USER NAME FATHER NAME USER ADDRESS PIN CODE SECONDARY EDUCATION MARKS SECONDARY EDUCATION PERCENTAGE PRE UNIVERSITY EDUCATION MARKS PRE UNIVERSITY EDUCTION PERCENTAGE UNDER GRADIATION COURSE MARKS UNDER GRADUATION COURSE PERCENTAGE POST GRADUATION COURSE MARKS POST GRADUATION COURSE PERCENTAGE
B.SC(IT)
E-JOB ( Electronic-Job )
2007
PPG_MARKS
NUMBER(3)
PPG_PSNT
VARCHAR2(4)
TO_SPEEK TO_READ TO_WRITE
VARCHAR2(30) VARCHAR2(30) VARCHAR(30)
MCTA
PPOST GRADUATION COURSE MARKS PPOST GRADUCATION COURSE PERCENTAGE TO SPEEK TO READ TO WRITE
B.SC(IT)
E-JOB ( Electronic-Job )
2007
Chapter 8
IMPLEMENTATION 8.1
Introduction The term implementation has different meaning, ranging from the conversion
of the basic application to a compatible replacement of a computer system. Implementation is used here to mean the process converting a new or revised system design in the operation one. During the implementation stage we conver the detailed code in a programming language. The Online job consultant Site is being designed to automate the job providing system. The purpose of this document is to provide the company details for the jobseekers where there is job vacancy
8.2
Approaches to the Implementation
The basic implementation has been done in 3-Tier architecture. The three physical tiers break down as follows: Presentation Layer Application Layer Database Layer 8.2.1 Presentation Layer The presentation layer is the front-end tool with which the end user interacts. In ASP applications, the presentation layer usually takes the form of a web browser. This client side consists of web pages, contains HTML code that are to be displayed using web browser. The scripting language used is JavaScript and VBScript
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
8.2.2 Application Layer The application layer represents most of the logic that makes the application functional. In the case of ASP this is where our ASP pages reside, upon the web server. 8.2.3 Database Layer The database layer represents the storage mechanism used to hold persistent data. This could be a relational database, text-based file, directory, mail server etc., Oracle is being used in this project.
8.3
Implementation Stage
Online Job Consultant Site In the Online Job Consultant system the implantation is done for the first screen. Here the Online Job Consultant system is given an input. The input is the details of the job seekers or the job posters. The Online Job Consultant system stores all the details in the database and helps out the administrator to retrieve it whenever it is needed. Then the remaining screens are designed and link between them is established. System implementation refers to implementation of the project to the real time. The job consultant site holds a common database for storage of user’s details regarding their searching, posting and all other transactions. The administration has the entire responsibility on the developed system and all tasks of the developed system. Administrator is permitting the users to search the job depending on their requirement. The administrator is responsible for adding up a new feature.
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
8.4
2007
Modules Implementation
The implementation details are given below There are various forms were designed in each of the modules they are
New Users Area o New Registration form for jobseeker o New registration form for jobposters
•
Job seeker Service Area o Resume form o Update registration form o Update resume form o Feedback o Reply o Job applying o Job searching
By industry type
By functional area
By company name
By state name
By city name
By company website
Job poster Service Area o Update registration form o Job appliers details form o Job posting
Administration Area o Add new jobseeker form o Add new jobposter form
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
o Add new job postings o User reply form
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
Chapter 9
TESTING AND RESULTS 9.1
Introduction Testing is the major quality process involved in software quality assurance.
Here test data is prepared and is used to test the modules individually. System testing marks sure that all component of the system function properly as a unit by actually forcing the system to fail.
9.2
Testing objective
Testing is a process of executing a program with the intent of finding an error.
A good test case is one that has a high probability of finding an as-yet undiscovered error.
9.3
A successful test is one that uncovers an as-yet undiscovered error.
Testing Principles
All tests should be traceable customer requirements.
Tests should be planned long before testing begins.
Testing should begin “in the small” and progress towards testing” in the large”.
9.4
Testing Strategies
9.4.1 Unit Testing Unit testing focuses on locating errors in each module. This gives a way to correct the errors without affecting the other modules involved in the system. 9.4.2 System Testing Once individual modules are tested, modules are assembled and integrated to perform as a system. Then the top-down testing from upper-level modules testing to check whether the entire system is working properly.
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
MCTA
2007
B.SC(IT)
E-JOB ( Electronic-Job )
2007
9.4.3 Acceptance Testing When the system has no major problems with its accuracy, the system passes through a final acceptance test. This test conforms that the system meets the original goals, objectives and requirements established during analysis. If the system fulfills the entire requirements, it is finally acceptable and ready for operation. 9.4.4 Integrity Testing Integrity testing is simply making sure that the pages you have just put together work properly that they display without errors and that all the links point to real locations. This type of testing does not say anything about whether technically correct. 9.4.5 Code testing-validation HTML The first test is to make sure that we have written correct HTML that all the tags have proper closing tags, that we have not overlapped any tags or used tags inside other tags that do not work. That is what checking in the browner so far. Browser are designed to try to work around problems in the HTML file they are parsing, to assume they know what where trying to do in the first place, and to display something if they can not figure out what we were to do. Some browsers are more lenient that others in the THTML, they accept. A page with errors may work in one browser and not work in other browser. So the best way to find out whether the pages are correct is to run them through an HTML validator. HTML validator is return to check only HTML. The validator does not care what the page look just it will check whether it is to correct HTML specification. 9.4.6 Browser Testing The entire HTML validator is to make sure that the HTML is correct. They won’t tell us anything about our design. After the validation test, we should still test the pages on as many browsers as we can find to make sure that the design is working and that we have not done anything wrong that looks fine in one browser but awful in another. Because most browsers are free and easily downloaded, we should be able to collect at least two or three browsers.
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
One of the big widely using browsers: Netscape or Microsoft.
Using these browsers, we shall get an idea how different browser view for the pages.
9.4.7 Web Page Testing Testing a web page is making that web presentation works not just from the technical side, but also the usability side. In addition, we want to make sure that our presentation is readable in multiple browsers, especially if we are using some of the more recent tags. 9.4.8 Verifying the Links The third and final test is to make sure that the link works. The most obvious way to do is to sit with a browser and follow them our self. This approach might be fine for small presentation, but with large presentation, checking links can be long and tedious tasks. Also, after we have checked links that first time, the sites linked might move or rename their pages. Because the web always changing even if the pages stay constant, links may break anyway. We can find out some broken links on our pages, which might have caused when moving things around, by checking the error logs that server keeps. These logs note the pages that cannot be found. Both the missing page and the page that contains link to that page. 9.4.9 Usability Testing Usability testing is making sure that document is usable, even after they have been tested for simple technical correctness. We can put a set of web pages easily, but the readers are not able to find what they need? Usability testing is a concept that many industries have been using for years. The theory, behind usability testing is that the designers who are creating the product can’t determine whether it is easy to use because they are too closely involved in the project. They know how to product is to use to watch people who have never seen it before as they use it and note the places they have trouble.
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
9.5
2007
Test Case Result A test case is a document that describes an input, action or event and an
expected response, to determine if a feature of an application is working correctly. Test Case
Test Case
No 1.
Authentication
Procedure
Expected result
Actual
Users login id and
Error message for
Result As
password compared with
invalid users and
Expected
service for valid users. Error message if left
As
2.
Mandatory
the table login Fields are checked for not
3.
fields Jobseeker
null. All the required details for
blank. Error message if not
Expected As
registration
the jobseeker registration
entered
Expected
Jobposter
submit All the required details for
Error message if not
As
registration
the jobposter registration
entered
Expected
submit All the required details
Error message if left
As
have to enter before it
blank.
Expected
has to entered before it 4.
has to entered before it 5.
6.
7.
8.
9.
Resume
submit. Before applying for the job Error message if not
As
the jobseeker has to
submit his profile.
Expected
Change
submit his profile Jobposter can change the
Update message
As
Jobposter
registration details as they
registration Feedback
need. User can send message
Error message if left
As
to the job site. Fields are
blank else success
Expected
checked for not null All the contents of
message Successful log out
As
sessions are cleared
message
Expected
Job apply
Logout
Expected
Chapter 10
CONCLUSION MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
The Online job consultant site is tested and result is very convincing. It worked out according to the expectation. The same code is tested in more than one system and compatible of the software is tested successfully. The post implementation review showed that this system is meeting its prescribed requirements. User will get maximum help from this system. It helps in faster and easier approach for searching job for jobseekers.
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
Chapter 11
FUTURE ENHANCEMENTS The project can further be improved, as it is flexible to expand by using the ASP and JavaScript. This project is developed under special care considering the user requirements. In spite of good performance, as per quote, “A software programmer never becomes satisfied with what he has developed “the system may be improved more. Following can further enhance the application developed: The online job Consultant Site project is providing service within India further it can enhance to provide job service throughout the world. High level of Encryption Technology to ensure data security and authentication.
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
Index Page
Registration Form
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
Administrator Form
Seeker From
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
Poster From
Job Search From
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
POSTER REGISTRATION FORM
JOB POSTING
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
CHANGE REGISTRATION FORM
CHANGE PASSWORD FORM
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
RESUME FORM
CHANGE RESUME FORM
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
CHANGE REGISTRATION FORM
CHANGE PASSWORD
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
REMOVE JOB SEEKERS
NEW JOBPOSTERS FORM
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
REMOVE JOB POSTERS FORM
NEW JOBS FORM
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
REMOVE JOBS FORMS
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
GENERAL CODING <% response.buffer=true %>
WELCOME JOB SEEKERS <% response.buffer=true %>
Job Posters Registration
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
<script language="javascript"> function save() { if(validate()) { document.frmregister.submit(); } } function validate() { var Strtemplate,temp,temp1,temp2; Strtemplate="^[a-zA-Z_0-9]+$"; temp= document.frmregister.txtuser.value; if(temp =="") { alert("User ID Can Not Be Empty"); document.frmregister.txtuser.focus(); return false; } temp= document.frmregister.txtuser.value.length; if(temp < 5) { alert("User ID Must Have Atleast 5 Characters"); document.frmregister.txtuser.focus(); return false; } temp= document.frmregister.txtuser.value; if(temp.search(Strtemplate)==-1) { alert("Please Enter Proper User ID"); document.frmregister.txtuser.focus(); return false; } temp= document.frmregister.txtpassword1.value.length; if(temp =="") { alert("Password Can Not Be Empty"); document.frmregister.txtpassword1.focus(); return false; } temp= document.frmregister.txtpassword1.value; temp1= document.frmregister.txtuser.value; if(temp==temp1) { alert("Password Should Not Be Same As User ID"); document.frmregister.txtpassword1.focus(); return false; } temp= document.frmregister.txtpassword1.value.length; if(temp < 8) { MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
alert("Password Must Have Atleast 8 Characters"); document.frmregister.txtpassword1.focus(); return false; } temp= document.frmregister.txtpassword1.value; if(temp.search(Strtemplate)==-1) { alert("Please Enter Proper Password"); document.frmregister.txtpassword1.focus(); return false; } temp= document.frmregister.txtpassword2.value.length; if(temp =="") { alert("Confirm Password Can Not Be Empty"); document.frmregister.txtpassword2.focus(); return false; } temp= document.frmregister.txtpassword2.value; if(temp.search(Strtemplate)==-1) { alert("Please Enter Proper Confirm Password"); document.frmregister.txtpassword2.focus(); return false; } temp= document.frmregister.txtpassword1.value; temp1= document.frmregister.txtpassword2.value; if(temp1!=temp) { alert("Confirm Password Should Be Same As Password"); document.frmregister.txtpassword2.focus(); return false; } Strtemplate="^[a-zA-Z]+$"; temp= document.frmregister.txtcname.value; if(temp =="") { alert("Company Name Can Not Be Empty"); document.frmregister.txtcname.focus(); return false; } temp= document.frmregister.txtcname.value; if(temp.search(Strtemplate)==-1) { alert("Please Enter Proper Company Name"); document.frmregister.txtcname.focus(); return false; } Strtemplate="^[a-zA-Z@.]+$"; temp= document.frmregister.txtmemail.value; MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
if(temp =="") { alert("Email address Can Not Be Empty"); document.frmregister.txtmemail.focus(); return false; } temp= document.frmregister.txtmemail.value; if(temp !="") { temp1= document.frmregister.txtmemail.value.indexOf('.',0); if(temp1==-1) { alert("Not a valid Email address"); document.frmregister.txtmemail.focus(); return false; } } Strtemplate="^[a-zA-Z0-9]+$"; temp= document.frmregister.txtstreet.value; if(temp =="") { alert("Street Name Can Not Be Empty"); document.frmregister.txtstreet.focus(); return false; } temp= document.frmregister.txtstreet.value; if(temp.search(Strtemplate)==-1) { alert("Enter Proper Street Name"); document.frmregister.txtstreet.focus(); return false; } Strtemplate="^[ ]*$"; temp= document.frmregister.txtcity.value; if(temp =="") { alert("City Name Can Not Be Empty"); document.frmregister.txtcity.focus(); return false; } temp= document.frmregister.txtcity.value; if(temp.search(Strtemplate)!=-1) { alert("Select The Proper City Name"); document.frmregister.txtcity.focus(); return false; } temp= document.frmregister.txtstate.value; if(temp =="") { MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
alert("State Name Can Not Be Empty"); document.frmregister.txtstate.focus(); return false; } temp= document.frmregister.txtstate.value; if(temp.search(Strtemplate)!=-1) { alert("Select The Proper State Name"); document.frmregister.txtstate.focus(); return false; } Strtemplate="^[0-9]+$"; temp= document.frmregister.pincode.value; if(temp =="") { alert("Pin Code Can Not Be Empty"); document.frmregister.pincode.focus(); return false; } temp= document.frmregister.pincode.value; if(temp.search(Strtemplate)==-1) { alert("Please Enter Proper Pin Code"); document.frmregister.pincode.focus(); return false; } temp= document.frmregister.codeno.value; if(temp =="") { alert("Code Number Can Not Be Empty"); document.frmregister.codeno.focus(); return false; } temp= document.frmregister.codeno.value; if(temp.search(Strtemplate)==-1) { alert("Please Enter Proper Phone Number"); document.frmregister.codeno.focus(); return false; } temp= document.frmregister.phoneno.value; if(temp =="") { alert("Phone Number Can Not Be Empty"); document.frmregister.phoneno.focus(); return false; } temp= document.frmregister.phoneno.value; if(temp.search(Strtemplate)==-1) { alert("Please Enter Proper Phone Number"); MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
document.frmregister.phoneno.focus(); return false; } temp= document.frmregister.num.value; if(temp =="") { alert("Country Code Number Can Not Be Empty"); document.frmregister.num.focus(); return false; } temp= document.frmregister.num.value; if(temp.search(Strtemplate)==-1) { alert("Please Enter Proper Fax Number"); document.frmregister.num.focus(); return false; } temp= document.frmregister.cno.value; if(temp =="") { alert("Code Number Can Not Be Empty"); document.frmregister.cno.focus(); return false; } temp= document.frmregister.cno.value; if(temp.search(Strtemplate)==-1) { alert("Please Enter Proper Fax Number"); document.frmregister.cno.focus(); return false; } temp= document.frmregister.pno.value; if(temp =="") { alert("Fax Number Can Not Be Empty"); document.frmregister.pno.focus(); return false; } temp2= document.frmregister.pno.value; if(temp.search(Strtemplate)==-1) { alert("Please Enter Proper Fax Number"); document.frmregister.pno.focus(); return false; } Strtemplate="^[ ]*$"; temp= document.frmregister.cmptype.value; if(temp.search(Strtemplate)!=-1) { alert("Select The Current Industry Type"); document.frmregister.cmptype.focus(); MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
return false; } temp= document.frmregister.cfarea.value; if(temp.search(Strtemplate)!=-1) { alert("Select The Current Functional Area"); document.frmregister.cfarea.focus(); return false; } Strtemplate="^[a-z A-Z]*$"; temp= document.frmregister.txtcperson.value; if(temp.search(Strtemplate)==-1) { alert("Enter The Contact Person Name Properly"); document.frmregister.txtcperson.focus(); return false; } temp= document.frmregister.txtcpersond.value; if(temp.search(Strtemplate)==-1) { alert("Enter The Contact Person's Designation Properly"); document.frmregister.txtcpersond.focus(); return false; } Strtemplate="^[ ]*$"; temp= document.frmregister.txturl.value; if(temp !="") { temp1= document.frmregister.txturl.value.indexOf('@',0); temp2= document.frmregister.txturl.value.indexOf('.',0); if((temp1==-1) || (temp2==-1)) { alert("Not a valid Websit URL"); document.frmregister.txturl.focus(); return false; } } return true; }
MCTA
B.SC(IT)
E-JOB ( Electronic-Job )
2007
DATE : <%response.write(date)%> Fields marked by * are mandatory |