Create a database for wild woods apartments

Assignment Help Database Management System

Reference no: EM13810204

Statement of Work for Wild Wood Apartments

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 information in once place The objective is to be able to use the database for managers to be able to generate the quarterly reports with ease.

Tasks: This task will consist of gathering of current data to find what information fields will be needed. It will also consist of a questionnaire.

Reference no: EM13810204

Questions Cloud

Understanding of new learning in logistics management : This final research paper must demonstrate an understanding of new learning in logistics management and how the supply chain supports the organization's business strategy.

What types of reimbursement are available to this facility : What types of reimbursement are available to this type of facility? How does this differ from other long-term care facilities

Promoting the growth of office-based medical practice : Which of the following factors was particularly important in promoting the growth of office-based medical practice in the postindustrial period?

Explain the role of ethics and social responsibility : Use the Ethics Awareness Inventory and Ethical Choices in the Workplace assessments to revisit your values.

Create a database for wild woods apartments : 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

Major criticism of managed care : Which of the following is a major criticism of managed care? When patients have multiple health problems, this is called:

How to validate the organizational vision : How you intend to validate the organizational vision, mission, and values statements

Find the location of weight : The center of gravity of two particles of masses 14 kg and the 13kg is located at (3,-4)m. the 14 kg particle is located at the point (4,-1), find the location of 13kg

Define the most important external environmental factor : Identifies and analyzes the most important external environmental factor in the remote, industry, and external operating environments

User Account

All Pages