Database Development and Its Documentation
Wild Wood Apartments
Major topics for the database
The major topic for the database are as follows:
Wild Wood Departments has the total number of 20 different apartments located in Oregon, Washington and California.
Each apartment complex contains between 10 and 60 apartment and consists of varying sizes.
All apartments are put to lease for a period of one year or six months.
The company business practice is to hire one of the apartment's tenants to manage each of the apartment complexes.
The manager collects rents from tenants and admits new tenants into the building.
The manager also closes the lease if necessary.
The manager's responsibility is also to carry out a repair, renovation, and maintenance of the apartment.
As a manager, he or she gets a stipends and free rent.
Moreover, each manager is expected to the entire report to the company headquarter in California, San Francisco every quarter
The report provides the summary of occupancy rates, maintenance expenses, total revenue from rent and expense for repairs.
Currently, the manager fills out the paper form, and the paper is mailed back to the headquarter.
However, the department manager complains that filing out the form is a complicated and time-consuming process.
The corporate headquarter has shown a concern to easy the efficiency by which the department managers will be able to conduct their daily business.
Thus, the Wild Wood Departments is proposing to develop a centralized database system to improve the efficiency and ease the company daily business to assist the manager to prepare the report of the apartment building.
2. Statement of Work
The objective of this project is to develop a centralized database for the Wild Wood Departments to ease the efficiency the apartment manager will conduct their daily business. The essence of the database is to prepare a report and track daily business of the company.
The project scope will cover the development of a centralized database for the Westwood Department. The preliminary timeline to complete the project will be 30 days, and the major stakeholders...
Documentation
Documentation is the process of providing a document for all the method of the database design that includes its scope, project objective, database structure, problems that the database intends to solve, its business rule, and important decision about its design process. (Conger, 2014).
Statement of Work
The objective of this project is to design database for Wild Wood Departments to ease the efficiency that the company employee employs in creating and accessing data and report.
The Entity and attributes that will be used to record and tracks leases of the apartment complex in the database are as follows:
Apartment Complex
Apt #
Lease Number
Lessee Name
Start Date
End Date
Rent Amount
Deposit
Current
The Entity and attributes that will be used to develop the rent payment form used to track payment in the database are as follows:
Rent Payment
Apartment
Lease Number
Amount Paid
Late
The Entity and attributes for the maintenance request form that will be used to track a request to repair and maintenance as well as apartment manager resolution are as follows:
Repair and Maintenance
Apt
Problem
Type
Resolution
Res Date
BExpense
Texpense
The Entities that will be used to develop the Quarterly Report in the database is as follows:
Quarterly Report
Building#
Address
Quarter
Year
Total Apartments
Percent
No. Changing Tenants
Revenues
Total Rent Revenue
Expenses
Utilities
Maintenance
Repairs
Insurance
New Tenant Cleaning
Wages
Total Expenses
Unrecovered Rents
Total Profit/Loss
Vince's Vinyl
The major topics for the database are as follows:
The database will assist…
