PERPUSTAKAAN UMP
U DO
IDIOIflIO111 O I
0000079004
INTERNSHIP MANAGEMENT SYSTEM
FARH) RID WAN BIN ABDULL HADI
Report submitted in partial fulfillment of the requirements for the award of Bachelor of
Computer Science (Honours) in Technology Graphic and Multimedia
Faculty of Computer System and Software Engineering
UNIVERSITI MALAYSIA PAHANG
DECEMBER 2012
V
ABSTRACT
Manual process need to be done for this system, manual process means, the student or
intern's candidate need to fill a paper form, and also need to submit it by hand to the office.
During the training, candidates need to keep update in the logbook about their daily routine of
the training by writing it and paste any attachment in the logbook. Finally, progress of the
training in the logbook will be examined by supervisor in company every week, and by
university supervisor at the end of the training by write it in the logbook. Internship
Management System is a management system that handles the process of the industrial
training by computerize and online. Process focus in the system is selection of company,
updating their log, and registers the company supervisor in the system.
vi
ABSTRAK
Proses manual perlu dilakukan untuk system latihan industri mi, maksud bagi manual
process tersebut ialan pelajar atau calon bg latihan industry mi perlu mengisi borang dan juga
menghantar borang tersebut sendiri di pejabat. Semasa latihan, calon hendaklah
mengemaskini buku log mereka tentang apa yang dilakukan setiap hari dengan menulis dan
juga menampal segala lampiran yang berkaitan didalam buku log tersebut. Yang terakhir,
perkembangan bg latihan itu akan di periksa oleh penyelia syarikat pada setiap minggu,
manakala, akan di periksa oleh penyelia universiti pada akhir latihan. "Internship
Management System mi adalah sistem yang akan menjalankan proses latihan industri mi
secara online. Proses yang akan di tangani oleh sistem mi ialah termasuk pemilihan syarikat,
mengemaskini buku log, mendaftar penyelia syarikat dan lain-lain.
vii
TABLE OF CONTENTS
Page
SUPERVISOR'S DECLARATION
STUDENT'S DECLARATION
ACKNOWLEDGMENTS iv
ABSTRACT v
ABSTRAK vi
CONTENTS vii
LIST OF TABLES xi
LIST OF FIGURES xii
CHAPTER 1 INTRODUCTION
1.1 Research Background 1
1.2 Problem Statement 2
1.3 Objectives of Research and Scope of Works 2
1.4 Scope 2
1.5 Thesis Organization 3
CHAPTER 2 LITERATURE REVIEW
2.1 Existing System Review
vi"
2.1 .1 Industrial Training Online Management System for 5
School of Art and Science Tunku Abdul Rahnian
2.1.2 Industrial Training System(ITS) for Universiti 6
Teknologi Malaysia
2.1.3 Industrial Training System in UIMIP(current practice) 6
2.1.4 Comparison between all the existing systems. 10
2.2 Technique 11
2.2.1 Web Applications 11
2.2.2 Web browser 11
2.2.2.1 Google Chrome 11
2.2.2.2 Mozilla Firefox 12
2.2.2.3 Internet Explorer 12
2.2.3 Tools for making dynamic and interactive Web 12
pages
2.2.3.1 PHP 12
2.2.3.2 ASP.NET 13
2.2.3.3 .isr' 13
2.2.3.4 Comparison between all the tools 13
2.3 Web server 14
23.1 Apache 14
2.3.1.1 XAMPP 14
2.4 Database language 15
2.4.1 MySQL 15
2.4.2 Oracle 15
2.4.3 Comparison between two languages(MySQL and 16
Oracle)
CHAPTER 3 METHODOLOGY
3.1 Rapid Application Development 18
lx
3.1.1 Requirements Planning 18
3.1.2 System Design 19
3.1.2.1 Design for student 20
3.1.2.1.1 Flowchart design for student 20
3.1.2.1.2 Interface Design for student 21
3.1.2.2 Design for Admin (industrial training 22
coordinator)
3.1.2.3 Design for university (lecturer) and 23
industry supervisor
3.1.2.4 Database Design 24
3.1.3 Construction 27
3.1.4 Cutover 27
3.2 Software and Hardware Used 28
3.3
Justification Methodology Selection 29
CHAPTER 4 IMPLEMENTATION
4.1 Introduction 30
4.2 Database Table 31
4.3 Function Implementation 33
4.4 Interface Implementation 34
CHAPTER 5 RESULTS AND DISCUSSION
5.1 38
Result Analysis
5.2
Result of the system 38
5•3 Advantage and Disadvantage of Internship Management 38
System
5.3.1 Advantages 39
5.3.2 Disadvantages 39
5.4 Constraint 39
CHAPTER 6 CONCLUSION
6.1 Conclusion 40
6.2 Future Research and Enhancement 40
REFERENCES 41
43
APPENDIX A
45
APPENDIX B
APPENDIX C 49
APPENDIX D 58
xi
LIST OF TABLES
Table Page
No.
2.1 Comparison between all three existing system. 10
2.2 Comparison between ASP.NET, PHP and JSP 13
2.3 Caomparison between MySQL and Oracle 16
3.1 Step of Designing 19
3.2 Software used 28
3.3 Hardware Used 28
xl'
LIST OF FIGURES
Figure Page
No.
2.1 View of homepages for TARC Industrial Training Online 5
Management System
2.2 Form for Self repot process 7
2.3 Form for Self repot process 8
2.4 Log every day with mark need to be given by supervisor 9
3.1 Rapid Application Development (RAD) model phases 18
3.2 Flow chart of the system for student 20
3.3 Interface design 21
3.4 Flow chart of system for admin 22
3.5 The flowchart of system for both supervisor 23
3.6 Database design 24
3.7 ERD diagram flow 25
3.8 ERD diagram 26
4.1 Database of the system 32
4.2 Code for login function 33
4.3 Codes for search function 34
4.4 The login interface 35
4.5 Student profile in system 35
xli'
4.6 Interfaces for Search Company 36
4.7 Pages for update log in timeline 36
CHAPTER 1
INTRODUCTION
1.1 Introduction
Internships are the way to explore or expend the related knowledge and skills required
in a real world situation and experience to enter into a particular career field. [1] Its basically
for undergraduate student, or a trainee, this not only for gaining experience, but also expose
them to fine if they a totally interest in the field. Regarding to Dr. Mohamed Ariff Ameedeen,
the internship's coordinator FSKKP, the number of student will be out to the industry is
roughly 500 people. So, every year about 500 students will be on interns, but this is
depending on how many people who qualify to register it. All students must pass the entire
subject they taken before they go for interns.
Manual process need to be done for this system, manual process means, the student or
intern's candidate need to fill a paper form, and also need to submit it by hand to the office.
During the training, candidates need to keep update in the logbook about their daily routine of
the training by writing it and paste any attachment in the logbook. Finally, progress of the
training in the logbook will be examined by supervisor in company every week, and by
university supervisor at the end of the training by write it in the logbook.
Applying a manual process may cause some disadvantages, because it required the
user to write it in a paper, instate of write it in computer. Error on filling in the form can be
void if it is filling on computer. And the data can't directly use, but need to be rewritten
before can be used, this way will have a lot of work on it. Other than that, problem of losing
or misplace the form can be avoid, or damaging the hardcopy form will not occur.
2
1.2 Problem statements
Before going to the industrial training, student need to complete the registration
process. The process then need to be done manually, which mean students need to fill and
complete in by write it in the form. After receiving offer letter from company, students need
to inform faculty's internship coordinator for approving. Beside, when it comes to the day
student came to internship place, they need to make a self-report manually by fill in the form
in the logbook about details of company. While student undergoing the training, they need to
write on the logbook about what they are doing every day in the logbook. Other than that,
student performance also had been mark by company's supervisor every week. The mark will
be given in the logbook. Furthermore, students need to buy the logbook and the logbook itself
easily damage.
1.3 Objectives
• Develop prototype of online internship application system
• Develop prototype of online internship logbook
1.4 Scopes
The scopes of the project are:
I. Faculty of Computer Sciences and Software Engineering
II. Web base application
III. HTML5
IV. 4 users
• FSKKP's Student
• Company Supervisor
• Faculty Supervisor
• Internship Coordinator
3
1.5 Thesis Organization
This thesis consists of 6 chapters ranging from Chapter 1 until Chapter 6. Chapter 1
gives an overview of the study conducted. It also supply with the problem statement,
objective and the scope of the study. Meanwhile, Chapter 2 reviews the previous research
works that was conducted by other researches. All the relevant technical paper, journals, and
books taken from those researches will be discussed in detail. Chapter 3 reveals the
techniques and the algorithms that will be used in performing this study. It will discuss about
the process flow in detail of this research. Details of the implementation of the study will be
discussed in Chapter 4. Results of the testing are to be expounding in Chapter 5. Lastly,
Chapter 6 concludes the entire thesis.
CHAPTER 2
LITERATURE REVIEW
This chapter is to explain about the reviews for this project. It is divided to two major parts:
system/present review and technique, method, equipment, as well technology review.
2.1 Existing System Review
This section is to review the current system and the existing system that related to Industrial
Training system.
5
2.1.1 Industrial Training Online Management System for School of Art and Science
Tunku Abdul Rahman College(TAR)
This system consists of 9 modules, i.e. security, job application, allocation,
notification, feedback, maintenance, query, report and housekeeping. The project main
purpose are to allow student send online resume, coordinator send reminder to collect survey
form from student and so on. [2] Figure 2.1 show the example of the system.
' 0 *
1NDUSTRIAL TRAINING
ONLINE MANAGEMENT SYSTEM'
API COMPANY. INFO
P
%J
t
------
MfL. U,.,..z
Figure 2.1: View of homepages for TARC Industrial Training Online Management System
2.1.2 Industrial Training System(ITS) for Universiti Teknologi Malaysia
Industrial Training Systems (ITS-UTM) is a web based application system which is
developed to manage the industrial training process in Universiti Teknologi Malaysia (UTM).
During industrial training, students will be placed at selected organisations for a
predetermined duration of time in order for them to obtain exposure to the career world and
also for them to be able to relate what has been learned theoretically with the real application.
[3]
Modules that consist in the ITS are [3]:
• Main Page
• User Profile Management
• Program Session Management
• User Management by System Adminllndustrial Training Committee
• Student Pre-registration
• Company Management
• Placement and Letters Management
• Supervision
• Event Management
• Assessment
• Survey
2.1.3 Industrial Training System in UMP(current practice)
This system is an application to manage the industrial training process in Universiti
Malaysia Pahang. This is a manual system, where student need to buy a logbook, in the
logbook candidate need to fill the form of selfreport, and fill the log for everyday buy writing
or attach it in every page. The supervisor of the company need to give mark to the student
every week, by rate the log in the logbook. Figure 2.2, 2.3, 2.4 show the current system then
student need to be fill.
7
Sorang Al
Universiti upjir LATIHAN INDUSTRI
Malaysia BORANG PENGESAHAN MELAPORKAN DIRI PELAIIH&
V PAHANG PENDAFTARAN KURSUS LATIHAN INDUSTRI
Catatan:
Boang Thi hendaldah dllengkapkan oleh pelatlh don dlsohkan oleh Penyelia lndusM tempat
W menjolanlU sebaik sahoja melaporkan did dl IndusM.
iij Silo fakskan don poskon borang lntkepada: Unit LotIhan Indust,1,
Unfreisltl Malaysia Pahang, Lebuhzcya Tun Razaic 26300 Kuontan, Pahang, Malaysia,
No. Teleton :095492750 No. Faks :09 549 2525
(ill) Pelalfh waJib mendotto.rkursus Llsecora on4ine dalam tempoh yang dltetapkan.
1.Noma F-
2.No, Pelajar No. K/P I
3, Kod-kod KUrsu U [ I Semester[ t.....Sesi 20......
4. Program Pengajian
5. Mama & Alomat Industii
Tempot U
6. Alomot Tempat'Tinggol
SemoscU
Teleton: (HP) (R)
7. Tankh Melaporkan Did 1 1
8.Elaun Ditedma I RM Isebulan.
Soya sohkon rnaklomot tapor dirE don pendaftoron U dE Was adakth benor..
(Tondatangan Pelatih) fTodkhJ -
Dsohkan benar oleh Penyeflo lndustd,
Mama:
Jowatan
Ernet.
cop rasmlj
TarikP: _____________Faks:___________
Tel.:___________
Figure 2.2: Form for Seifrepot process
8
MAKLUMAT INDUSTRI
Noma Orgonisosi
Aomot:
NomoPenyelio:
Jawoton:
Jangka Masa lotihan : Mulo . Tamdt
MAKIUMAT UNIVERSITI
UNIT LATIHAN INDUSTRI Penyetia liniversiti
UI'JIVERSITI MALAYSIA PAHANG(UMP),
LEBUHRAYA TUN RAZAK 26300 KUANTAN Fokut
PAHANG DARUL MAKMUR. 1éefon Pej.)
No. lelefon :09-5492750 Teieton(H/P):
No.Faks :09-5492525 e-mel:.
Figure 2.3: Form for Seifrepot process
.mpau Janis Latihan Mingou MInggu, M Iuisir
19 20 .121 22 .23 24
Conick labhon
1 Mengendaupetalatan ___
2 P. erhatjan oeas Tandatarigan Pe_______
taish U
3 Psng'npaan dan pemasangan alat Tandatyngan
- Penyelta Thdustrl
4 Mengurnpul Ta ilkin:
5 UenLdlapora1 Name _____________
J*atan
- Tatlkts
CATATAN HARLAN
Tarikir
Dlsatrkan olek Penyella:
Tarikh:
FENILAIAN PENVELIA NDUSTRJ (MIPIGGUAN)
A,.kse kapada P.ny.Iia
Sila rujuk Laporan Harlan petajar pada rffinggV yang beslaftan semasa membuat perittasan den
ulasan Sila tandakan (I) ds petak yang brsesuatan:
Skala:
I Tldak Memuaskan 2 Kurang Mernuaskars 3 Mamuankan 4 Bask 5 Sattgat Balk
Prestasi kera pelajar adatak:
[] I
2
[1111 :]
Tltangaa Penyelia
Name
JawatanaCop
Tacsh -.
Ulasanflcomen -
Markstr prestast mlnggu ke- _(Drisi pada had terakktr setiaprnlnggu latihatt Industni)
Figure 2.4: Log every day with mark need to be given by supervisor
10
2.1.4 Comparison between all the existing systems.
Table 2.1 show the comparison of all existing system with the propose system.
Table 2.1 : Comparison between all three existing system
Modules TAIRC industrial ITS UTM Industrial training
system system for UMP
(current practice)
Online System Yes Yes No
Self-report on first No No Yes
day of training
Log for every day No No Yes
Giving mark base No No Yes
on log
Submitting report Yes Yes No
I
2.2 Technique
This section will review on the current technique on the web application,
programming language, framework, database language, web server and methodology.
2.2.1 Web Applications
A web application is an application that is invoked with a web browser over
the Internet. Web application development requires agility, the use of standard
components, interoperability and close attention to user needs. Web Application is
support user participation to add value to the application and collaborate with other
users. It has brought new emphasis to the role of (unstructured) data in applications
[4]. Web prefetching is a technique that is commonly applied to reduce the access
latency perceived by web user. This technique enables a web application to prefetch
data from the server so that it is immediately available upon user actions. Web
application must prefetch using accurate information in order to achieve reasonable
performance that justifies the additional resources consumed (bandwidth, extra server
load) [5].
2.2.2 Web browser
Web browser is a software application for retrieving presenting and traversing
information resources on the World Wide Web.
2.2.2.1 Google Chrome
Google chrome is compatible with Window XP, Vista and Windows 7. It is
initially designed for speed and generally faster browsing from double clicking on the
icon on desktop, we can potentially be browsing in less than a few seconds flat.
Besides, it is a simple design with rather no clutter in the toolbar and includes an auto
update and a builtjn malware. This browser also support the HTML5, CSS3 and JS.
12
2.2.2.2 Mozzila Firefox
Some of the features include tabbed browsing, integrated search box, add-ons
and custom skins. Security wise includes anti-spyware, anti-virus, anti-phishing, pop-
up blocker and private mode. Configurations are supported with Window Vista, XP
and MAC. Also support HTML5
2.2.2.3 Internet Explorer
Internet Explorer 10 is the current version with more features than ever before
including a neat tool that allows us to pin sites that we regulary visit and have access
to them directly from the toolbar. Other features include a more powerful download
manager, enhanced tabbed browsing, search using the address bar as appose to an
integrated search box and hardware acceleration to name just a few. Its also support
the HTMIL5, the before version did not support it.
2.2.3 Tools for making dynamic and interactive Web pages
There are many tools can be used to create dynamic and interactive web pages.
PHP, ASP.NET and JSP is the most popular programming tools for develop web
pages.
2.2.3.1 PHP
PHP is a powerful tool for making dynamic and interactive Web pages. It is
the widelyused, free and efficient [6]. PHP and MySQL has been the main web
development tool for it is free and open sources. They take PUP as the development
language because: free, small size of project, strong supporting, good portability,
simple grammer and rapid development. [7]
13
2.2.3.2 ASP.NET
ASP.NET is a web application framework developed and marketed by
Microsoft to allow programmers to build dynamic Web sites, Web applications and
Web services [8].
2.2.3.3 JSP
JavaServer Pages (JSP) technology provides a simplied, fast way to create
dynamic web content. JSP technology enables repid development of web-based
applications that are server and platform independent. [9]
2.2.3.4 Comparison between all the tools
Table 2.2: Comparison between ASPNET, PUP and JSP[7]
ASP.NET PHP JSP
Security Safety is good, but PHP is a Safety is the
there exist certain recognized highest.
degree of security safety
vulnerabilities. performance.
Platform Single platform Multiplaform Multiplatform
incompatibility
Operating efficiency High Higher Highest
Cost High Free __^H_
igh
14
2.3 Web server
Web server can be define as either hardware(computer) or the computer software that
use to deliver web content that can be accessed through the internet. [10] Any computer can
be use as web server by installing server software and connecting the machine to the
Internet. There is several web server software application, including public domain software
NCSA and Apache.
23.1 Apache
Apache is a software foundation that create and provides a web servers
software as an open source software. HTTP server which is the most porpular H1TP
server in use today is thier main product. This service is totally free. The advantages
of apache is:
• Apache has various useful features
• Apache server and API source code are open to public
• Run faster and consumes less system resource
• Can be run on various operating system
2.3.1.1 XAMPP
XAMPP is a free and open source cross-platform web server stack package.
The main tools that contain in it are Apache HTTP Server, MySQL database and
interprets for scripts written in PHP and Perl pregramming languages. XAMPP is an
easy to install Apache distribution containing MySQL, PHP and Pen [12].
