Database Design and Management

Please answer the 2 questions circled in red below and which are highlighted in yellow.

------------------------------------------------------------------------------------------------------------

Exercise: 1 Database Requirements and Business Rules Read the following scenario on Wild Wood Apartments: Wild Wood Apartments owns 20 different apartment complexes in Washington, Oregon, California, and Idaho. Each apartment complex contains anywhere from 10 to 60 separate apartments of varying sizes All apartments are leased with a six-month or one-year 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 rent from existing tenants, and close out leases. The manager also needs to maintain the apartments and conduct any repairs, replacements, or renovations. These can be billed back to the parent company. For acting as manager, the tenant gets free rent and a stipend. The stipend varies depending on the size of the apartment building. Each manager is expected to send a report to the Wild Wood Apartments company headquarters in San Francisco every quarter. This report summarizes the occupancy rate, the total revenues in rent, the total expenses in maintenance and repairs, and so on. Currently managers fill out a paper form and mail it back to headquarters. Many apartment managers have complained that preparing this report is a very difficult and time-consuming process. In addition, the managers at the corporate headquarters have expressed concern about the accuracy and verifiability of the reports. To allay these concerns and to improve the ease and efficiency with which the apartment managers conduct their daily business, the company is proposing the development of a centralized database that the managers can use to track the daily business of their apartment building and to prepare their reports As a follow-up on your initial interview with the project coordinator, Wild Wood Apartments has agreed to show you some samples of the various forms and reports they use