History: Wild Woods Apartments is a property management company. They own around 20 different building, each of which is composed of anywhere from 10-60 different units. Each building has a lot of information to maintain such as occupancy, leases, payments and maintenance requests and expenses. This is expected to be done by the manger on site and then they are to send a report to cooperate every quarter. Every quarter, cooperates receives the information form all 20 sites and has to then manage that. Doing all of this paper work and managing by hand or even in spreadsheets is very inefficient and wastes time. Creating a database that can record and organize all of this pertinent information would help both the managers, cooperate and even the tenants.
Scope: The Wild Wood Apartments Database will manage leases, maintenance requests and expenses, and rent amount and payments. The information will be kept secure and the information will only be viewable to those that have a need to se e it. It will track tenants that have already paid rent and ones that are late. It will also track when a maintenance request is submitted and when it is completed.
Constraints: The database will be good for managers to be able to manage a tenants rent and maintenance requests. It will show when a maintenance request is submitted and when it was completed. It will not show the status of the maintenance order as it is being completed, or if they are waiting for supplies, etc. It will show the managers when a tenant is late on a payment but will not show the tenant with they are current or not.
Objective The objective is to create a database for Wild Woods Apartments that can help them organize all of their properties information into one system t help streamline some of the work both the onsite managers have to do as well as the cooperate workers. The objective is to make the database record and use all of the important