Student Name Student ID.

Student Name
Student ID 1
Assignment 2 – Rental House Database Management System
Submitted by
Course
Professor
Date

Student Name
Student ID 2
Table of Contents
1. Abstract...............................................................................................................................................3
2. Introduction........................................................................................................................................3
3. Organization Background...................................................................................................................4
4. Project Description.............................................................................................................................5
5. Literature Review................................................................................................................................6
5.1. Proposed System.........................................................................................................................7
5.2. Data Gathering Techniques.........................................................................................................7
5.3. Options for Developing System..................................................................................................8
5.3.1. Option 1 - Using Online System Architecture (Web based)................................................8
5.3.2. Option 2 – Customized ERP System....................................................................................9
5.3.3. Option 3 – Developing System using MS Access...............................................................11
5.4. Recommended Solution............................................................................................................13
5.5. Benefit Analysis to the Organization........................................................................................13
5. Development Process...........................................................................................................................15
6. Supervisor Evaluation of the System................................................................................................17
7. Client Evaluation on the System.......................................................................................................18
8. Reflection Analysis............................................................................................................................18
9. Limitations Discussed........................................................................................................................19
10. Time Log........................................................................................................................................19
11. Conclusion.....................................................................................................................................20
12. References.....................................................................................................................................20

Student Name
Student ID 3
Table of Figures
Figure 1: Literature Map..............................................................................................................................8
Figure 2: Architecture of Online Application.............................................................................................10
Figure 3: Architecture of ERP Solution.......................................................................................................11
Figure 4: Architecture of MS Access..........................................................................................................13
Figure 5: Conceptual Map.........................................................................................................................17

Student Name
Student ID 4
1.Abstract
We have been stucked with new innovation but the main requirement is simply stuff that works.
With the present change in perspective in automated field, there is an urgent requirement to grasp
and welcome the intensity of innovation. Various challenges exist in order to manage rental
properties data as currently the organization is using manual framework. Subsequently there we
have to build up a rental properties framework that will be able to work for the managers who
can work efficiently as well as in effective way.
I understood all work was done physically using paper work. Paper work is more prone to errors,
lost or damaged. The process of managing data in manual file system is more expensive. In order
to find specific file from numerous files turns into a challenging task. Thinking about those
certainties, I have chosen to develop a rental house framework that can help the organization to
manage all processes automatically and resolve all the issues that are faced by using manual file
system. This new automated system is very easy to use or we can say it is user friendly.
(Gommans, H., P. & Njiru, 2014).
2.Introduction
The rental association having begun the business of renting properties that manage all its records
manually by utilizing the documents, books and papers which had turned out to be very difficult
to oversee because of the high multifaceted nature brought about by the persistent rise in
customer's numbers and also properties. Hence, the administration had chosen to embed new
access database framework which will be automated in the information and subtleties
management. The rental management framework is proposed to be structured by GDC
organization which is mainly into renting properties that currently manually deals with handling
data.

Student Name
Student ID 5
This report is to analyze an access project which is developed to eliminate the current issue of
the unstructured database in an association and also discusses that how this system can enable
the organization in organizing their manual database, make their performance better by
implementing modularity and advance user friendliness of the application while diminishing the
overhead expenses. The venture incorporates the making of ER diagram by implementing
relationship between various tables and referential integrity constraints by validating the
correctness of data which is stored in database. This report also includes the feasibility matrix of
various solutions that can help to choose a best one among these solutions.
3.Organization Background
In case of housing and renting organization, the significant viewpoints to be considered in the
everyday life where individuals continue searching for renting property for different uses which
could be private, business, workplaces or any type of storage purposes. The speculator will buy
and oversee the properties which are income generated for them. These properties can have at
least one units that are rented out to inhabitants in return for monthly rental charges. Financial
specialists can have a viable rental solution without having to legitimately deal with these
properties. GDC organization is planning to start renting business where the organization has to
manage all data related to vacant properties, investors, customers, and so on. It is very difficult
for them to maintain all data manually. Therefore, the organization wants to automate the entire
system.
The association had been confronting different issues when they are attempting to deal with their
properties and their client's data where the majority of them utilize the manual framework which
is repetitive, inaccurate, tedious as well as prone to errors. The administration had been taking a

Student Name
Student ID 6
lots of time while attempting to recover the stored information and therefore debilitating the
clients and landowners from utilizing their administrations.
4.Project Description
As all the processes of GDC organization are manually, they need a relational database that can
help the organization to automate all its processes. According to the organization, there is the
requirement for login form so that the authorized user can have the access to rental database with
the assigned usernames and passwords. Hence, we have developed the system which starts with
their login details only. The organization needs to move the information of the rental property
from current occupant data table into old inhabitant data whose end date comes to end. At
whatever point the user will update the occupancy status of the particular property to be
terminated, all the property's details will be deleted from current inhabitant data table and after
that it will be inserted into old inhabitant data table.
The organization needs to keep the track of the considerable number of activities done by the
users and that means any progressions that have been made by the user. Also, there is the
requirement of financial reports related to each property.
The organization needs to create a layout for the property review reports. But this was not seem
as practical as the detail for the analysis of any property will be distinctive and needs to be
clarified by the Property Manager in this report. So it was not reasonable to produce the
inspection report for each property. The project will help to display the monthly financial reports
in order to generate overall revenue. This will help the organization to have better decision
making related to properties.