List the major topics for this database.
The major topics of the database are: Lease Form (tracks leases of one apartment complex); Rent Payment Form (tracks rent payment of one apartment complex); Maintenance Request Form (tracks requests for maintenance and apartment manager’s resolution); Sample Quarterly Report (shows revenues and expenses of a particular building, address).
STATEMENT OF WORK
Project Name: Wild Wood Apartments
June 21, 2014
• History: The Wild Wood Apartments are made up of 20 different complexes in Washington, Oregon, California and Idaho with each complex containing from 10 to 60 separate apartments. Leases are from 6 months to a year and the company’s practice is to hire one of the tenants to run the complex, collecting rent, conducting repairs, etc. The company requires a quarterly report to track the lease occupancy, rent payment, maintenance, and revenue and expenses; all of which is done in paper form. The forms are considered time consuming by the property managers, and the corporate office has concerns over their accuracy. A centralized database is being considered to simplify and better manage this data.
• Scope: The contractor will include hardware, website, software and data storage support for the headquarters and all property offices that belong to Wild Wood Apartments. The main storage for the data will be offsite and the contractor is responsible for maintaining it.
• Constraints: The contractor and the headquarters office of Wild Wood Apartments would have access to all the data, individual managers of the property would only have access to their particular site’s data. The contractor is not responsible for internet connectivity beyond the boundaries of the company’s properties.
• Objectives: The objective is to simplify and improve the accuracy of the data collection as well as making the data available through a