Database development for Wild Wood Apartments management system

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 for the project are department manager, tenants, and corporate headquarter manager.

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

Statement of Work

The objective of this project is to develop a database for Vinyl. The project will assist the company to track several business aspect in the database. The database will assist the owner to track the sales, record the level of stocks in the inventory, update customer information, and be able to modify and allow purchases. The preliminary timeline for the project is 30 days. The major stakeholders for the project are Vinyl's owner, customer, and suppliers.

Documentation

The objective of the project is to develop a database for Vince's Vinyl. The database will assist the organization track its business aspects that include sales, update customer information, store and modify purchases. The entities and attributes that will be used to develop the database are as follows:

Customer

ID

First Name

Last Name

Address

Telephone

Email Address

Supplier

ID

First Name

Last Name

Address

Telephone

Email Address

Stock

ID Item

Item purchased

Amount purchased each item

Item Available

Total item

Sales

Item ID Purchased

Price

Customer ID

Total sales

Total Expenses

Total Revenue

Expense

Telephone

Electricity

Transport

Housing

Miscellaneous

Revenue

Total Sales -Total Expenses

Topic in the Database

The objective of this project is to develop a database for the Grandfield College that will track software, staff and faculty computers. The scope of the project is to track the software as well as an associated license agreement. The database will track software request that comes from users to determine:

Whether the copy of the required software is available

Whether the software can be purchased

To know the type of software installed on each machine

The user accessing each machine

Tracking the software uninstalled in each machine

To track machine that is retired.

Statement of Work

The objective of the project is to design the database that will assist Grandfield College to track software staff and faculty computers. The timeline to complete the project will be 30 days.

Documentation

The goal of the is to track software, staff and faculty computers for the organization. The entities and attributes used to develop the database are as follows:

Software

Software Name

License Number

Software installed in Machine

Software Machine Location

Uninstalled Y/N

Number of Copy of Software

Computer

Computer Name

Computer ID

Staff Computer

Faculty Computer

Software Installed

Software Uninstalled.

Reference

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