Database Management System for Housing (A Case Study of Abdu Gusau Polytechnic Talatamafara)

ABSTRACT

Overtime, manual approach of managing house allocation is being employed which has resulted in a lot of problems in Abdu Gusau Polytechnic Talata Mafara zamfara State. These problems to mention few are, allocation of already allocated apartment due to lack of proper record, difficulty in calculating the general statistics, poor data security and integrity among others. These aforementioned problems are talked with this new system by providing accuracy in general statistics, proper keeping of record. The basic objectives of designing and implementing of house allocation system is to develop a computer program that will enable the allocation and record keeping of the house allocation efficiently, accurately and effectively. The system will interact with the existing system and provide a real time status of the processing of the result using HTML, CSS and PHP as frontend while MYSQL database for backend.

TABLE OF CONTENTS

Title page………………………………………………………………………I

Declaration……………………………………………………………………ii

Certification (approval page) …………………………………………………iii

Dedication……………………………………………………………………iv

Acknowledgement……………………………………………………………. v

Abstract………………………………………………………………………vi

Table of contents……………………………………………………………. vii

CHAPTER ONE: - General Introduction

1.1             Introduction…………………………………………………………...

1.2       Statement of the Problem…………………………………………….

1.3       Significance of Study…………………………………………………

1.4       Aims and Objectives………………………………………………….

1.5       Scope of the Study…………………………………………………….

1.6       Limitation of the Study………………………………………………...

1.7      Definition of terms…………………………………………………….

CHAPTER TWO: - Literature Review

2.1       Information system……………………………………………………

2.2       Concept of database system………………………………………….

2.2.1    Types of Houses………………………………………………………

2.3       Information System………………………………………………….

2.4       Information Retrieval…………………………………………………

2.5       The Need for Data Computerization…………………………………

2.6        Benefits of Computerization……………………………………….

CHAPTER THREE: - Analysis of the Existing System

3.1       Research Methodology ………………………………………………

3.2       Analysis of the Existing System………………………………………

3.3       Problems of the Existing System…………………………………….

3.4       Description of the Proposed System…………………………………

3.5       Advantages of the Proposed System…………………………………

CHAPTER FOUR: - Design, Implementation and Documentation ofthe System

4.1       Design of the System……………………………………………….

4.1.1    Output Design……………………………………………………….

4.1.2    Input Design………………………………………………………….

4.1.3    Database Design…………………………………………………….

4.1.4    Procedure Design…………………………………………………….

4.2       System Implementation…………………………………………….

4.2.1    Choice of Programming Language Used……………………………

4.2.2    Hardware Support……………………………………………………

4.2.3    Software Support………………………………………………….

4.2.4    Implementation Techniques Used in Details…………………….

4.3       System Documentation…………………………………………….

4.3.1    Program Documentation………………………………………….

4.3.2    Operating the System……………………………………………

4.3.3    Maintaining the System                  

CHAPTER FIVE: - Summary, Conclusion and Recommendation

5.1       Summary……………………………………………………….

5.2       Conclusion………………………………………………………

5.3       Recommendation……………………………………………….

5.4       Reference……………………………………………………….

Appendix (A) Flowchart……………………………………………….

Appendix (B) Source Code……………………………………………

Appendix (C) Output…………………………………………….