Database schema design: An experimental comparison between normalization and information analysis

Peretz Shoval; Moshe Even-Chaime

doi:10.1145/27544.27548

Database schema design: An experimental comparison between normalization and information analysis

Department of Industrial Engineering and Management

Research output: Contribution to journal › Article › peer-review

37 Scopus citations

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.

Original language	English
Pages (from-to)	30-39
Number of pages	10
Journal	Data Base for Advances in Information Systems
Volume	18
Issue number	3
DOIs	https://doi.org/10.1145/27544.27548
State	Published - 1 Mar 1987

ASJC Scopus subject areas

Management Information Systems
Computer Networks and Communications

Access to Document

10.1145/27544.27548

Cite this

@article{91d520845edb4d568e95bdb6db18464e,

title = "Database schema design: An experimental comparison between normalization and information analysis",

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.",

author = "Peretz Shoval and Moshe Even-Chaime",

year = "1987",

month = mar,

day = "1",

doi = "10.1145/27544.27548",

language = "English",

volume = "18",

pages = "30--39",

journal = "Data Base for Advances in Information Systems",

issn = "0095-0033",

publisher = "Association for Computing Machinery (ACM)",

number = "3",

}

TY - JOUR

T1 - Database schema design

T2 - An experimental comparison between normalization and information analysis

AU - Shoval, Peretz

AU - Even-Chaime, Moshe

PY - 1987/3/1

Y1 - 1987/3/1

N2 - 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.

AB - 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.

UR - https://www.scopus.com/pages/publications/0005284447

U2 - 10.1145/27544.27548

DO - 10.1145/27544.27548

M3 - Article

AN - SCOPUS:0005284447

SN - 0095-0033

VL - 18

SP - 30

EP - 39

JO - Data Base for Advances in Information Systems

JF - Data Base for Advances in Information Systems

IS - 3

ER -

Database schema design: An experimental comparison between normalization and information analysis

Abstract

ASJC Scopus subject areas

Access to Document

Other files and links

Fingerprint

Cite this