Information Systems & Analytics: Faculty Publications

Comparing Two Bottom-Up Database Design Methods

Document Type

Conference Proceeding

Publication Date

2007

Publication Title

Proceedigns of the Southern Association for Information Systems Annual Conference

Abstract

Bottom-up database design is a difficult task for novice database designers and is particularly challenging to teach. To address the problem, two methods—textbook and cookbook—have been suggested. The textbook method describes the Codd’s normalization algorithm and data model visualization adopted by most textbooks. The cookbook method illustrates a simple and straightforward normalization algorithm and ER diagram mapping technique proposed by the authors. This paper describes the conceptual framework, experimental design, and results of a laboratory study that employed novice designers to compare the error rates of the two methods (between subjects) at two levels of task complexity. Results indicate that the cookbook method led to significant lower error rates.

Copyright

This work is archived and distributed under the repository's Standard Copyright and Reuse License (opens in new tab). End users may copy, store, and distribute this work without restriction. For all other uses, permission must be obtained from the copyright owners or their authorized agents.

Share

COinS