On Software Application Database Constraint-driven Design and Development

Abstract

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.

On replacing standard system error messages for relational database constraints with context aware natural language ones

“…We applied in [5] our proposed algorithm to the development of a genealogy software application. Let us consider from its db only the 3 tables (with a few columns) shown in Fig.…”

“…Not only in the Database Constraint-Driven Design and Development (DCDDD) framework [1] of Software Engineering a final code polishing step in the software application development is included, for providing a user-friendly graphic user interface (GUI). Even if an application is correctly enforcing all business rules governing the corresponding subuniverse of discourse, almost nobody will accept at least to test it, not to speak of buying it, if its GUI is poorly designed and developed, no matter how glossy it looks.…”

“…The next section of this paper presents our proposed algorithm. Section 3 provides an example of applying it extracted from [5] and discusses contrastively these results vs. the lack of corresponding courtesy code. The paper ends with conclusion and further work, acknowledgement, and references.…”