Database schema design: an experimental comparison between normalization and information analysis
- 1 March 1987
- journal article
- Published by Association for Computing Machinery (ACM) in ACM SIGMIS Database: the DATABASE for Advances in Information Systems
- Vol. 18 (3) , 30-39
- https://doi.org/10.1145/27544.27548
Abstract
This article compares two different methods for designing a data base schema-normalization and information analysis (IA). A set of design tasks was assigned to two groups of analysts who were trained to use the two methods in conjunction with the structured analysis method of system analysis. The results of the experiment revealed that the quality of the data base schemata designed using normalization was better than that designed using IA, that normalization required less time than IA to perform, and that the analysts preferred normalization.Keywords
This publication has 6 references indexed in Scilit:
- ADDS: A system for automatic database schema design based on the binary-relationship modelData & Knowledge Engineering, 1987
- Essential information structure diagrams and database schema designInformation Systems, 1985
- A simple guide to five normal forms in relational database theoryCommunications of the ACM, 1983
- Human Factors Studies of Database Query Languages: A Survey and AssessmentACM Computing Surveys, 1981
- Interactive support for non-programmersPublished by Association for Computing Machinery (ACM) ,1975
- A relational model of data for large shared data banksCommunications of the ACM, 1970