Question

Database Systems: A Practical Approach to Design, Implementation, and Management, 6th Edition, Chapter 11 Database Analysis and the DreamHome Case Study.

Based on Dreamhome Case Study;

1. Title suitable for the project based on the case study?
2. The problem statement ?
3. Objectives?
4. Boundary(scope)?
5. User views?
6. ExtraFeatures?

Answer 1

A suitable title can be anything which justifies the case study

so for this case, we can  keep the title as 'DreamHome database system'

Problem Statement: to design a database system for the company DreamHome specializes in property management, taking an intermediate role between owners who wish to rent out their furnished property and clients of DreamHome who require to rent the furnished property for a fixed period. DreamHome currently has about 2000 staff working in 100 branches. When a member of staff joins the Company, the DreamHome staff registration form is used. Each branch has an appropriate number and type of staff including a Manager, Supervisors, and Assistants. The Manager is responsible for the day-to-day running of a branch and each Supervisor is responsible for supervising a group of staff called Assistants. Each branch office offers a range of properties for rent. To offer property through DreamHome, a property owner normally contacts the DreamHome branch office nearest to the property for rent. The owner provides the details of the property and agrees with an appropriate rent for the property with the branch Manager. Once a property is registered, DreamHome provides services to ensure that the property is rented out for maximum return for both the property owner and, of course, DreamHome.

Objective: 'The DreamHome database' will maintain the data that is used and generated to support the property rentals business of the clients and property owners and to facilitate the cooperation and sharing of information between branches.

Systems boundary: The purpose of the system definition stage is to define the scope and boundary of the database system and its major user views. A user view represents the requirements that should be supported by a database system as defined by a particular job role (such as Director or Supervisor) or business application area (such as property rentals or property sales).

User views: The majority of data about the user views was collected during interviews with the Director and members of staff in the role of Manager, Supervisor, and Assistant.