Business Description (Scenario) A company named FNQ UNITED APARTMENTS (FUA)
currently owns twelve (12) different apartment complexes in many locations spread over
northern Queensland areas - Cairns, Townsville, Port Douglas, Ingham, Tully, etc. Each
apartment complex has a number of separate apartments, of varying sizes. All apartments are
leased with a six month or a year—long lease. It is
...[Show More]
Business Description (Scenario) A company named FNQ UNITED APARTMENTS (FUA)
currently owns twelve (12) different apartment complexes in many locations spread over
northern Queensland areas - Cairns, Townsville, Port Douglas, Ingham, Tully, etc. Each
apartment complex has a number of separate apartments, of varying sizes. All apartments are
leased with a six month or a year—long lease. It is the company's practice to hire one of the
tenants to manage each apartment complex. As managers they need to admit new tenants to the
building, collect rents from existing tenants, and finalise leases. The manager also needs to
maintain the apartments conducting any repairs, replacements, or renovations. For most cases,
the manager needs to arrange relevant local trade person or company to conduct necessary
works. These can be billed back to the parent company (FUA). For acting as manager, the
tenant gets free rent and a stipend. The stipend varies depending on the size of the apartment
complex managed. Each manager is expected to send a report to the FUA company head office
in Townsville every quarter. This report summarizes the occupancy rate, the total revenues in
rent, the total expenses in maintenance and repairs, etc. As FUA does not run an established
database system, currently managers fill out a paper form and mail it back to head office. Many
apartment managers have complained that preparing this report is a very difficult and timeconsuming process. Also, the managers at the head—office also have expressed concerns about
the accuracy and verifiability of the reports. To reduce these concerns and to improve the ease
and efficiency with which the apartment managers conduct their daily business, the company is
proposing to develop a centralized database that can be used by the managers to track the daily
business of their apartment building and to prepare their reports. You have been asked to design
a database that satisfies general business description and various user requirements summarized
above and below. FUA also showed you some samples of various forms and reports to enhance
your modeling job. The first example is of a spreadsheet to keep track of leases at one apartment
complex:
[Show Less]