Thumbnail
Access Restriction
Subscribed

Author Batra, Dinesh ♦ Antony, Solomon R.
Source ACM Digital Library
Content type Text
Publisher Association for Computing Machinery (ACM)
File Format PDF
Language English
Subject Domain (in DDC) Computer science, information & general works ♦ Computer programming, programs & data
Subject Keyword Human error ♦ Database design ♦ Expert system ♦ Entity-relationship ♦ Problem solving ♦ Relational ♦ Novice designers ♦ Patterns ♦ Consulting system
Abstract The paper describes the main features of a prototype tool CODASYS (COnceptual modeling tool for DAtabase SYStems), which purports to help novice designers engaged in conceptual data modeling. It is well known that conceptual data modeling is an error-prone process for novice database designers. The tool assists a designer in developing an entity-relationship diagram that can be translated to a normalized relational representation, free of derived dependencies. We first discuss a set of requirements for the tool that is based on achieving normal forms, on preventing data modeling errors, and on a theoretical foundation. We then discuss how the tool achieves the four normal forms and prevents common database errors such as incorrect degree, incorrect connectivity, and derived relationships. Further, we provide a cognitive framework for understanding novice error behavior and elaborate on how CODASYS addresses cognitive strain in database design. Next, we present the features of the tool and, with the help of flowcharts, discuss how these features have been implemented using a rule-based approach. It may be noted that empirical studies have been conducted to test the efficacy of the tool and have indicated significant improvement in novice designer performance.
Description Affiliation: Texas Tech University (Antony, Solomon R.) || Florida International University (Batra, Dinesh)
Age Range 18 to 22 years ♦ above 22 year
Educational Use Research
Education Level UG and PG
Learning Resource Type Article
Publisher Date 2007-02-28
Publisher Place New York
Journal ACM SIGMIS Database: the DATABASE for Advances in Information Systems (DATB)
Volume Number 33
Issue Number 3
Page Count 15
Starting Page 54
Ending Page 68


Open content in new tab

   Open content in new tab
Source: ACM Digital Library