Download house rental management system and more Study Guides, Projects, Research Information Technology in PDF only on Docsity!
MURANG’A UNIVERSITY OF TECHNOLOGY
PROGRAMMING AND DATABASE PRACTICUM
GORDON OTIENO
SC212/1269/
HOUSE RENTAL MANAGEMENT PORTAL
REPORT
Abstract We are stuck with technology when what we really want is just stuff that works. With the current paradigm shift in technological field, there is an urgent need to embrace and appreciate the power of technology. Housing sector remains vigilant to face the challenges of change by employing a new strategy that facilitates easy management of rental houses. Hence there is need to develop a rental house management system that can simplify work for the rental managers so that all their work can be efficient and effective. The Rental Management System is Searching in Based on the Apartment Paying Guest, Office, House in metropolitan cities. The Rental Management System is Based on the Owners and the Customers. The Owner is updated on the Apartment, Office details, House, Paying Guest details. The Customer is details about the Room space, Room rent and the Address Details also. The Rental Management System is best Suitable the owners because time save and the only contact and the eligible person and there is no need to explain the room details on the speak. The Rental Management System is best application in the city place The customer contact and the easily search and the suitable place of Apartment, Office, PG, House and based the Money, Limit Person is based on the suitable house. The Rental Management System is save the time also. The Rental Management System is used to easily identify the suitable place in Save time, cost also. The Rental Management System is best way to search the house, Apartment office, Paying Guest. Hence this system is best applicable for the above reasons making House rental an easy process through an online system Acknowledgement At the beginning I am very much grateful to almighty God for giving me strength and opportunity and sound mind to complete the House Rental Management report. I want to bid my heartiest thanks to my Lecturer, Dr. Tirus, for guiding and giving me the opportunity to initiate this report. Then I want to thank Jionme Real Estate Ltd for giving me the opportunity to do my research in their organization. Thanks again to my colleagues Thomas, Joseph and Steve Amani without forgetting the 3 Idiots Team.I would also like to thank Murang’a University for their library and internet facilities from where I got enormous information.
Table of Content
- Abstract
- CHAPTER ONE
- Introduction.................................................................................................................................
- 1.1 Problem Statement
- 1.2 Background
- 1.2.1 How House Rental Services Work
- 1.2.2 Benefits of Online House Rental Services
- 1.3 Aims & Objectives
- 1.4 Purpose, Scope and Applicability:
- 1.4.1 Purpose
- 1.4.2 Scope
- 1.4.3 Applicability
- CHAPTER TWO
- SURVEY OF TECHNOLOGIES
- 2.1 About PHP
- 2.4 Connecting PHP Application to MySQL Database.............................................................
- 2.5 Introduction to MySQL:
- Basic administration (supervisory level)
- General management (functional level)
- Strategic management
- CHAPTER THREE
- REQUIREMENTS AND ANALYSIS
- 3.1 HARDWARE & SOFTWARE REQUIREMENT
- 3.1.1 HARDWARE:
- 3.1.2 SOFTWARE:
- 3.2 Functional Requirements
- 3.3 Non-Functional Requirements
- 3.4 CONCEPTUAL MODELS
- Data Flow Diagram (DFD)
- Functions of Customer:
- Functions of System Administrator........................................................................................
- Functions of Landlord:
- USE-CASE DIAGRAMS
- Actor and Use Case Description
- Use Case Diagram
- Use-Case Dependency Diagram
- Class Diagram
- CHAPTER FOUR
- SYSTEM DESIGN
- Tenant Registration Module
- House Listing Module
- LANDLORD REGISTRATION MODULE
- SALE HOUSE MODULE
- POST HOUSE.......................................................................................................................
- Book House...........................................................................................................................
- Contact and feedback
- ADMIN LOGIN MODULE
- Manage pages
- Security
- The staffs’ password must be greater than eight characters. The system provides username and password to prevent the system from unauthorized access.
- Test Cases Design
- CHAPTER FIVE.......................................................................................................................
- IMPLEMENTATION AND TESTING
- 5.2 TESTING
- 5.3 Installation and project description
- CHAPTER
- CONCLUSION
- 6.2 Limitation of the system
- 6.3 REFERENCES
- Books Used:
- References Used:
- GLOSSARY
- ER diagram Figure Table of figures
- Level 0 DFD diagram for House Rental management system Figure
- Figure 3Level 1 DFD of Online House Rental System
- Figure 4: Use Case Diagram
- Figure 5Dependency Use Case Diagram
- Figure 6 Class Diagram
CHAPTER ONE
Introduction
1.1 Problem Statement
House Rental is a house/Apartment/home that can be used temporarily for a fee during a specified period. The individual who needs a house must contact a rental car company and contract out for a room/home/apartment. This system increases customer retention and simplify House and staff management.
1.2 Background
1.2.1 How House Rental Services Work
A House rental is a house that can be used temporarily for a period of time with a fee. Renting a house assists people to live in a comfortable house when they do not have access to build their own personal homes/houses or. The individual who want to rent a house/room/apartment/home must first contact the House rental company for the desire House/Home/apartment. This can be done online. At this point, this person has to supply some information such as; dates of rental, and type of house. After these details are worked out, the individual renting the house must present a valid Identification Card. Most companies throughout the industry make a profit based of the type of house that are rented. The rental houses are categorized into modern Homes, Colonial, apartment, Rentals etc. And customers are free to choose any house of their choice based on their purse and availability of such houses at the time of booking.
1.2.2 Benefits of Online House Rental Services
- This online house rental solution is fully functional and flexible.
- It is very easy to use.
- This online House rental system helps in back office administration by streamlining and standardizing the procedures.
- It saves a lot of time, money and labor.
1.4.2 Scope This project traverses a lot of areas ranging from business concept to computing field, and required to perform several researches to be able to achieve the project objectives. The area covers include:
- Real Estate Company: This includes study on how the Real Estate business is being done, process involved and opportunity that exist for improvement.
- PHP Technology used for the development of the application.
- General customers as well as the company’s staff will be able to use the system effectively.
- Web-platform means that the system will be available for access 24/7 except when there is a temporary server issue which is expected to be minimal.
- Existing Systems: This involves studying the existing systems and learning their weakness hence developing a new system to cater for the challenges the local and world domains faces when dealing with house rental issues. 1.4.3 Applicability House Rental is a house/Apartment/home that can be used temporarily for a fee during a specified period. The individual who needs a house must contact a House Rental Owners Through House rental Online System by first checking the available Houses, booking it then The system will contact the house owners to check the House and contract out for a room/home/apartment. This system increases customer retention and simplify House and staff management. The System can be used by Real Estate Companies to increase the house rental market around the world. The system will also help people to rent apartments/houses easily instead of walking and manually renting houses. It is also applicable for landlords who wants to expand their house rental business.
CHAPTER TWO
SURVEY OF TECHNOLOGIES
2.1 About PHP
PHP: Hypertext Pre-processor is a widely used, general-purpose scripting language that was originally designed for web development to produce dynamic web pages. For this purpose, PHP
code is embedded into the HTML source document and interpreted by a web server with a PHP processor module, which generates the web page document. As a general-purpose programming language, PHP code is processed by an interpreter application in command-line mode performing desired operating system operations and producing program output on its standard output channel. It may also function as a graphical application. PHP is available as a processor for most modern web servers and as standalone interpreter on most operating systems and computing platforms. PHP was originally created by Rasmus Lerdorf in 1995 and has been in continuous development ever since. The main implementation of PHP is now produced by the PHP Group and serves as the de facto standard for PHP as there is no formal specification. PHP is free software released under the PHP License. PHP is a general-purpose scripting language that is especially suited to server-side web development where PHP generally runs on a web server. Any PHP code in a requested file is executed by the PHP runtime, usually to create dynamic web page content. It can also be used for command-line scripting and client-side GUI applications. PHP can be deployed on most web servers, many operating systems and platforms, and can be used with many relational database management systems. It is available free of charge, and the PHP Group provides the complete source code for users to build, customize and extend for their own use. Originally designed to create dynamic web pages, PHP now focuses mainly on server side scripting, and it is similar to other server-side scripting languages that provide dynamic content from a web server to a client, such as Microsoft's Active Server Pages, Sun Microsystems’ Java Server Pages, and mod_perl. PHP has also attracted the development of many frameworks that provide building blocks and a design structure to promote rapid application development (RAD). Some of these include CakePHP, Symfony, Code Igniter and Zend Framework, offering features similar to other web application frameworks.
2.2 PHP Syntax:
HTML and PHP code is written on the same page, and to distinguish PHP code from HTML, the PHP code is enclosed within Tags. For example:
$db=mysql_select_db("databasename",$con); Prepare a sql query to execute: $qry= Select * from abc; Run the sql query: $result=mysql_query($qry); Iterate over the result: while($row = mysql_fetch_array($result)) { //some logic }
2.5 Introduction to MySQL:
MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. MySQL is officially pronounced ("My S-Q-L"), but is often pronounced ("My Sequel"). It is named for original developer Michael Widenius's daughter My. The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL is owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Sun Microsystems, a subsidiary of Oracle Corporation. MySQL code uses C and C++. The SQL parser uses yacc and a home-brewed lexer, sql_lex.cc. MySQL works on many different system platforms, including AIX, BSDi, FreeBSD, HPUX, i5/OS, Linux, Mac OS X, NetBSD, Novell NetWare, OpenBSD, OpenSolaris, eComStation, OS/ Warp, QNX, IRIX, Solaris, Symbian, SunOS, SCO OpenServer, SCO UnixWare, Sanos, Tru and Microsoft Windows. A port of MySQL to OpenVMS also exists. All major programming languages with language-specific APIs include Libraries for accessing MySQL database. In addition, an ODBC interface called MyODBC allows additional programming languages that support the ODBC interface to communicate with a MySQL database, such as ASP or ColdFusion. The HTSQL - URL based query method also ships with MySQL adapter allowing direct interaction with MySQL database from any web client via structured URLs. The MySQL server and official libraries are mostly implemented in ANSI C/ANSI C++.
2.6 Introduction to APACHE SERVER:
In this project apache server is used to parse and execute PHP pages, before deploying websites on the server, the website should be tested at the developer side to get a feel of how the website will work on actual server. Therefore apache server is like a local server on the developer side, apache server should be informed about the environment on which it should work. In our project apache server is configured to work with PHP, in this way all the PHP pages are parsed and executed by the server. When apache is installed on the system, then its services is controlled by apache service monitor. The following are the database entities used in this system; Houses : House information, Rental or sale/Buy agreement administration, credit control, cash flow control, compatibility with accounting principles and practices and existing systems, accurate bookkeeping, owner reporting and identifying of key performance indicators. Tenant : general tenant information (name and contact details), finding space for a tenant, accurate rent billing and collection, handling of payments, accounting and general ledger (GL) functions. Landlord, Client or Body Corporate: general details (name and contact details), shareholding if applicable. Basic administration (supervisory level) Repair and maintenance schedules are required by the House manager, as well as a diary to “flag” important dates for tenant’s works, rent review and lease renewal dates. A good software program should also provide for a forward planning facility. General management (functional level) Aptly summarises the requirements at this level as follows: “In terms of accounting procedures, the main property management related tasks will comprise
- Rent invoicing and income connection
- Recovery of expenditure
- Disbursements/outgoings
- Service charge costing and apportionment
- Client and tenant accounts
Front end PHP Text Editor Notepad++ 3.2 Functional Requirements Requirement analysis is a software engineering technique that is composed of the various tasks that determine the needs or conditions that are to be met for a new or altered product, taking into consideration the possible conflicting requirements of the various users. Functional requirements are those requirements that are used to illustrate the internal working nature of the system, the description of the system, and explanation of each subsystem. It consists of what task the system should perform, the processes involved, which data should the system holds and the interfaces with the user. The functional requirements identified are: Customer’s registration: The system should allow new users to register online. Online reservation of House: Customers should be able to use the system to make booking and online reservation. Automatic update to database once reservation is made or new customer registered: Whenever there’s new reservation or new registration, the system should be able update the database without any additional efforts from the admin. Feedbacks to customers: It should provide means for customers to leave feedback. 3.3 Non-Functional Requirements It describes aspects of the system that are concerned with how the system provides the functional requirements. They are: a. Security : The subsystem should provide a high level of security and integrity of the data held by the system, only authorized personnel of the company can gain access to the company’s secured page on the system; and only users with valid password and username can login to view user’s page. b. Performance and Response time: The system should have high performance rate when executing user’s input and should be able to provide feedback or response within a short time span usually 50 seconds for highly complicated task and 20 to 25 seconds for less complicated task. c. Error handling: Error should be considerably minimized and an appropriate error message that guides the user to recover from an error should be provided. Validation of user’s input is highly essential. Also the standard time taken to recover from an error should be 15 to 20 seconds. d. Availability: This system should always be available for access at 24 hours, 7 days a week. Also in the occurrence of any major system malfunctioning, the system should be available in 1 to 2 working days, so that the business process is not severely affected
3.4 CONCEPTUAL MODELS
ER diagram ER diagram is a graphical representation of a system entities their attributes and the relationship between them as shown in the figure below ER diagram Figure 1 Data Flow Diagram (DFD) A Data Flow Diagram (DFD) is a graphical representation that depicts the information flow and the transforms that are applied as data moves from input to output. Level 0 DFD diagram for House Rental management system Figure 2
Figure 3 Level 1 DFD of Online House Rental System USE-CASE DIAGRAMS Actor and Use Case Description Actor and use case description shows the detail description of interaction between the actors and their use cases. The description enables to have a proper understanding of how actor interacts with the system through their use cases. Actor Use Case Use Case Description Customer Register member as This use case describes the activities of the customer to register online and become a member. Customer's details are required as part of the registration. Customer chooses his login details by entering user name and password registration. House Details HO US E
Make reservation This use case enable customer to search and make reservation. Non-register customer will be directed to register before their reservation can be confirmed. Notification is automatically send to the customer after the task is completed. Account management This use case describes the event of customer setting his account and viewing his bookings. Give feedback And testimonies and subscription This use case is used by the customer to provide feedbacks and Testimonies to the company; The user also subscribes to the news feeds to automatically get news on the available houses. a confirmation notification will be send to the customer once a feedback has been submitted. Landlord Add new House This use case is used by the landlords to add new and vacant house for rent or sale to the company's fleet database. Landlord will needed to login to activate this use case. Update House details This use case is used by the Landlord to edit and modify House details whenever there is new renewal (images, fees). It allows the company to keep up-to-date records of their fleet Reply to customer’s feedback This use case describes the event by which Landlords sends reply to customer's earlier feedback. It depends on `give feedback' use case from the customer. Process rental This use case described the event by which landlord updates the system when customer take the house Admin Add new landlord This use case describes the event by which Admin add new landlord detail to the company's landlord database. It is invoke whenever a new landlord join the company. View report This use case is used by the Admin to view transaction report. Post House This use case is used by admin to add/edit new house Manage pages This use case allows admin to manage system pages by either adding,deleting or editing Manage Testimonies This use case allows admin to view and manage Customers Testimonies Manage Bookings This use case describes the event by which admin views and confirm house bookings from the customer and the send the customer a confirmation message
Use-Case Dependency Diagram Figure 5 Dependency Use Case Diagram
Class Diagram
Figure 6 Class Diagram Reply to customer's feedback View transaction report View customer’s details Give feedback/ comments Update House details Process rental Register as Member Add new House Make reservation To-Date View report Contract House r Renew House contract From Date <> <> Depends on <> <> Depends on <> <>
CHAPTER FOUR
SYSTEM DESIGN
Tenant Registration Module
This module allows Tenants or the system users to register and log in in case they want to make any inqueries in the system
