This paper presents a methodology driven by database constraints for designing and developing (database) software applications. Much needed and with excellent results, this paradigm guarantees the highest possible quality of the managed data. The proposed methodology is illustrated with an easy to understand, yet complex medium-sized genealogy software application driven by more than 200 database constraints, which fully meets such expectations.
The goal of this paper is to provide a rigorous methodology for enhancing VBA software application users’ experience when faced with attempts to violate the underlying SQL Server database constraints. The original contribution is a pseudo-code algorithm for assisting developers in this process. We exemplify the results of using it with a full code example for a class taken from a genealogy database software application designed and developed using this methodology. Consequently, it replaces all context-independent and developer jargon standard system error messages with context aware and natural language ones. Moreover, it also synchronizes combo-box instances after each update or delete. We also show that the proposed algorithm works fine not only for other relational database management systems, but even with NoSQL platform backends, and that the modifications needed to adapt it to other similar SQL embedding frontend platforms are minimal. This algorithm main merit is that it may serve as the basis for developing a tool for performing this important task through automatic code generation.
scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.