Designing a relational database to facilitate military family housing utilization decisions

摘要

The Housing Welcome Center (HWC) in Monterey, CA manages more than 2, 200 military family houses and provides services to approximately 4,500 service members. The current housing information system consists of a proprietary legacy database system, a homemade non-relational database, a collection of word processing documents, and a static online application Web site. This semi-manual system can introduce errors, inconsistencies, and redundancies that may lead to frustration and possibly a decrease in quality of life. This research presents a prototype Housing Assignments and Terminations System (HATS) that uses a top- down systems analysis design approach. The research defines requirements and models that are transformed into a relational database with connectivity to a Web site. A graphical user interface (GUI) provides intuitive menus to manipulate and view data. Decision support tools help decision-makers visualize the data in a spatial manner and make better decisions to improve the quality of life for service members.