Assisted Deployment of Relational Databases in Firebird / Interbase

Abstract

An universe of discourse (UoD) can be represented from conceptual design translatable into a logical relational data model and it can be implemented using a relational database management system such as Firebird/Interbase (FB). FB has several technologies e.g.: triggers, stored procedures, select stored procedures; they enable the following generic implementation issues e.g.: derived attributes, max cardinality, type – subtype relationship mutuallyexclusive, regular entity type – weak entity type with ascending consecutive discriminator. These typical issues framed into two possible and extreme implementation model: direct interaction (model A) and indirect interaction (model B) over database tables. I develop each generic implementation issue in both models: A and B; the whole development can be automatized using an ad hoc software developed for this paper, it makes easier a correct implementation of relational databases.