PT2520: Database Concepts
ITT technical Institute

Statement of Work

* History: Wild Wood Apartments owns 20 different apartment complexes in Washington, Oregon, California, and Idaho. It is very important to keep track of the activities involved in running the apartment complexes, such as maintenance issues, which apartments are vacant and which are occupied, whether rent is being paid and the like. There is a vast amount of information involved in running a successful apartment complex. The current method of keeping track of this information is outdated and difficult to use. A new database would create a more accurate and user friendly method of keeping track of important business aspects. * Scope:
The Wild Wood Apartments tracking database will track necessary business aspects involved in running the apartment complex. The database will track basic information such as apartment complex addresses, revenues, tenants, salaries paid to employees, total revenues and expenses as well as apartment occupancies and vacancies. It will track the leases on file, including when they begin and end, the lease contract number, names of the tenants, the amount of deposits paid and the monthly rent amounts. The database will also track monthly rent payments, including the amount that was paid, the date it was paid, whether or not the tenant was late making payment along with the tenants lease contract number and apartment number. Finally the database will track maintenance reports including which apartment required maintenance, what type of issue occurred, how it was resolved, the date it was resolved and any expense involved in repairs. * Constraints: The report sent to headquarters does not show any tracking of the free rent or stipends given to the managers. This appears to be something that it is not being closely tracked or monitored. *