Abstract
Conceptual and logical database modelling are difficult tasks for designers, and the potential for committing and correcting errors is significant. This paper reports on two laboratory experiments that investigated the underlying causes of errors committed by novice designers engaged in conceptual database modelling tasks. These causes can be traced to combinatorial complexity of the task, biases resulting from misapplication of heuristics, and incomplete knowledge about database design. The most common error was that subjects translated their initial understanding of the application into final database structures and did not consider alternative hypotheses and solutions. The paper includes recommendations to reduce the occurrence of errors.
Similar content being viewed by others
Author information
Authors and Affiliations
Rights and permissions
About this article
Cite this article
Batra, D., Antony, S. Novice errors in conceptual database design. Eur J Inf Syst 3, 57–69 (1994). https://doi.org/10.1057/ejis.1994.7
Published:
Issue Date:
DOI: https://doi.org/10.1057/ejis.1994.7