{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,9,29]],"date-time":"2025-09-29T08:11:19Z","timestamp":1759133479127},"reference-count":28,"publisher":"Elsevier BV","issue":"3","license":[{"start":{"date-parts":[[1998,10,1]],"date-time":"1998-10-01T00:00:00Z","timestamp":907200000000},"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 &amp; Knowledge Engineering"],"published-print":{"date-parts":[[1998,10]]},"DOI":"10.1016\/s0169-023x(98)00007-x","type":"journal-article","created":{"date-parts":[[2002,7,25]],"date-time":"2002-07-25T19:06:41Z","timestamp":1027624001000},"page":"255-288","source":"Crossref","is-referenced-by-count":26,"title":["Complete rules for n-ary relationship cardinality constraints"],"prefix":"10.1016","volume":"27","author":[{"given":"Andrew","family":"McAllister","sequence":"first","affiliation":[]}],"member":"78","reference":[{"key":"10.1016\/S0169-023X(98)00007-X_BIB1","series-title":"Information Processing 74","first-page":"580","article-title":"Dependency structures of data base relationships","author":"Armstrong","year":"1974"},{"key":"10.1016\/S0169-023X(98)00007-X_BIB2","series-title":"Proc. 3rd ACM SIGMOD Intl. Conf. on Management of Data","first-page":"47","article-title":"A complete axiomatization for functional and multivalued dependencies in database relations","author":"Beeri","year":"1977"},{"issue":"1","key":"10.1016\/S0169-023X(98)00007-X_BIB3","doi-asserted-by":"crossref","first-page":"1","DOI":"10.1016\/0169-023X(93)90043-O","article-title":"On the design and maintenance of optimized relational representations of entity-relationship schemas","volume":"11","author":"Casanova","year":"1993","journal-title":"Data & Knowledge Eng."},{"issue":"1","key":"10.1016\/S0169-023X(98)00007-X_BIB4","doi-asserted-by":"crossref","first-page":"9","DOI":"10.1145\/320434.320440","article-title":"The entity-relationship model-toward a unified view of data","volume":"1","author":"Chen","year":"1976","journal-title":"ACM TODS"},{"key":"10.1016\/S0169-023X(98)00007-X_BIB5","series-title":"Proc. 5th Intl. Conf: on Data Engineering","first-page":"226","article-title":"Modeling semantic constraints with logic in the EARL data model","author":"Davis","year":"1989"},{"key":"10.1016\/S0169-023X(98)00007-X_BIB6","series-title":"Fundamentals of Database Systems","author":"Elmasri","year":"1994"},{"issue":"2","key":"10.1016\/S0169-023X(98)00007-X_BIB7","doi-asserted-by":"crossref","first-page":"157","DOI":"10.1016\/0169-023X(92)90008-Y","article-title":"Conceptual modelling of database applications using an extended ER model","volume":"9","author":"Engels","year":"1992","journal-title":"Data & Knowledge Eng."},{"key":"10.1016\/S0169-023X(98)00007-X_BIB8","doi-asserted-by":"crossref","first-page":"1","DOI":"10.1016\/S0019-9958(85)80017-6","article-title":"Normalization and axiomatization for numerical dependencies","volume":"65","author":"Grant","year":"1985","journal-title":"Information and Control"},{"key":"10.1016\/S0169-023X(98)00007-X_BIB9","doi-asserted-by":"crossref","first-page":"123","DOI":"10.1016\/0164-1212(84)90003-7","article-title":"Translation of entity-relationship diagrams into relational structures","volume":"4","author":"Jajodia","year":"1984","journal-title":"The Journal of Svstenrs and Software"},{"issue":"1","key":"10.1016\/S0169-023X(98)00007-X_BIB10","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 & Knowledge Eng."},{"issue":"3","key":"10.1016\/S0169-023X(98)00007-X_BIB11","doi-asserted-by":"crossref","first-page":"453","DOI":"10.1016\/0306-4379(90)90048-T","article-title":"On the satisfiability of dependency constraints in entity-relationship schemata","volume":"15","author":"Lenzerini","year":"1990","journal-title":"Information Svstems"},{"key":"10.1016\/S0169-023X(98)00007-X_BIB12","series-title":"Proc. 3rd Intl. Conf, on ER Approach","first-page":"529","article-title":"Cardinality constraints in the entity-relationship model","author":"Lenzerini","year":"1983"},{"issue":"3","key":"10.1016\/S0169-023X(98)00007-X_BIB13","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 & Knowledge Eng."},{"key":"10.1016\/S0169-023X(98)00007-X_BIB14","series-title":"Proc. 4th Intl. Conf. on ER Approach","first-page":"24","article-title":"A normal form for entity-relationship diagrams","author":"Ling","year":"1985"},{"key":"10.1016\/S0169-023X(98)00007-X_BIB15","series-title":"Proc. ACM SIGMOD Con. on Management of Data","first-page":"132","article-title":"Mapping a semantic database model to the relational model","author":"Lyngbaek","year":"1987"},{"issue":"3","key":"10.1016\/S0169-023X(98)00007-X_BIB16","doi-asserted-by":"crossref","first-page":"423","DOI":"10.1145\/132271.132273","article-title":"Representing extended entity-relationship structures in relational databases: A modular approach","volume":"17","author":"Markowitz","year":"1992","journal-title":"ACM TODS"},{"key":"10.1016\/S0169-023X(98)00007-X_BIB17","series-title":"Information Engineering, Planning & Analysis, Book 2","author":"Martin","year":"1990"},{"key":"10.1016\/S0169-023X(98)00007-X_BIB18","series-title":"Proc. 3rd Working Conf on Reverse Engineering","first-page":"121","article-title":"Reverse engineering a medical database","author":"McAllister","year":"1996"},{"issue":"2","key":"10.1016\/S0169-023X(98)00007-X_BIB19","doi-asserted-by":"crossref","first-page":"125","DOI":"10.1002\/(SICI)1097-024X(199802)28:2<125::AID-SPE146>3.0.CO;2-6","article-title":"An approach for decomposing n-ary data relationships","volume":"28","author":"McAllister","year":"1988","journal-title":"Software-Practice & Experience"},{"issue":"1","key":"10.1016\/S0169-023X(98)00007-X_BIB20","doi-asserted-by":"crossref","first-page":"50","DOI":"10.1109\/MC.1986.1663033","article-title":"Integrating user views in database design","volume":"19","author":"Navathe","year":"1986","journal-title":"IEEE Computer"},{"key":"10.1016\/S0169-023X(98)00007-X_BIB21","series-title":"Conceptual Modeling, Databases and CASE: An Integrated View of Information Systems Development","article-title":"ERC+: An object-based entity relationship approach","author":"Parent","year":"1992"},{"issue":"9","key":"10.1016\/S0169-023X(98)00007-X_BIB22","doi-asserted-by":"crossref","first-page":"95","DOI":"10.1145\/223248.223277","article-title":"Deriving functional dependencies from the entity-relationship model","volume":"38","author":"Ram","year":"1995","journal-title":"CACM"},{"key":"10.1016\/S0169-023X(98)00007-X_BIB23","doi-asserted-by":"crossref","first-page":"143","DOI":"10.1016\/0378-7206(83)90032-0","article-title":"MERISE: An information system design and development methodology","volume":"6","author":"Rochfeld","year":"1983","journal-title":"Information & Management"},{"issue":"2","key":"10.1016\/S0169-023X(98)00007-X_BIB24","doi-asserted-by":"crossref","first-page":"205","DOI":"10.1016\/0169-023X(92)90009-Z","article-title":"Relationship of relationships and other inter-relationship links in E-R model","volume":"9","author":"Rochfeld","year":"1992","journal-title":"Data & Knowledge Eng."},{"key":"10.1016\/S0169-023X(98)00007-X_BIB25","series-title":"Object-Oriented Modeling and Design","author":"Rumbaugh","year":"1991"},{"issue":"3","key":"10.1016\/S0169-023X(98)00007-X_BIB26","doi-asserted-by":"crossref","first-page":"293","DOI":"10.1016\/0169-023X(93)90033-L","article-title":"Database reverse engineering: From the relational to the binary relationship model","volume":"10","author":"Shoval","year":"1993","journal-title":"Data & Knowledge Eng."},{"issue":"2","key":"10.1016\/S0169-023X(98)00007-X_BIB27","doi-asserted-by":"crossref","first-page":"197","DOI":"10.1145\/7474.7475","article-title":"A logical design methodology for relational databases using the extended entity-relationship model","volume":"18","author":"Teorey","year":"1986","journal-title":"ACM Computing Surveys"},{"key":"10.1016\/S0169-023X(98)00007-X_BIB28","volume":"Vol I","author":"Ullman","year":"1988"}],"container-title":["Data &amp; Knowledge Engineering"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:S0169023X9800007X?httpAccept=text\/xml","content-type":"text\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:S0169023X9800007X?httpAccept=text\/plain","content-type":"text\/plain","content-version":"vor","intended-application":"text-mining"}],"deposited":{"date-parts":[[2019,4,23]],"date-time":"2019-04-23T01:56:59Z","timestamp":1555984619000},"score":1,"resource":{"primary":{"URL":"https:\/\/linkinghub.elsevier.com\/retrieve\/pii\/S0169023X9800007X"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[1998,10]]},"references-count":28,"journal-issue":{"issue":"3","published-print":{"date-parts":[[1998,10]]}},"alternative-id":["S0169023X9800007X"],"URL":"https:\/\/doi.org\/10.1016\/s0169-023x(98)00007-x","relation":{},"ISSN":["0169-023X"],"issn-type":[{"value":"0169-023X","type":"print"}],"subject":[],"published":{"date-parts":[[1998,10]]}}}