Verified Document

Documentation Of Database Development Term Paper

Related Topics:

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…

Sources used in this document:
Reference

Conger, S. (2014). Hands-on Database: An introduction to Database Design and Development (2nd Edition). Upper Saddle River, NJ: Pearson.
Cite this Document:
Copy Bibliography Citation

Related Documents

Databases and Regulatory Compliance Challenges
Words: 3434 Length: 13 Document Type: Research Paper

Databases and Regulatory Compliance Challenges The advent of technology has increased the popularity of database usage in firms, yet the legislation regulating the field has yet to be finalized. The changing nature of the IT sector, coupled with the legislative traits, creates several situations in which the companies find it difficult to comply with the regulations. This paper recognizes some of those difficulties, and also proposes some solutions. Databases Regulatory challenges for databases No

Software Development Life Cycle SDLC
Words: 3695 Length: 12 Document Type: Essay

Software Development Life Cycle ( SDLC) Explain Requirement process ( in SDLC) in detail. Why is this exercise important? Requirements engineering is a fundamental activity in systems development and it is the process by which the requirements for software systems are identified, systematized and implemented and are followed through the complete lifecycle. Traditionally engineers focused on narrow functional requirements. Now it is being argued by Aurum and Wohlin (2005) that focusing only

Enterprise Systems Development Strategy British American Tobacco
Words: 3425 Length: 11 Document Type: Essay

Enterprise systems development strategy BRITISH AMERICAN TOBACCO British American Tobacco (BAT) is a leading tobacco company globally producing 200 brands of cigarettes. The company global drive brands are Dunhill, Pall Mall, Kent, and Lucky Strike, and these brands provide 35% of the company revenue. Other international brands manufactured by the company are Benson & Hedges, Rothmans, Viceroy, Vogue, Kool, Gold leaf, John player, Express 555 etc. British American Tobacco operates under

Software Development Life Cycle
Words: 2835 Length: 10 Document Type: Essay

Software Development Life Cycle Agile Software Development Agile software development is a popular software development process or methodology that has gained a lot of popularity in the recent years due to its effectiveness and ease of use. Firstly, it encourages collaboration and teamwork throughout the life cycle of development and this makes it easy to plan and implement. Agile software development is all about breaking a task into small chunks that make it

Electronic Information Security Documentation During
Words: 1268 Length: 3 Document Type: Term Paper

Risk analysis projects are relatively expensive, and were so even in the mainframe computing era, because they involved the collection and evaluation of a significant volume of data. Earlier risk studies were conducted by in house staff or consultants and the in house people did not have much experience regarding the matter and the consultants did not know much about the requirements of the organization. Presently, the familiarization task has

Computer Security: Corporate Security Documentation Suitable for
Words: 5280 Length: 19 Document Type: Essay

Computer Security: Corporate Security Documentation Suitable for a Large Corporation Item (I) in-Depth Defense Measures (II) Firewall Design (III) Intrusion Detection System (IV) Operating System Security (V) Database Security (VI) Corporate Contingency of Operation (VII) Corporate Disaster Recovery Plan (VIII) Team Members and Roles of Each (IX) Timeline with Goal Description (X) Data Schema (XI) Graphical Interface Design (XII) Testing Plan (XIII) Support Plan (XIV) Schematics Computer Security: Corporate Security Documentation Suitable for a Large Corporation (I) In-Depth Defense Measures Information Technology (IT) Acceptable Use Policy The intentions of

Sign Up for Unlimited Study Help

Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.

Get Started Now