{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,18]],"date-time":"2026-03-18T21:38:55Z","timestamp":1773869935081,"version":"3.50.1"},"reference-count":32,"publisher":"Elsevier BV","issue":"2","license":[{"start":{"date-parts":[[2003,11,1]],"date-time":"2003-11-01T00:00:00Z","timestamp":1067644800000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.elsevier.com\/tdm\/userlicense\/1.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Data & Knowledge Engineering"],"published-print":{"date-parts":[[2003,11]]},"DOI":"10.1016\/s0169-023x(03)00049-1","type":"journal-article","created":{"date-parts":[[2003,4,5]],"date-time":"2003-04-05T00:18:15Z","timestamp":1049501895000},"page":"167-205","source":"Crossref","is-referenced-by-count":23,"title":["An analysis of structural validity in entity-relationship modeling"],"prefix":"10.1016","volume":"47","author":[{"given":"James","family":"Dullea","sequence":"first","affiliation":[]},{"given":"Il-Yeol","family":"Song","sequence":"additional","affiliation":[]},{"given":"Ioanna","family":"Lamprou","sequence":"additional","affiliation":[]}],"member":"78","reference":[{"key":"10.1016\/S0169-023X(03)00049-1_BIB1","series-title":"CASE*METHOD\u00ae: Entity Relationship Modeling","author":"Barker","year":"1990"},{"issue":"12","key":"10.1016\/S0169-023X(03)00049-1_BIB2","doi-asserted-by":"crossref","first-page":"1226","DOI":"10.1109\/TC.1976.1674590","article-title":"Software Engineering","volume":"25","author":"Boehm","year":"1976","journal-title":"IEEE Transactions on Computers"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB3","series-title":"Software Engineering Economics","author":"Boehm","year":"1981"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB4","series-title":"Proceedings of the 10th IEEE International Conference on Data Engineering (ICDE\u201994), Houston, TX, USA","first-page":"204","article-title":"On the interaction between ISA and cardinality constraints","author":"Calvanese","year":"1994"},{"issue":"1","key":"10.1016\/S0169-023X(03)00049-1_BIB5","doi-asserted-by":"crossref","first-page":"9","DOI":"10.1145\/320434.320440","article-title":"The entity-relationship model\u2013\u2013toward a unified view of data","volume":"1","author":"Chen","year":"1976","journal-title":"ACM Transactions on Database Systems"},{"issue":"3","key":"10.1016\/S0169-023X(03)00049-1_BIB6","doi-asserted-by":"crossref","first-page":"229","DOI":"10.1109\/TSE.1977.231132","article-title":"Management of Software Engineering","volume":"3","author":"Daly","year":"1977","journal-title":"IEEE Transactions on Software Engineering"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB7","doi-asserted-by":"crossref","unstructured":"J. Dullea, I.-Y. Song, An analysis of cardinality constraints in redundant relationships, in: Proceedings of the 6th International Conference on Information and Knowledge Management, Las Vegas, Nevada, USA, 10\u201314 November 1997, pp. 270\u2013277","DOI":"10.1145\/266714.266909"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB8","unstructured":"J. Dullea, I.-Y. Song, An analysis of structural validity in unary and binary relationships in entity relationship modeling, in: Proceedings of the 4th International Conference on Computer Science and Informatics, Research Triangle Park, NC, USA, 23\u201328 October, 1998, pp. 329\u2013334"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB9","doi-asserted-by":"crossref","unstructured":"J. Dullea, I.-Y. Song, A taxonomy of recursive relationships and their structural validity in ER modeling, in: Proceedings of the 18th International Conference on Conceptual Modeling (ER\u201999), Paris, France, 15\u201318 November 1999, pp. 384\u2013398","DOI":"10.1007\/3-540-47866-3_26"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB10","series-title":"Fundamentals of Database Systems","author":"Elmasri","year":"2000"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB11","unstructured":"M. Fagan, Design and code inspections and process control in the development of programs, IBM Report IBM-SDD-TR-21-572, December 1974"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB12","unstructured":"S. Ferg, Cardinality constraints in entity-relationship modeling, in: Proceedings of the 10th International Conference on Entity-Relationship Approach (ER\u201991), 23\u201325 October, 1991, San Mateo, California, USA, ER Institute, 1991, pp. 1\u201330"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB13","unstructured":"H. Habrias, P. Legrand, A description of rules through occurring\/synthetic cardinalities, in: Proceedings of the 7th International Conference on Entity-Relationship Approach (ER\u201988), Rome, Italy, November 16\u201318, 1988, North-Holland, Amesterdam, 1989, pp. 509\u2013525"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB14","unstructured":"S. Hartmann, Global Cardinality Constraints, in: Proceedings of the Workshop Challenges of Application and Challenges of Design, 15th International Conference on Conceptual Modeling, Cottbus, Germany, October 9, 1996, Brandenburg Technical University, 1996, pp. 196\u2013206"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB15","doi-asserted-by":"crossref","unstructured":"S. Hartmann, On the Consistency of Int-cardinality Constraints, in: Proceedings of the 17th International Conference on Conceptual Modeling (ER\u201998), Singapore, November 16\u201319, 1998, Lecture Notes in Computer Science 1507, Springer, Berlin, 1998, pp. 150\u2013163","DOI":"10.1007\/978-3-540-49524-6_12"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB16","doi-asserted-by":"crossref","unstructured":"S. Hartmann, On interactions of cardinality constraints, key, and functional dependencies, in: K.-D. Schewe, B. Thalheim (Eds.), Proceeding of the Foundations of Information and Knowledge Systems, First International Symposium (FoIKS 2000), Burg, Germany, 14\u201317 February 2000, Lecture Notes in Computer Science 1762, Springer 2000, pp. 136\u2013155","DOI":"10.1007\/3-540-46564-2_9"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB17","series-title":"Data Analysis for Data Base Design","author":"Howe","year":"1989"},{"issue":"1","key":"10.1016\/S0169-023X(03)00049-1_BIB18","doi-asserted-by":"crossref","first-page":"39","DOI":"10.1016\/0169-023X(95)00036-R","article-title":"Analysis of binary\/ternary cardinality combinations in entity-relationship modeling","volume":"19","author":"Jones","year":"1996","journal-title":"Data and Knowledge Engineering"},{"issue":"2","key":"10.1016\/S0169-023X(03)00049-1_BIB19","doi-asserted-by":"crossref","first-page":"12","DOI":"10.4018\/jdm.2000040102","article-title":"Binary equivalents of ternary relationships in E-R modeling: A logical decomposition approach","volume":"11","author":"Jones","year":"2000","journal-title":"Journal of Database Management"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB20","unstructured":"M. Lenzerini, G. Santucci, Cardinality constraints in the entity-relationship model, in: Proceedings of the 3rd International Conference on Entity-Relationship Approach (ER\u201983). Anaheim, California, USA, Elsevier Science Publishers B.V., North Holland, 1983, pp. 529\u2013549"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB21","doi-asserted-by":"crossref","first-page":"235","DOI":"10.1016\/0169-023X(93)90024-J","article-title":"Cardinality constraints in semantic data models","volume":"11","author":"Liddle","year":"1993","journal-title":"Data and Knowledge Engineering"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB22","doi-asserted-by":"crossref","first-page":"255","DOI":"10.1016\/S0169-023X(98)00007-X","article-title":"Complete rules for n-ary relationship cardinality constraints","volume":"27","author":"McAllister","year":"1998","journal-title":"Data and Knowledge Engineering"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB23","series-title":"Entity-Relationship Approach to Systems Analysis and Design","article-title":"Abstraction capabilities and invariant properties modelling within the entity-relationship approach","author":"Scheuermann","year":"1980"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB24","series-title":"Database System Concepts","author":"Silberschatz","year":"2001"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB25","doi-asserted-by":"crossref","unstructured":"I.-Y. Song, T.H. Jones, An analysis of binary relationships within ternary relationships in ER modeling, in: Proceedings of the 12th International Conference on Entity-Relationship Approach (ER\u201993), Arlington, Texas, USA, December 15\u201317, 1993, pp. 265\u2013276","DOI":"10.1007\/BFb0024373"},{"issue":"4","key":"10.1016\/S0169-023X(03)00049-1_BIB26","first-page":"427","article-title":"A comparative analysis of entity-relationship diagrams","volume":"3","author":"Song","year":"1995","journal-title":"Journal of Computer and Software Engineering"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB27","series-title":"Database Modeling and Design","author":"Teorey","year":"1999"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB28","doi-asserted-by":"crossref","unstructured":"B. Thalheim, Fundamentals of cardinality constraints, in: Proceedings of the 11th International Conference on the Entity-Relationship Approach (ER\u201992), Karlsruhe, Germany, 7\u20139 October 1992, Lecture Notes in Computer Science 654, Springer, Berlin, 1992, pp. 7\u201323","DOI":"10.1007\/3-540-56023-8_3"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB29","series-title":"Entity Relationship Modeling: Fundamentals of Database Technology","author":"Thalheim","year":"2000"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB30","series-title":"A Practical Guide to Logical Data Modeling","author":"Tillman","year":"1993"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB31","doi-asserted-by":"crossref","unstructured":"X. Ye, C. Parent, S. Spaccapietra, Cardinality consistency of derived objects in DOOD systems, in: Proceedings of the 13th International Conference on the Entity-Relationship Approach (ER\u201994) Business Modelling and Re-Engineering, Manchester, UK, 13\u201316 December 1994, Lecture Notes in Computer Science 881, Springer, Berlin, 1994, pp. 278\u2013295","DOI":"10.1007\/3-540-58786-1_85"},{"key":"10.1016\/S0169-023X(03)00049-1_BIB32","doi-asserted-by":"crossref","unstructured":"J. Zhou, P. Baumann, Evaluation of complex cardinality constraints, in: Proceedings of the 11th International Conference on the Entity-Relationship Approach (ER\u201992), Karlsruhe, Germany, 7\u20139 October 1992, Lecture Notes in Computer Science 654, Springer, Berlin, 1992, pp. 24\u201340","DOI":"10.1007\/3-540-56023-8_4"}],"container-title":["Data & Knowledge Engineering"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:S0169023X03000491?httpAccept=text\/xml","content-type":"text\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:S0169023X03000491?httpAccept=text\/plain","content-type":"text\/plain","content-version":"vor","intended-application":"text-mining"}],"deposited":{"date-parts":[[2019,3,27]],"date-time":"2019-03-27T06:29:10Z","timestamp":1553668150000},"score":1,"resource":{"primary":{"URL":"https:\/\/linkinghub.elsevier.com\/retrieve\/pii\/S0169023X03000491"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2003,11]]},"references-count":32,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2003,11]]}},"alternative-id":["S0169023X03000491"],"URL":"https:\/\/doi.org\/10.1016\/s0169-023x(03)00049-1","relation":{},"ISSN":["0169-023X"],"issn-type":[{"value":"0169-023X","type":"print"}],"subject":[],"published":{"date-parts":[[2003,11]]}}}