Representing multivalued attributes in database design.

Authors

Mark I. Hwang
Jack D. Becker
Jerry W. Lin, University of South Florida St. PetersburgFollow

SelectedWorks Author Profiles:

Wenshan Lin

Document Type

Article

Publication Date

2001

ISSN

1529-7314

Abstract

An important aspect of data modeling is the identification of entities or objects and their associated attributes. An attribute may be single-valued or multivalued. During database design, the designer usually has to represent all attributes in relational tables that only allow single-valued cells. A number of authors (1, 3, 5, 6) advocate the notion that multivalued attributes are essentially separate entities and, therefore, should be represented as a separate table. We argue that some multivalued attributes should be treated as entities, but others simply are not and should, therefore, not be treated as entities. Assuming that all multivalued attributes are entities creates confusion and results in an inefficient design. We discuss alternative designs, such as storing multiple values in one cell, that should be used for different types of multivalued attributes. We also present a decision table for easy reference by designers in dealing with multivalued attributes.

Publisher

International Association for Computer Information Systems

Recommended Citation

Hwang, M.I., Becker, J.D. & Lin, J.W. (2001). Representing multivalued attributes in database design. Issues in Information Systems, 2, 160-166.

Creative Commons License

This work is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 4.0 License.