Home rental and relocation services system

FACULTY OF ECONOMIC SCIENCE & MANAGEMENT
DEPARTMENT OF INFORMATION SYSTEM &
MANAGEMENT

Academic year 2011-2012

A dissertation submitted in partial fulfillment of academic requirement for the award of a Bachelors Degree in Information (Systems and) Management

Under the guidance of

Pierre Celestin ZIRARUSHYA

REPUBLIC OF RWANDA
INDEPENDENT INSTITUTE OF LAY ADVENTISTS
OF KIGALI (INILAK)
BP. 6392 Kigali, Rwanda

HOME RENTAL AND RELOCATION

SERVICES SYSTEM

submitted by

Alphonse MINANI Reg. No : 00606/2009

October 2012

DECLARATION

I, Alphonse MINANI hereby declare that the project report entitled «HOME RENTAL AND RELOCATION SERVICES SYSTEM» submitted in partial

Fulfillment of the requirement for the award of the degree of Bachelors Degree in Information (Systems and) Management is a record of bonafide project work carried out by myself under the supervision of Pierre Celestin

ZIRARUSHYA. I further declare that the work reported in this project has not been submitted, either in part or in full, for the award of any other degree or diploma in this institute or any other institute or university.

Kigali

Date: October 2012 Alphonse MINANI

INDEPENDENT INSTITUTE OF LAY ADVENTIST OF KIGALI

(INILAK)

B.P. 6392 KIGALI, Tél: [phone]

E-mail: [e-mail]
Website: www.inilak.ac.rw

BONAFIDE CERTIFICATE

This is to certify that the project report entitled «HOME RENTAL AND RELOCATION SERVICES SYSTEM «submitted by Alphonse MINANI Reg.No00606/2009 to Independent Institute of Lay Adventists of Kigali in partial fulfillment of the requirement for the award of the degree of Bachelors degree in Information (Systems and) Management is a record of bonafide work carried out by him under my supervision.

Pierre Celestin ZIRARUSHYA Pierre Celestin ZIRARUSHYA

SUPERVISOR HEAD OF DEPARTMENT

October 2012 October 2012

Accredited by the Ministerial Order No 002/09 0f 09/04/2009 granting the Definitive Operating License

DEDICATION

The Almighty God

II

ACKNOWLEDGEMENT

The satisfaction that accompanies the successful completion of any task would be incomplete without the mention of people whose ceaseless cooperation made it possible, whose constant guidance and encouragement crown all efforts with success.

We are grateful to our project supervisor Mr. Pierre Celestin ZIRARUSHYA for the guidance, inspiration and constructive suggestions that helped us in the preparation of this project.

We make a mention in special recognition of our parents, brothers, sisters and all relatives for the material, moral and financial support.

We appreciate friends for untiring encouragement.

We are deeply indebted to the help got from Emmanuel MUHIRWA and François GASHABIZI'S Family

We are beholden to all our classmates for their positive contribution to the accomplishment of this work.

May God still keeping you all in his safe hands and help you in the continuous and better accomplishment of your daily tasks.

Kigali

October 2012 Alphonse MINANI

iii

TABLE OF CONTENTS

DEDICATION i

ACKNOWLEDGEMENT ii

TABLE OF CONTENTS iii

LIST OF TABLES vi

LIST OF FIGURES vii

ACRONYMS ABBREVIATIONS AND NOMENCLATURE viii

ABSTRACT x

CHAPITER ONE: GENERAL INTRODUCTION 1

1.1 INTRODUCTION 1

1.2 BACKGROUND 2

1.3 PROBLEM STATEMENT 2

1.4. MOTIVATION 2

1.5 OBJECTIVES 3

1.5.1 General Objectives 3

1.5.2 Specific Objectives 3

1.6 CHALLENGES 3

1.7 ESSENCE OF OUR PROJECT 4

1.8 SCOPE OF OUR STUDY 4

1.9 STATEMENT OF ASSUMPTION 4

1.10 EXPECTED RESULTS 4

CHAPTER TWO: LITERATURE REVIEW 7

2.1 GENERAL INTRODUCTION 7

2.2 SPECIFIC TERMINOLOGY 7

2.2.1 System Analysis and design 7

2.2.2 Computer Software 8

2.2.3 Database concepts 9

2.2.4 Data Modelling 10

2.2.6 Data warehouse 12

2.2.7 Client/Server architecture 13

iv

2.2.8 Tools, techniques and languages used developing software 14

2.3 COMPARATIVE STUDY 16

2.3.1 Online Application for Residential Information System 16

2.3.2 Management System of Rooms And Restaurant. 16

2.4 PERSONAL CONTRIBUTION 16

CHAPTER THREE: ANALYSIS OF THE EXISTING SYSTEM 17

3.1 INTRODUCTION 17

3.2 BACKGROUND OF INTERNATIONAL ORGANIZATIONS STUDIED 17

3.3 VISIONS AND MISSIONS 18

3.4 LIMITATION OF CURRENT SYSTEM 19

3.5 EXISTING SYSTEM 19

CHAPTER FOUR: ANALYSIS AND DESIGN OF THE PROPOSED SYSTEM 21

4.1 INTRODUCTION 21

4.2 SOFTWARE DEVELOPMENT MODEL 21

4.2.1 Software Development Life Cycle Model 21

4.3 STUDY OF NEW SYSTEM 22

4.4 STRUCTURAL DIAGRAM 23

4.4.1 Function Diagrm 23

4.4.2 Data Flow Diagram 24

4.4.4 Context diagram 24

4.5 WAYS OF RECORDING INFORMATION 28

4.5.1 Entity Relationship Diagram 28

4.5.2 Designing the ERD 28

4.5.3 Entity Relationship Diagram 29

4.6 CONCEPTUAL MODEL OF DATA 30

4.7 LOGICAL DATA MODEL 31

4.8 THE CONCEPTUAL LEVEL 31

4.8.1 The Treatment Conceptual Model 31

4.8.2 Treatment Conceptual Model for House information 33

4.8.3 Treatment Conceptual Model for confirming registration 33

4.8.4 Treatment Conceptual Model for services information 34

4.9 DATA DICTIONARY 34

V

4.10 ORGANIZATIONAL MODEL OF PROCESS 36

4.11 PHYSICAL DATA MODEL 38

4.12 ADVANTAGE OF THE NEW SYSTEM 39

CHAPTER FIVE: IMPLEMENTATION OF THE NEW SYSTEM 40

5.1INTRODUCTION 40

5.2 System Design 40

5.3 The system implementation 44

5 .4 Verification of Hypothesis 44

CHAPTER SIX: FUTURE ENHANCEMENT 45

6.1 CONCLUSION 45

6.2 RECOMMENDATION 45

REFERENCES 46

BOOKS AND PUBLICATIONS 46

DOCUMENT AND REPORT 46

ELECTRONIC REFERENCES 46

APPENDIES 47

APPENDIX 1: OARIS-DFD level zero A

APPENDIX 2: ERD-Management System of Rooms and Restaurant B

vi

LIST OF TABLES

Table 1: Cardinalities 30

Table 2: HRRSS Data dictionary 36

Table 3: Organizational Model of Process 38

vii

LIST OF FIGURES

Figure 1: Role of data warehouse 13

Figure 2: Client /Server architecture 14

Figure 3: software development life cycle 22

Figure 4: HRRSS Function diagram 23

Figure 5: HRRSS Context diagram 25

Figure 6: DFD level 0 for whole HRRSS 26

Figure 7: DFD Level 1 for User Management of HRRSS 26

Figure 8: DFD Level 1 for User Management 26

Figure 9:DFD Level 1 for Service Management 27

Figure 10: DFD Level 1 for House Management of HRRSS 27

Figure 11:DFD Level 1 for House Management 27

Figure 12: Entity Relationship Diagram for HRRSS 29

Figure 13: Treatment Conceptual Model for House information 33

Figure 14: Treatment Conceptual Model for confirming registration 33

Figure 15: Treatment Conceptual Model for services information 34

Figure 16: Physical Data Model 39

Figure 17: HRRSS database 40

Figure 18: HRRSS login form with data 41

Figure 19: Rcord of services(Club of language teach) 41

Figure 20: HRRSS House information record 42

Figure 21: Form for checking details of any service 42

Figure 22: Report of house and services on a location 43

Figure 23: Report of Expatriate, house and owner on a location 43

Figure 24: OARIS-DFD level zero A

Figure 25: ERD-Management System of Rooms and Restaurant B

VIII

ACRONYMS ABBREVIATIONS AND NOMENCLATURE

4NF : Fourth Normalization form

ASP : Active Server Page

CGI : Common Gateway Interface

CMD : Conceptual Model of Data

CSS : Cascading Style Sheet

DB : Data Base

DBMS : Data Base Management System

DFD : Data Flow Diagram

E-R : Entity Relationship

ERD : Entity Relationship Diagram

ERDM : Entity Relationship Data Model

FTP : File transfer Protocol

HRRSS : Home Rental and Relocation Services System

HTML : Hypper Text make-up Language

HTTP : Hypper Text Transfer Protocol

IMAP : Internet Message Access Protocol

INILAK : Independent Institute of Lay Adventist Of Kigali

ISM : Information System Management

LAN : Local Area Network

NNTP : Network News Transfer Protocol

NOS : Network Operating System

NUR : National University of Rwanda

OMP : Organizational Model of Process

PC : Personal Computer

PDM : Physical Data Model

PHP : Personal Home Page or Hypertext Preprocessor

POP3 : Post Office Protocol

SNMP : Simple Network Management Protocol

SQL : Structured Query Language

ix

SSL : Secure Sockets Layer

URL : Universel Resource Locator

VBScript : Visual Basic Script

WWW : World Wide Web

XAMPP : X Apache, MySQL Perl and PHP

X

ABSTRACT

In Rwanda there are not any company that can facilitate new coming people to locate homes and other basic services. When an expatriate arrive in Rwanda is obliged to leave in a hotel while looking for a home. This expatriate take long time for getting the needed home and relocation services. That's why the introduction of new system for home rental and relocation services is most important and necessary. The analysis of old system, making an interview to people who work in international organization can be a help for design the system. This system will allow locating and rent house anywhere the user will be. The user will also locate services.

1

CHAPITER ONE: GENERAL INTRODUCTION

1.1 INTRODUCTION

Kigali as other cities in the world is being extended and many houses are constructed. People visit and get are deployed in and also need to rent houses or to get some services. It is still difficult to find a good house in short time and know exactly where to find these or those services.

The main object of this project is to develop and implement a web based application called «a home rental and relocation services system » in order to implement a web based property management system to help International organizations to provide reliable services to its expatriate employees.

The methodology used was «software development life cycle model» because it is very simple to understand and use. In a software development life cycle model, each phase must be completed in its entirety before the next phase can begin. At the end of each phase, a review takes place to determine if the project is on the right path and whether or not to continue or discard the project.

The first activity in development phase was to study the existing system; this helped in understanding the real needs of expatriate.

The second activity carried out was actually the design of system; the goal of this phase was to produce a model or representation that was going to be used to build the new system.

The third activity in the development part was the coding phase. The aim of this phase was to translate the design into the code in php, xml and action script programming language.

The final activity was to test the system in order to find out if it meets all specified requirements.

After this, we verified and confirmed the hypothesis that our application can be used improved to provide quick and best services.

2

Recommendations have also been suggested for further research to enhance, revise and add more functionality to the prototype developed here.