Rakan LAP

BORANG PENGESAHAN STATUS TESIS

JUDUL: RAKAN LAP

SESI PENGAJLAN: 2008 12009

Saya NUR HANISAH BINTI ZUBIR (HURUF BESAR)

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

1. Tesis adalah hakmilik Universiti Teknikal Malaysia Melaka

2. Perpustakaan Fakulti Teknologi Maklumat dan Komunikasi dibenarkan membuat salinan untuk tujuan pengajian sahaja.

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

4. ** Sila tandakan (/)

SULIT

TERHAD

TIDAK TERHAD

(TANDATANGAN PENULIS)

Alamat tetap: No 73 Jln Hi Wahab, K g Tennah 32800 Parit,

Perak

Tarikh:

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

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

(TANDATANGAN PENYELIA)

En Ariff bin Idris Nama Penyelia

Tarikh:

CATATAN:

*

*

RAKAN LAP

NUR HANISAH BINTI ZUBIR

This report submitted in partial fulfillment of the requirements for the Bachelor of Computer Science (Computer Networking)

FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY UNIVERSITI TEKNIKAL MALAYSIA MELAKA

DECLARATION

I hereby declare that this project report entitled

RAKAN LAP

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

citations.

STUDENT

w .

(NUR HANISAH BINTI ZUBIR)

SUPERVISOR Date:

DEDICATION

ACKNOWLEDGEMENTS

In the name of Allah, Most Benificent, Most mercihl

Praise to Allah for giving me strength and patience to complete the Projek of Sarjana

Muda 1 throughout this semester. Special thanks go to En Ariff Bin Idris, my supervisor

for his invaluable guidance, constructive suggestions and advices throughout this project

that help me to progress through out the system.

I also would like to express my sincere to all my classmate and others collogues for their

support and help in one way or other,

Last but not least, I wish to express my deepest appreciation and heartfelt thanks to my

beloved family and my closest friend for their understanding, motivation, support and

ABSTRACT

Rakan LAP has been developed using Macromedia Dreamweaver MX 2004 as a

graphical user interface and PHP as scripting language. The application used to connect

PHP, MySQL and GSM Modem is Ozeki Message Server. The methodology used in

this system is System Development Life Cycle (SDLC). Rakan LAP is developed to

improve the current inefficient services provided by this organization. This system is

aimed to provide a better complaint system, information system and hopefblly a faster

ABSTRAK

Rakan LAP ialah sebuah sistem yang dibangunkan dengan menggunakan

perisian Macromedia Dreamweaver MX 2004 sebagai antara muka dan PHP sebagai

bahasa pengaturcaraan. Aplikasi bagi menghubungkan PHP, MySQL dan GSM Modem

adalah Ozeki Message Server. Metodologi yang digunakan dalam membangunkan

sistem ini ialah Software Development Life Cycle (SDLC). Sistem ini dibangunkan

bertujuan untuk menjadikan urusan antara pengguna dan pihak Lembaga Air Perak lebih

TABLE OF CONTENTS

CHAPTER SUBJECT

DECLARATION

DEDICATION

ACKNOWLEDGEMENTS

ABSTRACT

ABSTRAK

TABLE OF CONTENTS

LIST OF TABLES

LIST OF FIGURES

LIST OF ABBREVIATIONS

CHAPTER I INTRODUCTION I

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

.

.

xi i

vi i

viii

CHAPTER I1 LITERATURE REVIEW AND PROJECT

METHODOLOGY

2.1 Introduction

2.2 Literature Review

2.2.1 Domain

2.2.2 Keyword

2.2.2.1 LAP (Lembaga Air Perak)

2.2.2.2 SMS

2.2.2.3 GSM

2.2.2.4 Web Server

2.2.3 Previous Research

2.2.3.1 LAP (Current)

2.2.3.2 Sabah State Water

Department

2.2.3.3 Philippine National Police

complaint system via SMS

in Philippine

2.2.3.4 Comparison of the

system

2.2.4 GSM Modem

2.2.4.1 Sony Ericsson W580i

2.2.4.2 ilFegno 3000

2.2.4.3 Siemens GSM Modem

MC-35i GPRS terminal

2.2.4.4 Comparison of GSM

Modem

2.2.5 Scripting

2.2.5.3 Active Server Pages

(ASP)

(PW)

2.2.5.4 Visual Basic (VB)

2.2.5.5 Comparison of Scripting

Language

2.2.6 Web Server

2.2.6.1 Apache

2.2.6.2 Internet Information

Services (11s)

2.2.6.3 Comparison of Web

Server

2.3 Proposed Solution

2.3.1 Project Methodology

2.4 Project Schedule and Milestone

2.5 Conclusion

CHAPTER I11 ANALYSIS 3.1 Introduction

3.2 Problem Analysis

3.2.1 Analysis of Current System

3.3 Requirements Analysis

3 -3.1 Data Requirement

3.4 Functional Requiiement

3.4.1 Non-Functional Requirement

3.4.2 Others Requirement

3.4.2.1 Software Requirement

3.4.2.2 Hardware Requirement

3.4.2.3 Network Requirement

CHAPTER IV DESIGN

4.1 Introduction

4.2 High-Level Design

4.2.1 System Architecture

4.2.2 User Lnterface Design

4.2.2.1 Navigation Design

4.2.2.2 Input Design

4.2.2.3 Output Design

4.2.3 Database Design

4.2.3.1 Conceptual and Logical

Database Design

4.3 Detailed Design

4.3.1 S o h a r e Design

4.3.2 Physical Database Design

4.4 Conclusion

CHAPTER V IMPLEMENTATION

5.1 Introduction

5.2 Software Development Environtment

Setup

5.3 Software Configuration Management

5.3.1 Configuration Environtment Setup

5.3.1.1 MySQL and Apache

Configuration

5.3.1.2 MySQL Connector

Configuration

5.3.1.3 Ozeki Message Server

Configuration

5.3.2 Version Control Procedure

5.4 Implementation Status

CHAPTERVI 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.3.1 Classes Test

6.3.1.1 User Acceptance Test

6.3.1.2 Error Handling Test

6.3.1.3 Security Test

6.4 Test Design

6.4.1 Test Description

6.4.2 Test Data

6.5 Testing and Analysis

6.6 Conclusion

CHAPTER VII PROJECT CONCLUSION

7.1 Observation on Weakness

7.1.1 Test Description

7.1.2 Weakness '

7.2 Proposition for Improvement

7.3 Contribution

xii

References

Bibliography

Appendix A - Gantt Chart Appendix B - Data Dictionary

Appendix C Testing Letter

TABLE

LIST OF TABLE

TITLE

xii

PAGE

Hardware Requirement for LAP website

Software Requirement for LAP website

Hardware Requirement for SSWD website

Software Requirement for SSWD website

Hardware Requirement for PNP website

Software Requirement for PNF' website

Comparison of the system

Comparison of GSM Modem

Comparison of Scripting Language

Comparison of Web Server

Project Duration

I

Project Schedule for PSM I .

Data Model of Registered Customer Table

Data Model of Unregistered Customer Table

Data Model of Staff Table

Data Model of Complaint Table

Software Requirement

Hardware Requirement

Network Requirement

Input Type and Validation Rules for Login Page

xiii

Input Type and Validation Rules for Information Page

Input Type and Validation Rules for Edit Page

Input Type and Validation Rules for Assign Task Page

Input Type and Validation Rules for Send Complaint Page

Input Type and Validation Rules for Change Password Page

List of Version Control Procedure

Implementation Status of Rakan LAP

Test Schedule for Rakan LAP Testing Process

Test design description

Test data for Send Complaint

Test data for Receive Complaint

Test data for Check Bill

Test data for Send Announcement

Test data for Assign Task

Test Result and Analysis for Send Complaint

Test Result and Analysis for Receive Complaint

Test Result and Analysis for Check Bill

Test Result and Analysis for Send Announcement I

xiv

LIST OF FIGURE

FIGURE TITLE

Lembaga Air Perak Homepage

Extreme Methodology Model

Sabah State Water Department Homepage

Philippines National Police Homepage

Spiral Development Model

Sony Ericsson W580

iTegno 3000

Siemens GSM Modem

Waterfall Life Cycle Diagram

Flowchart of Current System

Use Case of the System

3.3 Flow Chart for Rakan LAP

.

4.1 System Architecture

4.2 Navigation Design

4.3 Login Page for admin and user

4.4 Update new information for Admin 4.5 Add new Staff

4.6 Edit current last payment bill and date 4.7 Assign Task to Staff

4.8 Send Complaint

4.9 Change Password

PAGE

Output design for Fail Login

Output Design for Confirmation Message

ERD for Rakan LAP

Information Table

Staff Table

Registered User Table

Unregistered User Table

Complaint Table

Software Development Environment

Appserve Select Component

Apache HTTP Server Information

MySQL Server Configuration

ODBC Data Source Administrator

ODBC Create New Data Source

ConnectorIODBC Configuration

Ozeki Database Plug-In Installation

Ozeki GSM Modem Driver Installation

Ozeki GSM Modem Preferences Configuration I

Ozeki Database Plug-In Preferences Configuration

Ozeki Database Connection String Configuration

Data Link Properties Provider

Data Link Properties Connection

xvi

LIST OF ABBREVIATIONS

LAP

SSWD

PNP

SMS

GSM

SIM

USB

11s

PHP

HTML

HTTP

SDLC

-

Sabah State Water Department

Philippines National Policeg

-

-

-

Universal Serial Bus

Internet Information Server

Persona1 Home Page

Hyper Text Markup Language

Hypertext Transfer Protocol

CHAPTER 1

INTRODUCTION

1.1 Project Background

This project is developed to be used by Lembaga Air Perak (LAP) which is a

semi-government organization in Perak. This organization holds a big responsibility in

managing the water supply service and distribution for Perak citizens. However, LAP

only has a hotline number for their customers to give complaint for the time being.

Besides, citizen in Perak can only check their unpaid bill when they received the bill

receipt at the end of the month. Thus, Rakan LAP is developed to improve the current

inefficient services provided by this organization. This system is aimed to provide a

better complaint system, information system and hopehlly a faster way for customer to

check their unpaid bill.

I

Rakan LAP is designed and developed to provide a better service to the LAP

customer. This system enabled customers to make a complaint or report on any problem

that should be solved by LAP via SMS or browsing through the website. Customers can

make their complaints or report when they spotted any pipe burst, stolen water meters,

disconnection of water supply and any other related problems. The administrator will

determine the location of the existing problem when the system receives complaint from

the customer. Then, admin will instruct LAP staffs on duty for each service centre, zone

or district also via SMS to fix the problem. In this way, the staffs will easily get the

whether the problem has been fixed or not. This technology provides more efficient

ways in settling complaints made by customers as soon as possible.

Besides that, this system also allows customers to perform bill checking via SMS

as well as website. This system will also provide information of LAP services to the

customers via SMS. For instance, customers will be provided with the latest information

on water supply disruption, disconnection of water supply and many more.

1.2 Problem Statement

Nowadays, LAP only provides a hotline number for customer to contact them

when any problem occurs. Based on some researches and interviews, the hotline number

was very difficult to reach and the complaint was not updated and only resolved after a

few days. Sometimes, LAP took a long time to settle a report thus proved the inefficient

system that is used at the moment. This can cause difficulties to customers. Customers

also can only check their unpaid bill charges at the end of the month when the bill

receipt arrive or if it is not received, they need to go to the LAP office to check their bill.

This process will involve many procedures and can cause delay. LAP only gives

information to customers through notice and announce it in the newspaper. It can cause

difficulties to customer if they do not alert when the water supply disruption will be

occurred. Thus, proper system needs to be' developed and implement to ensure that the

1.3 Objective

The purposes of developing Rakan LAP are as follows:

i. To develop a complaint system using PHP and send message using GSM

communication.

ii. To be able to send message over the network. This system must be able to

send message between LAP customer and LAP staff in charge.

iii. To provide information to LAP customers as soon as possible via SMS

and website.

iv. To enable LAP customer to check their unpaid bill charges via SMS and

website.

1.4 Scope

There are four scopes for this system. First and foremost, this system is

developed for LAP customer who wants to make complaint whether they were

registered or not via SMS and website. Thi's system is for registered customer of LAP to

check their unpaid bill charges via SMS and website and to gets latest information about

LAP services. This system will be developed for admin, registered customer and

1.5 Project Significant

The significance of this project is that, it is important to make each customer of

LAP satisfies with services provided by LAP. Thus, this system allows LAP staff to

settle any problem occurs in a short time depending on the complaint made by customer

via SMS or website. This system also allow registered customer to check their unpaid

bill charges via SMS or website.

1.6 Expected Output

There are many expected output for this system. One of the expected output is to

provide LAP customers a faster ways in making complaint and the problem will be

solved as soon as possible. Besides, this system also provides LAP customer a faster

way to check their unpaid bill and gets latest information. Plus, it is expected to be a user

fiiendly system and easier to use.

1.7 Conclusion

This project is basically about develiping a system that allow LAP customer to

makes complaints easier and help LAP to manage all the complaints faster and effective

viaSMS and web. This system can be used by everyone that has accessed to internet and

hand phone. With this system hopefully, it can help satisfy LAP customer.

Henceforth, in the next chapter literature review and project methodology will be

discussed. Literature review will review about the previous system and make a

comparison with this system. It will also discuss the technique used throughout this

CHAPTER I1

LITERATURE REVIEW AND PROJECT METHODOLOGY

2.1 Introduction

This chapter will describe about related literature review, which is very

important for the research and development. It is a glossary or abstract ftom past

researches or case studies and it represents the method of searching, collecting,

analyzing and drawing conclusion about certain topic. In literature review, this project

will be described in detail through fact and finding method. This chapter will focus on

the research of the current, past and new system that will be developed.

Project methodology is very important to make sure the development of the

system is on the track followed by the due date. The methodology should result in a

good quality that meets user expectations, within time, works effectively and as planned

in preliminary stage. In this section, selected approaches or methodologies will help to

describe the activities in every stage.

The next process that needs to be focused after defining methodology is project

schedule and milestones. It acts as a guideline that will help the developer to complete

2.2 Literature Review

2.2.1 Domain

The domain of this application is a complaint system and information system.

This system can benefit the customers of LAP and also to the LAP staff. This

application will be designed to fulfill the needs because of many reasons. The SMS will

be used as the human-machine interaction because of efficiency and well-known

technology that can be used widely. The LAP customer and LAP staff can gives

complaint via SMS or website. Customer also can check their unpaid bill and will be

able to receive any information regarding to LAP services such as water disruption,

cutting of water supply and others via SMS which is more practical. Generally, the

customer and staff may have own mobile phone, so they will get the updates as soon as

possible from the system. The list of benefits to adding the technology to send and

receive SMS into the public is endless.

2.2.2 Keyword

2.2.2.1 LAP

I

LAP stands for Lembaga Air ~ e r a k . It is a semi-government organization that

holds a big responsibility in managing the water supply service and distribution for

Perak citizens.

2.2.2.2 SMS

SMS is an abbreviation for Short Message Service. SMS is a communication