Real Estate Management System: Analysis, Design, and Implementation

This report details the design and implementation of a web-based Real Estate Management System (REMS). The system aims to streamline property management for agencies and clients. The report includes an executive summary, introduction, background study, problem statement, objectives, and justification for the project. It outlines the system's scope, limitations, and compares the proposed system with existing ones. The document features organizational and system flowcharts, data flow diagrams, an ER diagram, and discusses non-financial and financial attributes, system features, and technology platforms. It addresses user views, potential data breaches and security risks, and suitable accounting controls. The REMS offers functionalities such as property searching, rent management, and report generation, with a focus on security and user-friendly interfaces, making it accessible to agents and clients through web and mobile platforms. The system's goal is to improve efficiency, reduce costs, and enhance data security in real estate operations.

REAL ESTATE MANAGEMENT SYSTEM 1
Real Estate Management System
First Student Name
Second Student Name
Third Student Name
Course
Institution

REAL ESTATE MANAGEMENT SYSTEM 2
Executive Summary
The Real Estate Management System will be designed to be web-based with integration
capabilities of being an app whereby multiple users will have different privileges as far as
accessing information and information management is concerned. In particular, the admin will
have the rights to update information, add other users and delete users among other overall roles.
Furthermore, the system will play a vital role in meeting all the expectations of companies
dealing with developing apartments, commercial assets, guesthouses, and residential properties
among other assets involving leasing, renting, and even selling of the same possessions.
This system will have a portal where all the information concerning clients and the entire
property scale will be saved in a secure database. Unlike other existing systems where the admin
was the only one with management roles, agents will also have a privilege to access and update
certain information on the system. Time management will be well taken care of both on the side
of the property owner and clients since there will be no need for mediators as seen in current
systems. This is due to the fact that mediators are known for unsanctioned agreements that in
most cases costs a lot and are more time-consuming.
Integration capabilities will be assured when a company decides to go for a mobile
application instead of a website. This will be an easy and convenient way for many people and
even those without computers. Unlike other systems, therefore, the Real Estate Management
System (REMS) comes with a functionality of searching a property by location or area code
depending on the choice of the client. In fact, security of information about the users of this
system will be prioritized due to the authentications that will be put in place which replicates to
trust and confidence from both the clients and the company itself.
Table of Contents

REAL ESTATE MANAGEMENT SYSTEM 3
Executive Summary...................................................................................................................................2
Introduction...........................................................................................................................................4
Background of the Study.......................................................................................................................4
Statement of the Problem......................................................................................................................5
General Objectives................................................................................................................................6
Specific Objectives.............................................................................................................................6
Justification of the Study.......................................................................................................................6
System Scope..........................................................................................................................................7
System Limitations................................................................................................................................7
Existing System......................................................................................................................................7
Proposed System....................................................................................................................................7
Advantages of the Proposed System.................................................................................................8
Organizational Chart............................................................................................................................8
System Flow Chart................................................................................................................................9
Property Management Flow Diagram...........................................................................................10
Rent Management Flow Diagram..................................................................................................11
Report Generation Flow Diagram..................................................................................................12
System Data Flow Diagrams...............................................................................................................12
Level O DFD....................................................................................................................................12
Level 1 DFD.....................................................................................................................................13
ER Diagram.........................................................................................................................................14
Non-Financial Attributes................................................................................................................14
Financial Entities.............................................................................................................................15
System Features...................................................................................................................................16
Technology Platform of the System....................................................................................................17
User Views............................................................................................................................................17
Potential Data Breaches and Security Risks Associated with the System.......................................18
Suitable Accounting Controls for the New System.......................................................................19
Conclusion............................................................................................................................................20
Reference List...........................................................................................................................................21

REAL ESTATE MANAGEMENT SYSTEM 4
Introduction
Each and every business that is thought to exist has to keep in mind the value of
managing money and time which in this case is its resources for it to realize any form of success.
An online Real Estate Management System will encompass business methods basing on the
internet simply to mean managing property by means of an online tool. This tool will not be
complex and there will be no need for a special platform or training users on how it will be
working. A company dealing with estates, for instance, has to make sure that time and resources
are not by any means embezzled. This can only be achieved thorough a suitable management
system that is centralized and technologically accepted due to the current hi-tech world. A
decentralized system is where individuals are seen to own and at the same time manage their
properties without dedicating the management to an agency company. This becomes hard due to
mistrust and security that is usually witnessed by individual owners.
Background of the Study
This system targets agency companies that wish to attain their targets basing on the
objectives put in place that drives them. While designing the mobile application, AJAX, JSon,
MySQL, JavaScript, and Html will all be used to ensure the aspects of security and portability
are vastly highlighted. However, companies venturing into real estate businesses have to
consider specific factors of success or objectives in order to avoid future losses (Robin, 2018).
To start with, security has to come first where a company has to invest at a crime-free location
since no one will easily rent or buy a house at an insecure location (Gross and Źróbek, 2013,
p.11). The Real Estate Management System will come as a solution where a user will have to
search and even have a Google search view of a location of a house before making a request.

REAL ESTATE MANAGEMENT SYSTEM 5
The other objective of a real estate company is making sure that all utilities that are high-
in-demand such as electricity and water are available before building any house since those are
first considerations for anyone looking for a house either to rent or even buy. Now, the solution
to this challenge is already highlighted in the new system since it will have a clear map of
amenities within a particular house making it easier for one to make an informed decision.
Healthcare and recreation facilities are also a vital consideration when targeting good outcomes
from an investment like housing. Real estate developers consider it as a determinant of the price
to impose on a certain house (Źróbek-Różańska & Zielińska-Szczepkowska, 2014, p.80). On the
other hand, whenever an education institution is closer to a house, many parents consider living
in such places. Developing firms, therefore, are building near schools or some go further by
building schools inside the estates just to attract more customers.
Statement of the Problem
There is a need to do away with commotions that are witnessed each and every day
between house landlords and tenants not forgetting care takers in this modern error of
technology. This is the reason as to why most landlords have dedicated most managerial roles to
agents in housing agency firms. However, one can easily think that work is just easy on the side
of agents but it is really a headache. Just to mention but a few, rent collection, assets
maintenance, making payments to property owners, foreseeing renting processes, writing reports,
banking information documentation among other things. There is only one solution that can
make life worth living for these agents. A system that is feasible enough to integrate all these
tasks and execute without errors and only depending on information first entered or updated by
specific people with managerial roles (Muczyński, 2015, p.5).

REAL ESTATE MANAGEMENT SYSTEM 6
A company with a system able to perform all the duties being done by dozens of its
employees saves a lot which results in the realization of profit and productivity at the
subsequently. There can never be a comparison between a system where computers are
employed only to do the typing and receipt printing and an automated system able to handle
everything on its own. Issues of misappropriation usually arise in a system where not all
information is channeled through it resulting in a manual way of doing things in an organization.
General Objectives
Developing an automated system able to coordinate, keep track of company activities,
control and above all incorporate all the affiliates of that firm in a smooth and timely manner.
The integration capability of the system into a mobile app should contribute to efficiency and
real-time business performance.
Specific Objectives
 Coming up with a system able to fulfill all the overall objectives
 Making sure that the implementation part of the system is successful
 Accomplishing the evaluation and testing of the system.
Justification of the Study
There will be time management on the side of companies managing properties, tenants,
and even property owners using an automated system. Consequently, as a result of doing away
with manual work, there will be a big percentage in resource management not to mention the
high level of security protection on data that will come with the new system (YABE, 2017, p.27).
Therefore, it will be an automated system with user login modules protected by strong password
policies with end-to-end encryption of all the communications done by all users.

REAL ESTATE MANAGEMENT SYSTEM 7
System Scope
Agents and companies will benefit from the system more in terms of administration and
management of properties besides tenants enjoying the efficiency like never before while doing
businesses with the agencies (KITAJIMA, 2017, p.72).
System Limitations
The operation of the system will only be conducted on a computer or a mobile for those
who will be using an app. However, this system will require up-to-date technological equipment
which on the other hand will be costly.
Existing System
A lot of shortcomings are seen in the current system of managing real estates as a result
of the manual work involved. In particular, the filing of the record, keeping forms, and the entire
documentation is manual and labor-intensive. A lot of errors may arise along the way in this
manual way of doing works since making changes is always somehow problematic. Chances of
data loss are always high due to lost or misplaced files (Gross, Źróbek and Špirková, 2014, p.63).
Data security in a manual way is poor since anyone in the offices can have access to
unauthorized documents of the company.
Proposed System
The proposed system will provide all the features offered by the existing system but in an
automated manner where all details will be kept in a database. It will have a search feature
according to the user’s requirement and only the sought request will be given back to the user.
The system to be developed will consist of many modules which will include the Web page,
housing, salable and administrator’s module (Elmetwaly, 2011, p.416). The index page also
known as the homepage will include the housing and salable modules and will have a top menu

REAL ESTATE MANAGEMENT SYSTEM 8
which will comprise the Login menu which a user will have to use a valid username and
password to login in and access the system. Only the recorded operators will be capable of using
the Homepage. The housing or the residential module will include a registration form, data about
the house, type of the house either a studio apartment, bungalow or penthouses. The salable or
the commercial module will incorporate the registration form, cost per house (Diop, 2017,
p.291). Finally, the administrator’s unit will enable the admin to have all the rights of all the
visitors as well as the regular recorded client.
Advantages of the Proposed System
Buying, selling, or even renting will be easier due to its search capability and readily
available information about houses on the system. There will be guaranteed security of data due
to authentication incorporated in the development part of the system (Radzewicz, 2013, p.87).
Therefore, precise data about all the company’s property will always be available as a result of
the system being automated.
Organizational Chart
This structure is just but an outline of how the internal arrangement of a housing agency
looks like. It depicts how the entire company is structured outlining relationships and roles
within the company.

REAL ESTATE MANAGEMENT SYSTEM 9
System Flow Chart
Below are UML diagrams which are activity diagrams showing a step by step workflow
actions and activities basing on concurrency, choice, and iteration (Huston & Han, 2018).
Director
Manager
caretaker
Tenant Tenant
Caretaker
Tenant Tenant Supplier

REAL ESTATE MANAGEMENT SYSTEM 10
Property Management Flow Diagram
This is used to depict the entire process involved when new properties are admitted into a
real estate company.

REAL ESTATE MANAGEMENT SYSTEM 11
Rent Management Flow Diagram
Displays the procedure witnessed during the payment process when a tenant makes his
payments to the system and then feedback sent back as an acknowledgement (Nase, Berry &
Adair, 2013, p.48).

REAL ESTATE MANAGEMENT SYSTEM 12
Report Generation Flow Diagram
Shows how a report is acquired by a user from the system as per his or her interest.
System Data Flow Diagrams
This show how data flow around the entire system displaying the modelling aspect of the
system.
Level O DFD
This shows the general functionality of the entire system basing on external entities.
Authentication
Reports
System Users
Housing
Agency
Assistant
System
Housing
Information
Database