Preview

PT2520 Week 1 Assignment

Satisfactory Essays
Open Document
Open Document
571 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
PT2520 Week 1 Assignment
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

You May Also Find These Documents Helpful

  • Good Essays

    There are two different types of requirements for this project. One is the technical requirements of the chosen database system and another is the business requirements of the Huffman Trucking.…

    • 686 Words
    • 3 Pages
    Good Essays
  • Good Essays

    I will concentrate on the need for a Database Management System (DBMS). I feel that by utilizing a database management system it will alleviate all of the unnecessary traveling that Mr. Morgan currently does. Mr. Morgan is in charge of all of the day to day business, as well as the payroll, and recruiting for the company and all of its stores. The main functions of a DBMS are to create the database, insert, read, update, and delete database data, maintain data integrity (i.e., making sure that the data are correct) and security (i.e., making sure that only the right people have access to the data), and prevent data from being lost by providing backup and recovery capabilities (Thite, 2009). DBMS can help eliminate the need for traveling to each individual…

    • 440 Words
    • 2 Pages
    Good Essays
  • Good Essays

    DBM380 Week 2

    • 837 Words
    • 3 Pages

    The database environment refers to the type of configuration used to populate and create the application. A database includes items such as text, images and graphics associated with a record. The main purpose of a database is to collect and organize that data. The environment to be designed is one to store and retrieve data in a way it can be easily organized. For the purpose of this assignment the database environment will be a series of tables which store customer, sales order, purchase order and various status point information. This data will then be used for a series of reports to demonstrate status of the purchase order as it flows through the system. The overall goal is to be able to provide the customer an accurate status of their purchase order that is submitted electronically.…

    • 837 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Pt1420 Unit 3 Assignment

    • 298 Words
    • 2 Pages

    2. Consider the following two vectors: x =  1  and y =  1 .…

    • 298 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    2.What number does a bit that is turned on represent? What number does a bit that is turned off represent? On is 1 and Off is 2…

    • 286 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    1. Explain in words why the equation {n \choose k} = {n \choose n -k} is true.…

    • 527 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Pt1420 Unit 1 Assignment

    • 303 Words
    • 2 Pages

    These administrations help in building common dialect UIs. Discourse to Text gives a transcript of common dialect into content. Artificial intelligence is utilized to join linguistic and dialect structures with the preparing of voice motion for a more exact recognizable proof of words. Then again, Text to Speech benefit incorporates discourse from a content document while altering cadence and sound. The words are integrated progressively in a few dialects.…

    • 303 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    In this paper the writer will seek to respond to the questions designated for both scenarios. This paper will list typical fields for each type of data. Provide an example of two relationships that you need to track. This paper will also answer the questions of: Do you need a database system? If not, can Excel® handle the data and the output? What are the advantages and disadvantages? Would you use a personal database or an enterprise database? Explain your answer. Would a decision support system (DSS) be helpful? Explain your answer.…

    • 1392 Words
    • 6 Pages
    Better Essays
  • Good Essays

    The aim is to develop software, which can manage and keep record of the hotel. The existing system was manual. Computerized reservation technology enables the customer to select a rooms without going to hotel and he can make transactions online through internet. Thus, the customer can save so much time…

    • 1500 Words
    • 6 Pages
    Good Essays
  • Satisfactory Essays

    Bca Se Syllabus

    • 1858 Words
    • 8 Pages

    Block 1 : DBMS concepts : Introduction – Basics of Database – Three views of Data – Three level architecture of DBMS – Facilities – Elements of DBMS – Advantages and disadvantages – Database Models : File Management system and its drawbacks – Database Models : E-R Model, Hierarchical Model, Network Model, Relational Model.…

    • 1858 Words
    • 8 Pages
    Satisfactory Essays
  • Powerful Essays

    Rental System

    • 1523 Words
    • 7 Pages

    This project was developed from June 2013 to July 2013. The main objective of the project was to develop a computerized rental system of JE housing agency. The specific objectives of the study were: first is to create a computerized rental system that can organized and retrieve data accurately; second, a system that can locate a client immediately and chronological manner; and third, a program that will add records of the client to a specific owner of the house.…

    • 1523 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    The Rosewood Pointe Residences Incorporation is a real estate company. They have 10 unit buildings located at Taguig City. They have first class amenities where the residents can enjoy and relax from its relaxing environment. As the group observed in their office, we discovered that there are a lot of problems that they were experiencing from maintenance in resident’s information, monitoring amenities, generating reports and their manual reservation process. The group decided to build a system that will make their work easier, accurate and efficient. The system also allows the owner’s records monitoring and amenities reservation system and the billing and collection system, by having all unit owners or customers’ information.…

    • 4375 Words
    • 18 Pages
    Good Essays
  • Satisfactory Essays

    Dear Sir

    • 279 Words
    • 1 Page

    If you are still using spreadsheets or paper to run your Property Lettings business, even more reason to change to using Property Manager. The transition is very simple as Property Manager is very easy to use and can be up and running quickly, saving you time, money and removing stress!

"We have looked at many Property Management programs, and this is by far the easiest to use we have seen." 
Lynda Ryan, Allandale Property Development

Property Manager helps you manage your complete lettings business all from a single screen. You will never miss a gas inspection or an overdue rent payment again. Reports and letters to Landlords, Tenants and Maintenance suppliers are at the click of a mouse! It could not be simpler.

You can download our 7 day unrestricted evaluation, just go to:
www.propertymanageronline.com/Evaluate.htm…

    • 279 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    front page 1

    • 1982 Words
    • 6 Pages

    The current problem observed is the manual guest list records, the manual reservation of guests, the manual booking of rooms for the guests According to the manager in the establishment, because they keep on doing their job manually, it resulted to a very messy office, lots of papers around the desks and sometimes important documents disappear. From the information gathered, the proponents came up with an idea of proposing a system that is…

    • 1982 Words
    • 6 Pages
    Good Essays
  • Powerful Essays

    Abdulla with his problem. I think that a good database is something that keeps all of the recorded data together in one place so that none of the information gets misplaced or lost, the problem with spreadsheets is that if lost it could cause for orders being placed by the teachers to be lost and the teachers will find themselves without the materials they need to conduct their class. I would also have to install a security system so that the information stored in the database can’t be accessed by just anyone, to avoid this problem I would be adding user system so that any teacher who accesses the database will have to log on to their user and access it from there as I think this will help us know if any data is deleted and can also keep track of which user/teacher has placed an order and what the teacher needs. Mr. Abdulla will also have to have a contact page where teachers can send him any special requests for the materials they order. I will also be adding a page that shows what the suppliers have in stock so that the teachers will know what they can order, it will also include a notifying system where as if a teacher needs a piece of equipment or any other material and it is out of stock, the system will automatically send a notification to the teacher telling him/her when the supplier receives the stock. The database will also alert Mr. Abdulla when a teacher places an order for something so that he knows what needs to be brought in, this system will also prevent any excess equipment being paid for as sometimes if there are more materials that have been sent and the school needs to pay more for things they didn’t order, Mr. Abdulla can prevent this as he would know what the order is and how much of it has been ordered. I also found the databases that I had researched helping me in this situation as they gave me ideas as to what I can add to improve my database even…

    • 1852 Words
    • 8 Pages
    Powerful Essays