The DOI matches its Crossref record; 21 of the 21 references it cites were found in a registry or an index.
Should Optional Properties Be Used in Conceptual Modelling? A Theory and Three Empirical Tests
Abstract
An important feature of some conceptual modelling grammars is the features they provide to allow database designers to show real-world things may or may not possess a particular attribute or relationship. In the entity-relationship model, for example, the fact that a thing may not possess an attribute can be represented by using a special symbol to indicate that the attribute is optional. Similarly, the fact that a thing may or may not be involved in a relationship can be represented by showing the minimum cardinality of the relationship as zero. Whether these practices should be followed, however, is a contentious issue. An alternative approach is to eliminate optional attributes and relationships from conceptual schema diagrams by using subtypes that have only mandatory attributes and relationships. In this paper, we first present a theory that led us to predict that optional attributes and relationships should be used in conceptual schema diagrams only when users of the diagrams require a surface-level understanding of the domain being represented by the diagrams. When users require a deep-level understanding, however, optional attributes and relationships should not be used because they undermine users' abilities to grasp important domain semantics. We describe three experiments which we then undertook to test our predictions. The results of the experiments support our predictions.
Overview
The claims and statistics of this paper haven’t been checked yet.
Free: it reads the open-access text and checks the first 5 claims that cite a source we can check. Create a free account to check every claim.
Integrity signals
Registry
Cites
Statistics
Verification
Claims the paper makes
The claims and statistics of this paper haven’t been checked yet.
Free: it reads the open-access text and checks the first 5 claims that cite a source we can check. Create a free account to check every claim.
Self-check
Percentages, sums and reported differences re-computed from the paper’s own numbers.
The self-check needs the paper’s full text.
Citations
Cites
Newell, A. (1972) · Cited by 6,222
Software Engineering Economics
Boehm, B. W. (2001) · Pioneers and Their Contributions to Software Engineering · doi:10.1007/978-3-642-48354-7_5 · Cited by 5,981
Retrieval time from semantic memory
Collins, A. M., & Quillian, M. R. (1969) · Journal of Verbal Learning and Verbal Behavior · doi:10.1016/s0022-5371(69)80069-1 · Cited by 3,109
When is an illustration worth ten thousand words?
Mayer, R. E., & Gallini, J. K. (1990) · Journal of Educational Psychology · doi:10.1037/0022-0663.82.4.715 · Cited by 1,051
Conceptual Database Design: An Entity-Relationship Approach
Batini, C., Ceri, S., & Navathe, S. B. (1991) · CERN Document Server (European Organization for Nuclear Research) · Cited by 883
Software engineering economics: background, current practices, and future directions
Erdogmus, H., Boehm, B. W., Harrison, W., Reifer, D. J., & Sullivan, K. J. (2002) · Proceedings of the 24th international conference on Software engineering - ICSE '02 · doi:10.1145/581441.581444 · Cited by 711
Mayer, R. E. (1989) · Review of Educational Research · doi:10.2307/1170446 · Cited by 671
Bunge, M. (1977) · Springer eBooks · doi:10.1007/978-94-010-9924-0 · Cited by 648
An ontological analysis of the relationship construct in conceptual modeling
Wand, Y., Storey, V. C., & Weber, R. (1999) · ACM Transactions on Database Systems · doi:10.1145/331983.331989 · Cited by 411
Self-citationAshcraft, M. H. (1989) · Cited by 350
Cited by
Design Science in Information Systems Research1
Hevner, A. R., March, S. T., Park, J., & Ram, S. (2004) · MIS Quarterly · doi:10.2307/25148625 · Cited by 10,707
Design science in information systems research
(2004) · Journal of the Association for Information Systems · doi:10.5555/2017212.2017217 · Cited by 8,254
Moody, D. (2009) · IEEE Transactions on Software Engineering · doi:10.1109/tse.2009.67 · Cited by 1,204
Research Commentary: Information Systems and Conceptual Modeling—A Research Agenda
Wand, Y., & Weber, R. (2002) · Information Systems Research · doi:10.1287/isre.13.4.363.69 · Cited by 755
Self-citationBusiness Process Modeling- A Comparative Analysis
Queensland University of Technology, Recker, J., Rosemann, M., Queensland University of Technology, Indulska, M., The University of Queensland, Green, P., & The University of Queensland (2009) · Journal of the Association for Information Systems · doi:10.17705/1jais.00193 · Cited by 361
Metadata
- Authors
- Bodart, F., Patel, A., Sim, M., & Weber, R.
- Venue
- Information Systems Research
- Published
- 2001-12
- Volume
- 12
- Issue
- 4
- Pages
- 384-405
- ISSN
- 1047-7047 (ISSN-L)
- 1526-5536
- OpenAlex
- W2115570246
- Cited by
- 296
- References
- 21
- FWCI
- 40.81
- Type
- journal article
- Language
- en
- Open access
- closed
About these checks
Registry, retraction, Cites and statistics results are computed, not judged, with one exception: a printed reference that no index lists is read once by a model before it counts as a citation error. Claims are extracted by a model and kept only when their quote appears verbatim in the text; each cited source is then checked, with a model’s help, for whether it says what the claim relies on. Those verdicts can be wrong — read the claim’s quote and the cited source before relying on one.
Statistics and arithmetic are recomputed, not judged.
Confidence bands are shown only for fields calibrated on our annotated test set. None is calibrated yet, so no band is shown.
What counts as a claim ›How we measure confidence ›How we check this ›
Are you an author, or do you see a problem with this page? Request a review
How to cite
Cite CoChat for the checks on this page, and the paper for its own findings.
- This page
- CoChat. (2026). Citation check: Should Optional Properties Be Used in Conceptual Modelling? A Theory and Three Empirical Tests. https://app.cochat.ai/papers/10.1287/isre.12.4.384.9702
- The paper
- Bodart, F., Patel, A., Sim, M., & Weber, R. (2001). Should Optional Properties Be Used in Conceptual Modelling? A Theory and Three Empirical Tests. Information Systems Research. https://doi.org/10.1287/isre.12.4.384.9702
Data sources
Bibliographic data: Semantic Scholar, OpenAlex, Crossref.
Contains information from the Semantic Scholar Academic Graph Datasets, made available under the ODC Attribution License (ODC-BY 1.0).
Semantic Scholar’s data is described in: Kinney, R., et al. (2023). The Semantic Scholar Open Data Platform. arXiv:2301.10140.