OF WORK FOR WILD WOOD APARTMENT PROJECT
With the headquarters
in San Francisco, and 20 different apartment complexes in Washington, Oregon,
California and Idaho. Wild Wood Apartment managers have been facing problems
with preparing reports on new tenants, collecting of rents, closing out leases,
occupancies, the total expenses in maintenance and repairs. As a result, the manager
at corporate headquarters has expressed concerns about the accuracy and
authenticity of their reports.
To put at rest of these
problem and better the ease and effectiveness of the apartment managers, the
corporate manager at the headquarters have recommended a rationalize database
that can be used by apartment managers to track their daily businesses and make
database will pave way for managers to store and track the daily, weekly,
monthly and quarterly business of their apartment, to enable them prepare their
reports. The database will track all the relevant information from the 20
apartment such as lessee’s records, payment status, complaints, vacancy rate,
expenses on maintenance and repairs and total revenue
database will not track the lease out and the occupancy tenant financial information.
It will not make automatic payment to the apartment managers and corporate
manager at the headquarters.
To develop a centralized database which
will improve the ease and efficiency on reporting?
To track daily business of each
1. Gathering Data:
This involves accumulating information’s from the past reports sent by the
mangers, interviews, questionnaires, and observations on concerns. Time
allocated: 3 weeks.
A list of questions for interviews, observation and text of the questionnaires.
2. Analyzing Data:
The information accumulated will be examined to decide better business rules
and preceding data type. Time allocated:
List of business rule and basic entities to be reviewed.
Gathering all the information of the company to avoid redundancies.. Time
allocated: 1 week
relation diagram for review.
4. Building the physical database:
The data model will be translated to RDBMS. Tables containing columns with
specific data type and relational and other constraints created. Time
allocated: 4 weeks
Drawing a plan structure of the database for review.
5. Testing and Security:
Testing the general database security and business rules. Time allocated 3
Documented test results.
Completion and installation:
All changes are integrated, and the database
installed on a server. The database is tested for access and connections. Time
allocated: 3 weeks.
Working database is delivered to Wild Wood Apartments and the Headquarters.
Total time period from the beginning and
end of the project: 16 weeks.