Souvenir Purchasing System

BORANG PENGESAHAN STATUS TESIS JUDUL: SOUVENIR PURCHASING SYSTEM

SESI PENGAJIAN: 2008/2009

Saya ADIBAH BT AHMUD PUAT @, AHMAD FUAD (HURUF BESAR)

mengaku membenarkan tesis (PSM/Sarjana/Doktor Falsafah) ini disimpan di Perpustakaan Fakulti 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 pengajian tinggi.

4.

**

Sila tandakan

(0

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

TERHAD (Mengandungi maklumat TERHAD yang telah dietntukan oleh organisasihadan di mana penyelidikan dijalankan)

TIDAK TERHAD

(TANDATANGAN PENULIS)

Alamat tetap: L O 7 133- GLic ttl L L b A R l

I % . ~ J o K O A L A KK,@d, Narna Penyelia

VA*~

M6HT4R

~ E L A I \ I T A N DAWUL N A \ N

Tarikll:

SOUVENIR PURCHASTNG SYSTEM

ADIBAH BT AHMUD PUAT @ AHMAD FUAD

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

DECLARATION

I hereby declare that this project report entitled SOUVENIR PURCHASING SYSTEM

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

STUDENT:

&-

Date: a5.06. w o 9

(ADIBAH BT AHMUD PUAT @ AHMAD FUAD)

SUPERVISOR: Date:

as-6.=O-q'.

DEDICATION

ACKNOWLEDGEMENTS

Bismillahirahmanirrahim

Praise to Allah for giving me strength and patience to complete the Projek Sarjana Muda throughout these semester.

To my beloved parents Mr. Ahmad Fuad bin Zainal Abidin and Mrs. Hanifah bt Hassan, who give me full support morally and economically, motivate and inspire me during the hard time to complete this project.

To my supervisor, Mrs. Syahida bt Mohtar who guide, assist and advice me all the way through this project.

ABSTRACT

ABSTRAK

TABLE OF CONTENTS

CHAPTER SUBJECT

DECLARATION DEDICATION

ACKNOWLEDGMENTS

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

PAGE

1.4 Scope

1.5 Project Significance 1.6 Expected Output 1.7 Conclusion

CHAPTER I1 LITERATURE REVIEW AND PROJECT METHODOLOGY

2.1 Introduction 7

2.2 Facts and Findings 8

2.2.1 Domain 8

2.2.2 Existing System 9

2.2.3 Technique 12

2.3 Project Methodology 13

2.4 Project Requirements 17

2.4.1 Software Requirements 17

2.4.2 Hardware Requirements 19

2.4.3 Other Requirements 19

2.5 Project Schedule and Milestone 20

2.6 Conclusion 22

CHAPTER I11 ANALYSIS

3.1 Introduction 3.2 Problem Analysis 3.3 Requirement Analysis

3.3.1 Data Requirement 3.3.2 Functional Requirement 3.3.3 Non-functional Requirement 3.3.4 Other Requirement

CHAPTER IV DESIGN

4.1 Introduction

4.2 High-Level Design

4.2.1 System Architecture

4.2.2 User Interface

4.2.2.1 Navigation Design

4.2.2.2 Input Design

4.2.2.3 Output Design

4.2.3 Conceptual and Logical Database Design

4.3 System Architecture

4.3.1 Software Design

. 4.3.2 Physical Database Design

4.4 Conclusion

CHAPTER V IMPLEMENTATION

5.1 Introduction

5.2 Software Development Environment Setup

5.2.1 Software Setup

5.2.2 Database Environment Setup

5.2.3 Hardware Setup

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.1 Test Organization 6.2.2 Test Environment 6.2.3 Test Schedule 6.3 Test Strategy

6.3.1 Classes of Tests 6.4 Test Design

6.4.1 Test Description 6.4.2 Test Data

6.5 Test Result and Analysis 6.6 Conclusion

CHAPTER VII PROJECT CONCLUSION 7.1 Introduction

7.2 Propositions for Improvement 7.3 Contribution

7.4 Conclusion

REFERENCES

BIBLIOGRAPHY

LIST OF TABLES

TABLE TITLE

Development Tools Operating System / Server Database System

Hardware Requirement

Milestone for Project Development Attributes in customer's table Attributes in product's table Attributes in category's table Attributes in shopping cart's table Attributes in order's table

Attributes in order item's table Functional Requirement of SPS Operational Requirement Integrity Requirement Security Requirement Performance Requirement Software Requirement Hardware Requirement

Network Requirement Input Design for Customer Input Design for Admin

Output Design

Data Dictionary for table Customer Data Dictionary for table Product Data Dictionary for table Category Data Dictionary for table Cart Data Dictionary for table Order Data Dictionary for table Order Item Software Setup for SPS

Hardware Setup for SPS

Implementation Status

Test organization

Developer Machine Configuration

Environment Setup Test Schedule

Test Case for Component Login Test Data for Component Login

LIST OF FIGURES

DIAGRAM TITLE PAGE

Malaysian Souvenir.com Main Page Souvenir purchasing process

System Development Life Cycle (SDLC) Data Flow Diagram of the Current System

Data Flow Diagram Level 0 of the Current System Context Diagram for Souvenir Purchasing System DFD Level 0 for SPS

DFD Level 1 of Process 1.0 for SPS DFD Level 1 of Process 2.0 for SPS DFD Level 1 of Process 3.0 for SPS DFD Level 1 of Process 4.0 for SPS DFD Level 1 of Process 5.0 for SPS DFD Level 1 of Process 6.0 for SPS System Architecture of SPS

Shopping Cart Interface Payment Info Interface Admin Log In interface SPS Navigation Design ERD for SPS application 3-Tier System Architecture Connection of MySQL Server

Coding for creating category-update-trigger Coding for creating category-delete-trigger Sample output of the category-audit table data Sample Output to register customer

LIST OF ABBREVIATIONS DBMS DDL DFD ERD HTML IC JAD OOAD PHP RAD RDBMS SCM SDLC SPS SQL SSADM

Database Management System Data Definition Language Data Flow Diagram

Entity Relationship Diagram Hypertext Markup Language Identity Card

Joint Application Development Object Oriented Analysis and Design

Personal Home Pagel Hypertext Preprocessor Rapid Application Development

Relational Database Management System Software Configuration Management System Development Life Cycle Souvenir Purchasing System Structured Query Language

APPENDIX

A: Gantt Chart B: Test Cases C: Test Data D. User Manual

LIST OF APPENDICES

CHAPTER I

INTRODUCTION

1.1 Project Background

E-commerce is getting more and more attention from entrepreneur and consumers, both local and international. By this reason, there is no way people can neglect the improvement of the internet technologies. In the commercial markets, time plays an important role to both the business and consumers. From the business perspective, with less time spent during each transaction, more transaction can be achieved on the same day. As for the consumer, they will save up more time during their transaction. For example, a banking transaction can be completed through the Internet within a few minutes compared to the traditional banking method which may take up to hours.

The modules that are going to be proposed are online catalogue module, user authentication module, shopping cart module and payment process module. All of these modules will cover all the process of purchasing the souvenirs' products.

1.2 Problem Statement

The use of internet technology has become popular among people. The electronic system can gives a lot of benefits in order to handle the task process. Data security is the main reason for the development of this system. The way of managing and securing the data can make the task become easy to deal with.

The problem statements are listed as follows:

Current system not efficient to handle big amount of data

Every day, hours and minutes, there will always some activities that will allow the process of inserting data into the system. So by that, large amount of data will be stored. In some current system, they cannot support the large amount of data to be handled.

Current system cannot manage data systematically

Current system recorded data in a quite non-organized way. It will be a difficulty for customer to view and search data in a faster way.

Lack of data security

Data replication

The current system can cause a lot of possibilities regarding the duplicate data.

1.3 Objective

By developing this system, the objectives of the system have been identified. The objectives are:

Time consuming

To enable the customer to purchase and order the souvenir online; fast and easy way.

Cost saving

Reduce inventory, employees, purchasing costs, order processing costs associated with faxing, phone calls, and data entry, and even eliminate physical stores. Reduce transaction costs.

Secure payment system

From back-end user, the data will be stored and managed in a secured way

1.4 Scope

System Functionality

User authentication module

-

the user authentication is needed to enable the customer to insert the product

into the shopping cart or to make the payment via credit card or etc.

Online catalog module

-

the online catalog module enable the customer to view the list of the souvenir

products

Shopping cart module

-

enable the customer to put the items in the cart and then the software will

calculate the order including the delivery, the shipping and the handling cost.

Transactional module

-

enable the customer to make payment for the purchased products through kinds

of payment such as credit card payment. This module has to deal with the

authorization process

User Functionality

Staff

-

The administer of the company will use this system in order to manage all information in the system. The system will guide the customers to access all

the details needed from the customers and information that can be added for

customer.

Customer

-

The customers are the main person where all the process of the purchasing of

the product will be held. They can access the catalogue and make choices

whether to buy the products and put the item in the shopping cart or not. They

payment.

1.5 Project Significance

This system can improve the existing system. Often the current system quite confusing the customers and this will be a burden to the customers to buy the souvenirs

The features that are available in this system will benefit the Souvenir Purchasing System. This project will help administrator or manager to overcome the problems occurred before. By creating an advanced system which uses MySQL as the Database Management System (DBMS), it will solve many problems because this DBMS can manage data very efficient

Lastly, certain database operations such as backup data from the database can be done using the transactional module.

1.6 Expected Output

By developing the Souvenir Purchasing System, it is hoped to be better than the current system where it will ease the customer when purchasing or ordering the needed souvenir. Plus, this system is expected to save the customer's time and offers them the best management of data with highly secured process where they don't have to worry about losing their money.

of avoiding the data replication and redundant, the integrity and consistency of the data

will be kept by having the quality of database structure.

Another expectation of this project is that it will integrate with MySQL DBMS

which can help organize and store data safely in database. The data also can be migrated

to another DBMS such as SQL server. The data stored in database also can be backed

up. It is to ensure safety of data

1.7 Conclusion

Souvenir Purchasing System is a web-based system where it is being developed

to enhance the weaknesses of the current system. This chapter is about the early view of

what will be in the project from the developer's view. Project background describes the

introduction to the project as a whole. It includes the content of the project, target users

and the importance of the project. The problem statement describes the problems related

to why this project should be developed. From the problem statements, the objectives of

the project can be extracted. The scopes of the project explain the boundary of the

system while the project significance deliver what the system can provide based on

developer site. The expected output reflects the system's ability from user view. The

next chapter will be the literature review and the methodology to be used in developing

CHAPTER I1

LITERATURE REVIEW AND PROJECT METHODOLOGY

2.1

Introduction

The main focus of literature review for Souvenir Purchasing System is to study and understand other system, methodology or approach which this diverse resource will be congregated and use as a guidance to develop a new system. As for this intention, various resources such as internet resources, journals, books, articles and others provide great extent imperative ideas for the foundations. Therefore, the following sub-chapters are facts and findings, domain, existing system, technique, project methodology, project

requirements and as well the project schedule and milestones. With the following amplification, the preliminary ideas will be incorporated into the system but not all.