GROUP ASSIGNMENT
WEB APPLICATION
CT050-3-2-WAPP
TITLE:
APU E-RECRUITMENT SYSTEM
INTAKE CODE : UC2F1708IT(MBT)/IT(DBA)/CS
LECTURER NAME : SATHIAPRIYA A/P RAMIAH
DATE ASSIGNED: 27 FEBRUARY 2018
DATE COMPLETED : 16 MAY 2018
GROUP MEMBERS : ABDUR RAHMAN LUBNAA (TP041666)
BILL STEFANUS TANUJAYA (TP040256)
BWIZA CHARLOTTE KANGAHO (TP042851)
WAVDA ANIVA ZABIDI (TP043462)
TABLE OF CONTENT
Table of Figures................................................................................................................................i
1. Introduction..............................................................................................................................1
1.1. Objectives..........................................................................................................................1
1.2. Scope.................................................................................................................................1
1.3. Schedule............................................................................................................................2
2. Requirement Specification.......................................................................................................2
2.1. Audience Classification....................................................................................................2
2.2. Audience Characterization................................................................................................2
3. Design and Modelling..............................................................................................................4
3.1 Database Schema..............................................................................................................4
3.1.1 Entity Relationship Diagram (ERD)...............................................................................4
3.1.2 Data Dictionary...............................................................................................................5
3.2 Interface Design................................................................................................................7
3.3 Website Architecture.........................................................................................................8
3.3.1 Navigational Structure...............................................................................................8
3.3.2 Static and Dynamic Pages.........................................................................................9
4 IMPLEMENTATION.............................................................................................................10
4.1 Create..............................................................................................................................10
4.2 Read.................................................................................................................................11
4.3 Update.............................................................................................................................11
4.4 Delete..............................................................................................................................12
4.5 Login...............................................................................................................................12
5. Conclusion.................................................................................................................................13
5.1 Summary..............................................................................................................................13
5.2 Future Works...................................................................................................................14
6. References..................................................................................................................................15
2|Page
Table of Figures
Figure 1: Story Board......................................................................................................................7
Figure 2: Navigational Structure.....................................................................................................8
Figure 3: Create Snippet................................................................................................................10
Figure 4: Read Snippet..................................................................................................................11
Figure 5: Update Snippet...............................................................................................................11
Figure 6: Delete Snippet................................................................................................................12
Figure 7: Login Snippet.................................................................................................................12
Figure 8: Reset Snippet..................................................................................................................13
1
1. Introduction
The chosen application that the team has agreed upon will be an E-Recruitment
System for students of APU. E-recruitment is the process through which Web-based
resources are used for the process of finding personnel (Kaur, 2015). Since after thorough
research we found out that there is no proper medium for direct communication between
students and employers, we decided to create a new interactive application which will give
the opportunity to do so.
There will be different types of users; an Employer/Company, Job Seeker (APU
Student), Guest and Admin. Students will have the possibility of creating a profile which will
contain all their details and they will have to upload a copy of their resume. Employers will
also be able to create a profile whereby they will list their company details and post several
job advertisements. While browsing through the system, the students will have the ability to
apply for offers which upon doing so their resume will be automatically sent to the employer
through email. Admin has the ability to add and delete the users.
1.1. Objectives
1.1.1. To develop a fully working recruitment app to enhance the recruitment
process at APU.
1.1.2. To generate reports for administration for successful and rejected
applications.
1.2. Scope
This system will consist of creating fully working recruitment app based upon APU Career
Center. The project will be completed by May 2018. Modules of the system will include posting
of advertisements, searching for job advertisement, and update profile and resume as well as to
apply for job.
1|Page
1.3. Schedule
2. Requirement Specification
2.1. Audience Classification
2.1.1. Registered – Admin, Employer, Student.
2.1.2. Non-registered – Guest
2.2. Audience Characterization
2.2.1 Student
Allow to login and logout from the system.
Allow to update personal information.
Allow to upload Curriculum Vitae/Resume.
Allow to apply for job position.
Allow to see the status of the job application.
2.2.2 Employer/Company
Allow to login and logout from the system.
Allow to update Employer/Company profile.
Allow to post job advertisement.
2|Page
Allow to receive job application from job seeker through email sent by
the system.
Allow to modify the status of the job application.
2.2.3 Administration
Allow to login and logout from the system.
Allow to Add/Update/Delete user.
2.2.4. Guest
Allow to new end-users to register as Employer/Company.
3. Design and Modelling
3|Page
3.1 Database Schema
3.1.1 Entity Relationship Diagram (ERD)
4|Page
3.1.2 Data Dictionary
Below the data dictionary, which maps to the ERD and which has been implemented into the
Web Application.
3.1.2.1 User Table
Attribute Name Description Data Type Required PK or FK
Username The username for login Varchar(50) YES PK
Password The login password for the user Varchar(15) YES
Email The email of the user Varchar(40) YES
UserType The user type Varchar(20) YES
3.1.2.2 Applicant Table
Attribute Name Description Data Type Required PK or FK
Login ID of the job seeker
ApplicantID (The Student ID will be used Varchar(10) YES PK
for the System)
Login password of the
Name Varchar(50) YES
jobseeker
The first name of the job
Address Varchar(50) YES
seeker
The last name of the job
EmailAddress Varchar(50) NO
seeker
The email address of the job
MobileNumber Varchar(30) YES
seeker
The phone number of the job nbinary(MAX
Resume YES
seeker )
5|Page
3.1.2.3 Feedback Table
Attribute Name Description Data Type Required PK or FK
Id Id of feedback int YES PK
Username Email of the person Varchar (50) No FK
Feedback Feedback comment Varchar(MAX) No
Rating Rating number given Int No
3.1.2.4 Company Table
Attribute Name Description Data Type Required PK or FK
CompanyName Name of the company Varchar(50) YES PK
Login pass of the
CompPassword Varchar(30) YES
company
Industry to which the
Industry Varchar(40) NO
company belongs to
The address of the
CompAddress Varchar(MAX) NO
company
CompEmail The email of the company Varchar(40) NO
The website of the
CompWebsite Varchar(30) NO
company
The Phone number of the
ComPhone Varchar(15) NO
company
The Fax No. of the
CompFax Varchar(15) NO
company
CompanySize The size of the company Varchar(20) NO
The Language spoken at
CompLanguage Varchar(20) NO
the company
6|Page
3.1.2.5 Job Advertisement Table
Attribute Name Description Data Type Required PK or FK
JobAdID The Advertisement Id Int YES PK
The name of the job
JobName Varchar(30) YES
(position)
JobDesc The description of the job Varchar(MAX) YES
The requirements for the
JobRequirement Varchar(MAX) YES
job
CompanyName The company Id Varchar(50) YES FK
Location The location of the job Varchar(30) NO
The number of places
NoOfVacancies Varchar(MAX) NO
available
Salary The monthly salary Varchar NO
3.2 Interface Design
Figure 1: Story Board
7|Page
3.3 Website Architecture
3.3.1 Navigational Structure
Figure 2: Navigational Structure
8|Page
3.3.2 Static and Dynamic Pages
No Static Pages Dynamic Pages
1 Student Home Page Add User
2 Employer Home Page Update User
3 Admin Home Page View User
4 About Us Register as Employer
5 Login
6 View Student Profile
7 Update Student Profile
8 Add Advertisement
9 Update Job Advertisement
10 Add Job Advertisement
11 Update Job Advertisement
12 View Job Advertisement
13 Apply and view job details
14 View Job Application Status
15 View Company Profile
16 Update Company Profile
17 Add User Feedback
18 View User Feedback
9|Page
4 IMPLEMENTATION
In addition to the tutorial materials provided during the lab sessions, several books have been
used in developing the application to provide better understanding of the several concepts
(Liberty, 2005) (Spaanjaars, 2009) (Anderson et al., 2010) (Lloyd, 2008) (Skeet, 2009) (Lawson,
2012) (Lubers et al., 2012) (Atkinson and Vieira, 2012) (Bailey et al., 2006).
4.1 Create
In Figure 3 below, the code for creating Feedback is displayed. The code aims to create
feedback records which contain the email, feedback and rating into the database in the Table
feedback. This even happens when the Submit button on the Feedback.aspx page is created.
Figure 3: Create Snippet
Submit Feedback Function in AddFeedback.aspx
10 | P a g e
4.2 Read
In Figure 4 below, the code is to display (read) data from the feedback table where all the
attributes data will be displayed in terms of a single string in the View Feedback aspx page.
Figure 4: Read Snippet
View User Feedback Function in ViewFeedback.aspx
4.3 Update
In figure 5 below, when the Button edit in the Search User aspx page, the data into the table
Users into the database will be updated based on the input provided in the Search user page.
Figure 5: Update Snippet
Update/Edit User Function in SearchUser.aspx
11 | P a g e
4.4 Delete
In figure 6 below, when the Delete button from the search user aspx page will be clicked, the
record matching to the ID will also be deleted from the User table in the database.
Figure 6: Delete Snippet
Delete User Function in SearchUser.aspx
4.5 Login
In figure 7 below, when the Login button on the Login aspx page will be clicked, the number
of users in the table user will be counted to check whether there is the user inside the table.
While the user exist he will be redirected to another page else, Login will fail.
Figure 7: Login Snippet
Login Button in Login Page
12 | P a g e
In figure 8 below, upon clicking the reset button, the textbox on the Login page will be
reset.
Figure 8: Reset Snippet
Reset Button in Login.aspx
5. Conclusion
5.1 Summary
This project was completed by the team of four members through hard work and a
great teamwork that was shown form each member. We divide our task fairly and always
willing to help each other if they have an obstacle during the completion of the assignment.
Everyone in the group always try their best to come up with a good and high-quality web
application.
Every member is very well coordinated, we usually communicate with each other
through social media group and through some group meetings. Every member is committed
in working their part of assignment and always strive to get a good quality web pages.
Everyone is giving a big contribution in making this system complete, everyone supports
each other to make every task easier to accomplish.
In this assignment we build a web application for E-Recruitment system. This system
is designed for students of APU who wants to get a job from Employer that comes from
various field .In the system we build a lot of function that combine the JavaScript, ASPX, C#,
and CSS such as the search system to find jobs where the data taken from the database,
viewing the data, etc. we also learn how to implement bootstrap, know how to design a good
web page, connecting database with the data from the web page, and also passing that data
using database.
This assignment made us know the basics on how to be a web developer and also
prepared us to be a web developer. We also learn how to communicate effectively with each
other in order to get all the task done and how to work with each other.
13 | P a g e
5.2 Future Works
In the future, several features can be added to improve this web application, namely
1. A messaging medium built in the Web app to allow the company to communicate to the
students
2. Allowing interview invite and offers to be entertained directly onto the web app rather
than through email
3. A better user Interface
4. Allowing the Company to accept or reject a student directly such that the student can be
update on his application status.
14 | P a g e
6. References
Atkinson, P. & Vieira, R., 2012. Beginning Microsoft SQL Server 2012 programming,
Indianapolis: John Wiley & Sons.
Anderson, R., Patel, S., Latham, L., Pasic, A. and Dykstra, T. (2010). ASP.NET overview. [online]
Docs.microsoft.com. Available at: https://docs.microsoft.com/en-us/aspnet/overview [Accessed
15 May 2018].
Kaur, P., 2015. E-recruitment: A conceptual study. International Journal of Applied Research,
1(8), pp.78-82.
Lawson, B., 2012. Introducing HTML5, Berkeley, CA: New Riders Publishing.
Liberty, J., 2005. Programming C#: Building. NET Applications with C. " O'Reilly Media, Inc.".
Lloyd, I. (2008). Build your own web site the right way using HTML & CSS. Collingwood, Vic.,
Australia: Sitepoint
Lubbers, P., Salim, F. & Albers, B., 2012. Pro HTML5 Programming: Powerful APIs for Richer
Internet Application Development, Berkeley, CA: Apress.
Skeet, J. (2009). C♯ in depth. Greenwich: Manning.
Spaanjaars, I. (2009). Beginning ASP.NET 3.5. Indianapolis, Ind.: Wiley Pub.
15 | P a g e
