Agriculture Training Information System

BOR4NG PENGESAHAN STATUS TESIS

*

JUDUL: AGRICULTURE TRAINING INFORMATION SYSTEM (ATIS)

SESI PENGAJIAN: 2008

Saya WAN NOOR HASWANA BINTI WAN IBRAHIM (HURUF BESAR)

mengaku membenarkan tesis (PSMI Sarjanal Doktor Falsafah) ini disimpan di Perpustakaan Teknologi Maklumat dan Komunikasi dengan syarat-syarat kegunaan seperti berikut :

1. Tesis dan projek adalah hakmilik Universiti Teknikal Malaysia Melaka. 2. Perpustakaan Fakulti Teknologi Maklumat dan Komunikasi dibenarkan

membuat salinan untuk tujuan pengajian sahaja.

3. Perpustakaan Fakulti Teknologi Maklumat dan Komunikasi dibenarkan membuat salinan tesis ini sebagai bahan pertukaran antara institusi pengajiab tinggi.

4.

**

Sila tandakan (I)

SULIT (Mengandungi maklumat yang berdarjah keselamatan atau kepentingan Malaysia seperti yang termaktub di dalam AKTA RAHSIA RASMI 1972)

TERHAD (Mengandungi maklumat TERHAD yang telah ditentukan oleh organisasil badan di mana penyelidikan dijalankan)

I TIDAK TERHAD

(TANDATANGAN PENULIS) (TANDATANGAN PENYELIA)

Alamat tetap: EN MOHD FADZIL ZULKIFLI

N0.16 Lorong CP 118, Trnn Cheras Perdana

43200 Cheras, Selangor Darul Ehsan.

~ a r i k h : 02/05/0% Tarikh:

AGRICULTURE TRAINING INFORMATION SYSTEM

WAN NOOR HASWANA BINTI WAN IBRAHIM

This report is submitted in partial fulfillment of the requirements for the Bachelor of Computer Science (Database Management)

FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY UNIVERSITI TEKNIKAL MALAYSIA MELAKA

DECLARATION

I hereby declare that this project report entitled

AGRICULTURE TRAINING INFORMATION SYSTEM

is written by me and is my own effort and that no part has been plagiarized

without citations.

STUDENT : Date:

0 2 / 0 5 / ~

&

A WAN IBRAHIM)

SUPERVISOR: Date:

DEDICATION

A special dedication goes to my beloved parents Wan Ibrahim Wan Derahman

and Hasamah Ismail because giving support in completing my final year project which is

entitled Agriculture Training Information System (ATIS).

I also would like to dedicate to the people who help and support direct or indirect

ACKNOWLEDGEMENTS

I would like to gratefully acknowledge the contribution of several people who

helped me to complete this thesis. First, I would like to convey my grateful thanks to En

Mohd Fadzil Zulkifli as my supervisor at Faculty of Information Technology and

Communication, Universiti Teknikal Malaysia Melaka (UTeM) for their valuable

contribution and assistance in the preparation of this thesis and development of my

"Agriculture Training Information System" (ATIS).

A note of thanks is dedicated to few lecturers in UTeM in giving me some ideas,

information and also for spending their valuable time and effort. Their generosity can

only be expressed by me by being thankhl for having such kind lecturers who are

supportive.

My appreciation also goes to my friends and roommate for their valuable opinion

and solution that contributed in the development of this project.

Finally I owe special thanks to my parents who always support me during

performing this project.

Last but no least, to all might have involved directly or indirectly in developing

ABSTRACT

ABSTRAK

Agriculture Training Information System (ATIS) telah dibangunkan khas

untuk orang ramai membuat pendaftarm kursus pertanian. Pengguna boleh mendapatkan maklumat berkaitan kursus pertanian di dalam laman web ini. Orang ramai yang berminat boleh mendaftar melalui sistem ini. Permohonan ini akan diproses oleh pentadbir sistem dan setiap ahli yang mendaftar boleh mendapatkan status permohonan. Tambahan lagi, pentadbir sistem akan menguruskan pengguna yang berdaftar. Maklumat pendaftar akan diuruskan dengan sistematik. Hanya pentadbir sistem mempunyai hak clan keistimewaan unuk mencetak laporan kursus dan laporan jumlah pendaftaran kursus. Metodologi yang digunakan bagi sistem ini ialah Object Oriented Analysis and Design (OOAD). Satu analisa telah dijalankan

TABLE OF CONTENTS

CHAPTER SUBJECT

DECLARATION

DEDICATION

ACKNOWLEDGEMENTS

ABSTRACT

ABSTRAK

TABLE OF CONTENTS

LIST OF TABLES

LIST OF FIGURES

LIST OF ABBREVIATIONS

LIST OF APPENDICES

CHAPTER I INTRODUCTION

1.1 Project Background

1.2 Problem Statement 1.3 Objective

1.4

Scope

1.5 Project Significance 1.6 Expected Output

1.7 Conclusion

PAGE

i

ii

iii

iv

v

vi

xi

xii

xiv

CHAPTER

n

LITERATURE REVIEW

AND

PROJECT

METHODOLOGY

2.1 Introduction

2.2 Fact Finding 2.2.1 Domain

2.2.2 Existing System

2.2.2.1 Case Study of United

States Botanical

Garden

2.2.2.2 Case Study of Portal

Infoternak

2.2.2.3 Approach of

Comparison between

PHP and ASP.net

2.2.2.4 Comparison of Internet

Features

2.2.2.5 Comparison between

SSADAM and OOAD

2.2.3 Technique

2.3 Project Methodology

2.4 Project Requirements

2.4.1 Software Requirements

2.4.2 Hardware Requirement

2.4.3 Other Requirements

2.5 Project Schedule and Milestone

2.6 Conclusion

CHAPTER III ANALYSIS

3.1 Introduction

3.2.1 Flow Design of Current System 3.3 Requirement AnalysidAnalysis System

To-Be

3.3.1 Data Requirement 3.3.2 Functional Requirement 3.3.3 Use Case Description

3.3.4 Activity Diagram Description 3.3.5 Non-functional requirements 3.3.6 Others Requirements

3.4 Conclusion

CHAPTER IV DESIGN

4.1 Introduction

4.2 High-Level Design

4.2.1 System Architecture

4.2.1.1 Architecture View 4.2.1.2 Dynamic View 4.2.1.3 Static View 4.22 User Interface Design

4.2.2.1 Navigation Design 4.2.2.2 Input Design 4.2.2.3 Output Design 4.2.3 Conceptual Design

4.2.3.1 Conceptual Design

4.2.3.2 Logical Design 4.2.3.3 DBMS Selection 4.3 Detailed Design

4.3.1 S o h a r e Specification 4.3.2 Physical Datsbase Design

4.3.3 Data Manipulation Language

4.3.4 Data Security Mechanism

4.3.5 Database Contingency

4.4 Conclusion

CRAPTER

V IMPLEMENTATION

5.1 Introduction

5.2 Software Development Environment Setup

5.2.1 Programming Language

5.3 Database Implementation

5.4 Software Configuration management

5.4.1 Configuration environment Setup

5.4.2 Version Control procedure

5.5 Implementation Status

5.6 Conclusion

CHAPTER

VI

TESTING

6.1 Introduction

6.2 Test Plan

6.2.1 Test Organization

6.2.2 Test Environment

6.2.3 Test Schedule 6.3 Test Strategy

6.4 Test Design

6.4.1 Test Description

6.4.2

Test

Data

6.5 Test Result and Analysis

CHAPTER VII PROJECT CONCLUSION

7.1 Observation on Weakness and Strength 7.1.1 Strengths

7.1.2 Wealcness

7.2 Proposition for Improvement

7.3 Contribution

7.4 Conclusion

LIST OF TABLES TABLE 1.1 2.1 2.2 2.3 2.4 3.1 3.2 5.1 6.1 6.2 6.3 6.4 TITLE Technologies System

Comparison of Internet Sources

Hardware

Requirements PSM 1 Milestone

PSM I1 Milestone Software Requirements Hardware Requirements

Configuration Environment Setup User and Task for the Testing Phase Test Environment

Test Schedule

Test Specification for White Box

and

Black Box

Testing

Test Data for

User

Maintenance Module Test Case Result for Login Module

Test Case Result for Status Module (Member

Login)

Test Case Result for

User

Maintenance Module Test Case Result for Member Maintenace Module Test Case Result for Member Registration Module

LIST OF FIGURES

DIAGRAM TITLE

Main Menu

Portal Main Menu

The Database Life Cycle

Use Case Diagram of Current System Activity Diagram of Current System

Overview of ATIS

Use Case Diagram of ATIS System Architecture 2-Tier

Layering Architecture of ATIS

Tools in Web Development Process Create Database Structure

Create Database Command

Choose Privilege

Add New User

Create user Privilege syntax

Grant Privilege Command Select Database Name in SQL

Select Database Name

File Download

Folder Name for Backup

Save Backup File

Download Complete Import Form

Single Server Environment Create Site wizard

Choose Server Technology Wizard Locally Wizard

URL Testing

AppServ Welcome Screen GNUIGPL License Agreement

Choose Install Location Screen

Choose Package Component Apache Web Server Configuration MySQl Database Configure Complete AppSer

LIST OF ABBREVIATION ABBREVIATIONS FTMK ATIS ICT IT OOAD UML BITD DBLC MYSQL DBMS

PHP

SSADM OOA SQL ERD HTML EERD DESCRIPTION

Fakulti Teknologi Maklumat

Agriculture Training Information System Information Technology and Communication Information Technology

Object Oriented Analysis Design Unified Modelling Language

Bachelor Information Technology Database Database Life Cycle

My Structured Language Database Management System Hypertext Processor

Structured System Analysis and Design Method Object Oriented Analysis

Structure Query Language Entity Relationship Diagram Hypertext Markup Language

LIST OF APPENDICS

APPENDICES TITLE

Gantt Chart Data Requirement

Use Case Description

Activity Diagram

Dynamic View

Static View

User Interface

Navigation Diagram

Input Design

Output Design

Entity Relationship Diagram (ERD)

Business Rule

Data Dictionary

Normalization

Software Specification

Test Description

Logbook

CHAPTER I

INTRODUCTION

The chapter is an overview of the proposed system which will be included in

project background. The problem statements of the existing system also will be

defined together with objectives, scopes, project significance, expected output and

conclusion for the chapter.

1.1 Project Background

In this new era, Information Technology (IT) brings tremendous change in

the agriculture field which makes IT as a sophisticated platform to spread the latest

information. Agriculture Training Information System (ATIS) is a new system to

manage information about agriculture training.

The current Agriculture Training System still using the manual file system

which is also known as a simple database. Manual method wisely used to record the

information and events of the training. Moreover, the current online system is only

for retrieve information about agriculture course and user registration. There are

fewer functions for administrators where they need to calculate and organized the

total registration of member and course manually.

Rather than that, there is no response or feedback to user regarding to their

registration. This Agriculture training Information System (ATIS) will help to

In order to solve this problem, ATIS is proposed to be developed. ATIS is a

web based system that integrates training course information. Through ATIS, user

can register to attend training course by online. User can access detail information of

training that provided. ATIS will keep all information of user that registered. ATIS

capable to generate approval letter for candidates by online. This new system

provides a specific and details information.

This system can be a single point of access for the member and

administrators. The members can be registered online just by clicking the mouse

button in front of their computer at home and save their time. The additional feature

of the system is the members will get feedback about the registration

In addition, the improvement part for this system is to help the administrators

to easily retrieve the members' details. Other than that, it also supports the data

integrity for each and every change which is done on the system. Moreover, all kind

of queried can be done within a minutes. As a solution and to fulfill the needs this

system use the MySQL database management system. This system also assures the

data integrity and helps the management handle the donor's registration more

efficient. The data also can be shared by other applications and also known as

reusable.

The another enhancement part for this system is to help the training course

management or administrators to generate member report and produce statistic with

graphical representation such as bar chart and pie graph. The system also be able to

calculate the total number of members. This calculation process will be represented

1.2 Problem Statement

There are several problems that identified in current manual system. The

proposed enhancement system can prevent and overcome the existing problems. First

of all, the public are less publicity and knowledge about agriculture course due to the

unattractive web sites. Moreover, the current system is lack security. It is not

protected and responsible by certain people.

Currently, data is not managed properly under the manual process recording

system because records are keeping by a few individual separately. Thus, make

difficult for clerk to search for application records. Beside that, difficult for database

adrnin to update records where database administrator has a full right person to do a

modification on application information.

At present, it takes a long time to do the modification process because of all

the records are saved manually either using a form or save in the separate database.

Furthermore, difficult to collect applications information and to generate a report

according to requirements needed. Manual approval process also will consume

improper time effort because every application needs go through approval process.

Lastly the manual process will not practically to be used currently.

1.3 Objective

The objectives of the system are as follows:

a) To provide an online agriculture training course registration

By online registration system, provide 24 hour online access for user to get information about training course at home, office and any places that

provide internet. Furthermore, user can get information about course that

provide. This system will serve as information gateway to provide a

public and candidates with the latest news of training course and the

access. Moreover, to provide a useful decision support system and the

ability to access information in ways that supports strategic decision

making.

b) To generate an useful report from online registration

By online, this system provides capabilities to provide a useful report that

can generate member' registration records, approval letters, and others.

According to user request, data and records can generate a report to make

as reference and research according to needs.

c) To Automated Data Management

By online this system provides capabilities extracting, processing and

analyzing course information and generate approval letter. This helps

ensure that each participants will receives the right information coverage

at the right time.

1.4 Scope

In this section more focus to define and briefly description of ATIS scope of

system. Description about scope of user system, module system technology and

methodology system will describe below:

1.4.1 Scope of User System

The specific users for this system are:

-

Public

ATIS Member

1.4.2 Scope of Module System

In this sub scope will briefly explain about system module for ATIS there is:

a) Register Personal Profile

Only for authorized user have a right to register personal profile. Database

Admin, Staff and ATIS Member allow to access register personal profile module.

This interface module will appear according to user logon.

b) Register Training Course

Only for user that have registered as ATIS Member will have right to register

training course. This system provides the list of training course that offered

member to attend. After registered as ATIS member, they can choose the training

course that provide and make registration refer to training course that chosen.

Before that A T E Member can view the detail about t r a m course such as course name, date, time, location and others.

c) Check Application Status

Only for ATIS Member that has registered can check their status application

whether successfU1 or failed. The application status can be check for ATIS

member who have registered training course. For get the result ATIS Member

need to insert username and password in application status page. Then, the status

of application will appear.

d) Print Approval Letter

ATIS Members have a privilege to print approval letter as confirmation to that

training course application. After get to know the status, users have privileges to

print the approval letter. This approval letter needs to bring along when attend the

e) Generate Report

This system also provides a module to generate a report according to

documentation of the system. Record in the system can be manipulated to make

a useful report.

1.4.3 Scope of Technologies System

[image:23.526.61.475.288.509.2]

The technologies use to develop ATIS are listed in Figure 1.1 below:

Table 1.1: Technologies System

1.4.4 Scope of Methodology System Operating System

Database Management System@BMS) ServerISewlet

Graphic User Interface(GU1) Browser

Report

Unified Modeling Language Gantt Chart

There are two (2) type methodologies to be used in developing ATCIS, namely Object Oriented Analysis Design (OOAD) and Database Life Cycle (DBLC).

OOAD is used as methodology to develop ATIS as a whole while DBLC used in

database development and maintenance. The detail explanation of both

methodologies will be presented in the coming chapter.

Microsoft Window XP Professional

MySQL 4.0.2

Apache

Macromedia Dreamweaver 8

Internet Explorer 6.0 and above

Microsoft Word 2003

Rational Rose 2000

1.5 Project Significance

ATIS will bring out greater ease for the registration process. Instead of the

clerk having to take down records registration detail manually consume improper

time effort and take a long time to process. In addition to that problem, responsibility

transfers to authenticate user- who will fill up an online registration system in ATIS.

On other hand, adrnin only approve registration application for new participants.

By this system, will better tracking system compare to manual and improve

communications and transferring data. Moreover, this system also will help the

management and administrators to track the total number of members who have been

registered. This enhanced system will have the capability to generate report which is

consistent and precise. This function will be fast and effective with minimum human

errors.

1.6 Expected Output

At the end of this project, there will be a complete and interactive wed based

system ready to serve. This Online Organ Donation Management System will help to

improve the current situation and overcome the problems which arise nowadays.

This system will provide below functionalities:

User must authenticate before allow to access each module in this system

Provide detail information according to training course and allowing public to

make online registration.

Authenticate user can check status of registration application.

Report can be generating from the system either in textual or graphical form