Wild Wood Apartments (Coursework Sample)

Name:
Course:
Tutor:
Date:
MBA WILD WOOD APARTMENTS
IndexPage
Chapter 1………………………………………………………………………………….
Chapter 2………………………………………………………………………………….
Chapter 3………………………………………………………………………………….
Chapter 4………………………………………………………………………………….
WILD WOOD, Chapter 1
Topics included sales and purchase of albums, employees of the company, Expenditures of the company, Terms and conditions of the company, Contracts or agreements, example lease, Assets acquired e.g. stationery among other tangible assets
History
Wild wood apartments have been a host to most of the occupants in New York City, Boston, Louisiana and California. The growth rate of the following town has seen the apartments booked and the contract is agreed upon with the tenant. The apartments are well furnished with the best quality products and latest fittings that meet the growing population needs. The wild wood company offers fair rates to employees who live and maintain the apartments. It is the tradition of the wild wood apartments to ensure that they meet to discuss on how to improve the standards of their apartments and plan to expand their business in real estate. Tenants fill questionnaires every end month to air out complaints or suggest on new ways to maintain the apartments.
SCOPE
The introduction of a database will be to meet the daily needs of the employees and the tenants who live within the Wild Wood apartments. It will also help in keeping of records of the apartments such as expenditure and the rents paid by the tenants. The database may also have records on the margin of profits and losses of the apartments.
OBJECTIVES
1 Have the actual number of tenants in the apartments
2 Compare difference occupancy rate of all apartments
3 Have all grievances addressed to the letter to avoid vacation of the apartments
4 To ensure proper us of appliances in the apartments such that the tenant could repair damaged appliances’ before vacating
5 Have the actual figure of the rents and the possible values in case of any change so as to have a clear comparison during meetings
6 Have all sorts of receipts noted down example tenants receipts and purchased goods that may be purchased for any changes to be done
7 Note events such as robbery or fire cases in any of the apartments among other cases that may have happened within and how to prevent them.
8 Regulation of prices such that they may not be too high or too low
TASKS AND TIMELINE
1 Gathering Data: The manager may gather information in different ways of data collection such as surveying, observation and filling of questionnaires. Time allotted 3 weeks.
Deliverable: A list of schedule of interviews and observations by relevant employee, text of the questionnaires.
2. Analyzing Data: Data gathered can be analyzed to determine business rules and other preliminary data modeling. Time allotted 3 weeks.
Deliverable: Rules of the business should be reviewed including the basic entities and attributes.
3. Normalization: The data model will be completed with entities and relationships normalized. Time allotted 1 week.
Deliverables: Entity Relation Diagram for Review.
4. Building the physical database: The data model will be translated to the Relational Database Management system. Tables, Columns with specific data types and Relational and other constraints created. Time allotted 2 days.
Deliverables: The Schema of the database for review.
5. Testing and security: Sample data will be entered and each of the business rules and requirements will be tested. General database security and security related to business rules will also be tested. Time allotted 3 weeks.
Deliverables: Documented test results
6. Database completion and installation: Final changes and corrections are made. Sample data will be removed and the database installed on a server. Final testing for server access and connections. Time allotted 2 weeks.
Deliverables: The working database total time between beginning of project and end: 11 weeks, 3 days.
WILD WOOD, Chapter 2
Leases of California apartment

Apt #


Lease Number

Lessee Name

Start Date

End Date

Rent Amount

Deposit


Current


101


7017509

John’s Bates

6/1/2008

5/2/2008

$ 1,700.00

$ 3,500.00


1


320


16000109

Gibson Howard

9/1/2008

9/2/2008

$ ,2000.00

$ 2,700.00


1


301


786060104

Veronica Gibbins

25/1/2008

25/2/2008

$ 2,250.00

$ 3,500.00


1


148


201060106

Samantha Malone

14/1/2008

6/2/2008

$ 1,350.00

$ 3,000.00


1


13


21406019

Jeff Craig

15/1/2008

12/3/2008

$ 2,450.00

$ 4,000.00


1

Table 1
1 Would the database have all tenants included in it
2 Can there be any additional space for more tenants to move in
3 Tenants with apartments with executive option
4 Should there be warning signs and direction signs indicated
Rent payment
Date

Name

Apartment

Lease Number

Amount paid

Late







12/1/2010


Martin Cliffs


5467


453011208


$ 1,100.00


12/1/2010


Louise
kelvin


231


768060108


$ 1,300.00












12/1/2010


Susan Tales

16



x


12/1/2010


Anthony Hedges


78


9876020209


$1,350.00












12/1/2010


Clifford Jones


190


098710109


$1,200.00


12/2/2010


Anthony Hall


50


09875010109


$1,350.00


12/2/2010


Bobby Brown


198


434030209


$1,450.00












12/2/2010


Dennis sheath


200


875600.00


X


Table 2
1 Does it show how the rents are to be collected and dates rents should be collected?
2 Does it ensure that the rents are filled in?
3 How do you identify the number of tenants who have paid rent on time?
4 Are their fines imposed for tenants who pay their rents on a later date?
Quarterly report
Building #12
Address 1321 Eastlake, Seattle, and WA.98123
Quarter spring year 2009
Total apartment currently occupied percent no. changing tenants
45

40

89%

13

Revenue
Total rent revenue 275000
Expense
Utility 1840
Maintenance 13298
Repair 8790
Insurance 6340
New tenant cleaning 11 400
Wages 20,200
Total expense 61,868
Un...