Preview

Week 1 SOW 1

Good Essays
Open Document
Open Document
452 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Week 1 SOW 1
History: Wild Wood Apartments owns 20 different complexes in California, Idaho, Oregon and Washington. All of these complexes are managed by tenants who have been hired by the company to perform this job. Currently and in the past these managers have been using paper forms to complete quarterly reports for the managing office in San Francisco. These forms are very difficult and time consuming to fill out.
Scope: To create a database that will store accessible information regarding Wild Wood Apartments quarterly report information.
Constraints: This database will not include all of a renters personal information such as social security number, employment information, etc.
Objectives: This project is to develop a centralized database for the individual complex managers to enter information into regarding their location where it can be reviewed by the overseeing management office in San Francisco.
Tasks and Timeline:
Gathering Data: Information regarding information required to be included in the database will be collected. This process will last 1 business quarter to ensure that all required information for quarterly reviews are included.
Time allotted: 12 weeks
Deliverable: Detailed list of required information that will be verified by central management.
Analyzing Data: Central management will assist in determining inclusion or exclusion of information that will be included in the database as well as prioritization of that information
Time allotted: 2 weeks
Deliverable: A prioritized list of information that is to be included in the database.
Normalization: A data model of entities with normalized relationships will be created.
Time allotted: 1 week
Deliverable: Entity Relationship Diagram for review of central management

Building the Physical Database: The data model will be translated into the Relational Database Management system of choice. All Tables and Columns with specific data types will be created and will include Relational and other constraints.
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Satisfactory Essays

    PT2520 Week 1 Assignment
    • 571 Words
    • 2 Pages

    PT2520 Week 1 Assignment

    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.…

    • 571 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Better Essays

    Proposal for Kudler Fine Foods
    • 2384 Words
    • 10 Pages

    Proposal for Kudler Fine Foods

    Our team was charged with the task of selecting a small business for which to implement database forms and reports requirements. We selected an upscale specialty food store located in the San Diego metropolitan area, named Kudler Fine Foods, as our business model. As do many organizations, Kudler utilizes a database system to improve their operational environment. However, they were still manually creating their forms and reports. Each store location uses standardized paper forms, which are then mailed or faxed to the main office to be entered into the database. The inventory system and forecasting for future purchases are done via extrapolations and working knowledge of the company, rather than queried data from their database system. Once we researched the company and gathered all of the necessary data, we were able to determine what type of forms and reports were needed.…

    • 2384 Words
    • 10 Pages
    Better Essays
    Read More
  • Good Essays

    Wild Wood Apartment Scenario PT 2520 Steely
    • 469 Words
    • 3 Pages

    Wild Wood Apartment Scenario PT 2520 Steely

    2. Managers must note residents SS #’s, apartment #’s, and lease number with start dates, and end dates.…

    • 469 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    PT2520 Week 4 Essay 4142015
    • 664 Words
    • 4 Pages

    PT2520 Week 4 Essay 4142015

    I would think that have to choose MySQL would be the best fit for Wild Wood Apartments. It may run higher in query testing but the overall processes and structure would work better for a small to medium size company. It meets all the requirements that the Wild Wood Apartments has for operating systems, table and row size, Much of MySQL's appeal originates in its relative simplicity and ease of use. This will be necessary for people who are not use to using this type of system.…

    • 664 Words
    • 4 Pages
    Good Essays
    Read More
  • Powerful Essays

    Dbm 380 Week 1
    • 1191 Words
    • 5 Pages

    Dbm 380 Week 1

    Database environments are very important in today’s industries. In selecting an organization that will need a database, I choose Smith Consulting. Smith Consulting will need a database to track their consulting staff, each staff member’s skill sets, and what projects they will be working on. This document will provide information on the following area’s listed below:…

    • 1191 Words
    • 5 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Learning Team Project Charter
    • 667 Words
    • 3 Pages

    Learning Team Project Charter

    This project will upgrade the company’s database system within Human Resources. All database information will now be stored on the new database server that will be installed at the main headquarters. The database servers that are already installed at each local site will be reconfigured to send and receive updates to the main server so that all database servers are mirrored. Hard disk drive space will be upgraded to account for database growth at each location. Employees that require access to this database will need approval from the Human Resources department to protect employee information. This project will not update the actual database software but will reconfigure the software to be accessible across the company network as well as combine all database information into one large database. A new task of nightly backups will be initiated at the main headquarters once the new database setup is completed.…

    • 667 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    W15 Commonwealth Stadium Project Assignment
    • 1125 Words
    • 5 Pages

    W15 Commonwealth Stadium Project Assignment

    The Bolton Construction Company is preparing a bid to build the new 56,000 seat Commonwealth Stadium in Toronto. The construction must start September 4, 2014 and be completed in time for the 2017 Commonwealth Games. The contract contains a penalty clause of $100,000.00 per day of delay beyond June 1st, 2017.…

    • 1125 Words
    • 5 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Database and Nouns Major Topics
    • 358 Words
    • 2 Pages

    Database and Nouns Major Topics

    4. Building the physical database: The database model will be constructed into the actual database program.…

    • 358 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    RTT1 Task 2
    • 3259 Words
    • 10 Pages

    RTT1 Task 2

    gathering data in regards to the event, then the data needs to be analyzed, and the final step is…

    • 3259 Words
    • 10 Pages
    Powerful Essays
    Read More
  • Better Essays

    Dbm 381 Week 1 Individual
    • 971 Words
    • 4 Pages

    Dbm 381 Week 1 Individual

    The data in these databases help in managing care plans, research projects, and creating reports for the different departments within a health care facility.…

    • 971 Words
    • 4 Pages
    Better Essays
    Read More
  • Good Essays

    Phase 1 Individual Project for Spreadsheet Applications
    • 817 Words
    • 4 Pages

    Phase 1 Individual Project for Spreadsheet Applications

    References: Cohen, B. (2004). Database Basics Part 2: Spreadsheets and Databases. Small Business Computing. Retrieved from…

    • 817 Words
    • 4 Pages
    Good Essays
    Read More
  • Better Essays

    Determining Databases and Data Communications
    • 1392 Words
    • 6 Pages

    Determining Databases and Data Communications

    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
    Read More
  • Good Essays

    Business Rules and Data Models
    • 688 Words
    • 3 Pages

    Business Rules and Data Models

    3. The database scheme: the specifications of the logical structure of the data stored in the database.…

    • 688 Words
    • 3 Pages
    Good Essays
    Read More
  • Better Essays

    Riordan Manufacturing Database Plan
    • 3100 Words
    • 13 Pages

    Riordan Manufacturing Database Plan

    Normalization of the database: This is a critical step for making the database. Normalization will help create table structures as well…

    • 3100 Words
    • 13 Pages
    Better Essays
    Read More
  • Good Essays

    Information Use
    • 777 Words
    • 4 Pages

    Information Use

    The database we worked on was a system called Salesforce; this system enabled us to keep track of the calls we had to make and document all details of that call. It contained all of the information we needed to accomplish this task, it held clients pertinent data, the banks that we dealt with and a method to track the goals we had to accomplish each week. This system was also an ERM (electronic records management database) we had the ability to scan and upload pertinent client information such as three months of bank statements, paystubs, and hardship letters, foreclosure notices and current mortgage statements. It was very user friendly and had the ability to be modified towards the needs of…

    • 777 Words
    • 4 Pages
    Good Essays
    Read More

Related Topics