{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2023,1,30]],"date-time":"2023-01-30T18:29:09Z","timestamp":1675103349753},"reference-count":56,"publisher":"Springer Science and Business Media LLC","issue":"4","license":[{"start":{"date-parts":[[2012,2,24]],"date-time":"2012-02-24T00:00:00Z","timestamp":1330041600000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Softw Syst Model"],"published-print":{"date-parts":[[2013,10]]},"DOI":"10.1007\/s10270-012-0234-3","type":"journal-article","created":{"date-parts":[[2012,2,23]],"date-time":"2012-02-23T09:42:04Z","timestamp":1329990124000},"page":"871-889","source":"Crossref","is-referenced-by-count":3,"title":["Guidelines for representing complex cardinality constraints in binary and ternary relationships"],"prefix":"10.1007","volume":"12","author":[{"given":"Dolores","family":"Cuadra","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Paloma","family":"Mart\u00ednez","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Elena","family":"Castro","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Harith","family":"Al-Jumaily","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2012,2,24]]},"reference":[{"key":"234_CR1","unstructured":"Abrial, J.R.: Data Semantics, pp. 1\u201359. North-Holland, Amsterdam (1974)"},{"key":"234_CR2","unstructured":"Al-Jumaily, H., Cuadra, D., Martinez, P.: The execution model to transform the associate semantics of cardinality constraints in a relational DBMS. In: Proceedings of the 4st International Conference on Enterprise Information Systems, Ciudad Real, Spain, April 2\u20136, pp. 819\u2013822 (2002)"},{"key":"234_CR3","doi-asserted-by":"crossref","unstructured":"Al-Jumaily, H., Cuadra, D., Martinez, P.: Applying a fuzzy approach to relaxing cardinality constraints. In: 15th International Conference on Database and Expert Systems Applications, Lectures Notes, Zaragoza (Spain), pp. 654\u2013662, September 2004","DOI":"10.1007\/978-3-540-30075-5_63"},{"key":"234_CR4","unstructured":"Al-Jumaily, H., Cuadra, D., Martinez, P.: PANDORA CASE Tool: triggers generating for cardinality constraints in RDBMS. In: Proceedings of the IADIS International Conference WWW\/Internet 2003, Algarve (Portugal), pp. 999\u20131002, November 2003"},{"key":"234_CR5","unstructured":"Al-Jumaily, H., Cuadra, D., Martinez, P.: Plugging Active Mechanisms to Control Dynamic Aspects Derived From The Multiplicity Constraint In UML. The Workshop of 7th International Conference on the Unified Modeling Language. Doctoral symposium. Lisbon (Portugal), October (2004)"},{"issue":"1","key":"234_CR6","doi-asserted-by":"crossref","first-page":"77","DOI":"10.1145\/974121.974135","volume":"33","author":"A. Badia","year":"2004","unstructured":"Badia A.: Entity-relationship modeling revisited. SIGMOD Record 33(1), 77\u201382 (2004)","journal-title":"SIGMOD Record"},{"key":"234_CR7","volume-title":"Case*Method: Entity Relationship Modelling","author":"R. Barke","year":"1990","unstructured":"Barke R.: Case*Method: Entity Relationship Modelling. Addison Wesley, New York (1990)"},{"key":"234_CR8","volume-title":"Conceptual Database Design: An Entity-Relationship Approach","author":"C. Batini","year":"1992","unstructured":"Batini C., Ceri S., Navathe S.B.: Conceptual Database Design: An Entity-Relationship Approach. Benjamin\/Cummings, San Francisco (1992)"},{"issue":"3","key":"234_CR9","doi-asserted-by":"crossref","first-page":"228","DOI":"10.1057\/ejis.1994.23","volume":"3","author":"D. Batra","year":"1994","unstructured":"Batra D., Zanakis H.: A conceptual database design approach based on rules and heuristics. Eur. J. Inf. Syst. 3(3), 228\u2013239 (1994)","journal-title":"Eur. J. Inf. Syst."},{"issue":"1","key":"234_CR10","doi-asserted-by":"crossref","first-page":"57","DOI":"10.1057\/ejis.1994.7","volume":"3","author":"D. Batra","year":"1994","unstructured":"Batra D., Antony S.R.: Novice errors in conceptual database design. Eur. J. Inf. Syst. 3(1), 57\u201369 (1994)","journal-title":"Eur. J. Inf. Syst."},{"key":"234_CR11","volume-title":"Designing Quality Databases with IDEF1X Information Models","author":"T.A. Bruce","year":"1992","unstructured":"Bruce T.A.: Designing Quality Databases with IDEF1X Information Models. Dorset House, New York (1992)"},{"key":"234_CR12","doi-asserted-by":"crossref","unstructured":"Cal\u00ed, A.: Querying Incomplete Data with Logic Programs: ER Strikes Back. Parent, C., et\u00a0al. (eds.) ER 2007, LNCS 4801, pp. 245\u2013260 (2007)","DOI":"10.1007\/978-3-540-75563-0_18"},{"key":"234_CR13","doi-asserted-by":"crossref","first-page":"46","DOI":"10.1145\/565117.565125","volume":"31","author":"R. Camps","year":"2002","unstructured":"Camps R.: From ternary relationship to relational tables: a case against common beliefs. ACM\/SIGMOD Record 31, 46\u201349 (2002)","journal-title":"ACM\/SIGMOD Record"},{"key":"234_CR14","doi-asserted-by":"crossref","unstructured":"Castro, E., Cuadra, D., Mart\u00ednez, P., Iglesias, A.: Integrating Intelligent Methodological Tutoring assistant in a CASE Platform: The PANDORA Experience, Informing Science + IT Education Conference 2002, Cork (Ireland), May 2002","DOI":"10.28945\/2458"},{"issue":"2","key":"234_CR15","first-page":"191","volume":"2","author":"E. Castro","year":"2003","unstructured":"Castro E., Cuadra D., Mart\u00ednez P.: An empirical perspective of using ternary relationship in database conceptual modeling. Inf. Educ. 2(2), 191\u2013200 (2003)","journal-title":"Inf. Educ."},{"issue":"1","key":"234_CR16","doi-asserted-by":"crossref","first-page":"9","DOI":"10.1145\/320434.320440","volume":"1","author":"P.P. Chen","year":"1976","unstructured":"Chen P.P.: The entity-relationship model: toward a unified view of data. ACM Trans. Database Syst. 1(1), 9\u201336 (1976)","journal-title":"ACM Trans. Database Syst."},{"issue":"6","key":"234_CR17","doi-asserted-by":"crossref","first-page":"377","DOI":"10.1145\/362384.362685","volume":"13","author":"E.F. Codd","year":"1970","unstructured":"Codd E.F.: A relational model of data for large shared data banks. Commun. ACM 13(6), 377\u2013387 (1970)","journal-title":"Commun. ACM"},{"issue":"4","key":"234_CR18","doi-asserted-by":"crossref","first-page":"397","DOI":"10.1145\/320107.320109","volume":"4","author":"E.F. Codd","year":"1979","unstructured":"Codd E.F.: Extending the database relational model to capture more meaning. ACM Trans. Database Syst. 4(4), 397\u2013434 (1979)","journal-title":"ACM Trans. Database Syst."},{"issue":"3","key":"234_CR19","doi-asserted-by":"crossref","first-page":"358","DOI":"10.1109\/TE.2009.2022632","volume":"53","author":"D. Cuadra","year":"2010","unstructured":"Cuadra D., Iglesias A., Castro E., Mart\u00ednez P.: Educational experiences detecting, using and representing ternary relationships in database design. IEEE Trans. Educ. 53(3), 358\u2013364 (2010)","journal-title":"IEEE Trans. Educ."},{"key":"234_CR20","doi-asserted-by":"crossref","unstructured":"Cuadra, D., Mart\u00ednez, P., Castro, E.: Relationship cardinality constraints in relational database design. Encyclopedia of Information Science and Technology. Idea Group Publishing, IV, pp. 2419\u20132424 (2005)","DOI":"10.4018\/978-1-59140-553-5.ch428"},{"key":"234_CR21","doi-asserted-by":"crossref","first-page":"358","DOI":"10.1016\/j.datak.2005.07.007","volume":"58","author":"I. Davies","year":"2006","unstructured":"Davies I., Green P., Rosemann M., Indulska M., Gallo S.: How do practitioners use conceptual modeling in practice?. Data Knowl. Eng. 58, 358\u2013380 (2006)","journal-title":"Data Knowl. Eng."},{"key":"234_CR22","doi-asserted-by":"crossref","unstructured":"Dullea, I.: Song, IL.-Y.: An analysis of the structural validity of ternary relationships in entity-relationship modeling. In: Proceedings of the 7th International Conference on Information and Knowledge Management, pp. 331\u2013339, November 1998","DOI":"10.1145\/288627.288674"},{"key":"234_CR23","doi-asserted-by":"crossref","unstructured":"Eisenberg, A., Melton, J., Kulkarni, K., Michels, J.E., Zemke, F.: SQL: 2003 Has Been Published. SIGMOD Record, 33, 1, March 2004","DOI":"10.1145\/974121.974142"},{"key":"234_CR24","volume-title":"Fundamentals of Database Systems","author":"R. Elmasri","year":"2007","unstructured":"Elmasri R., Navathe S.B.: Fundamentals of Database Systems, 5th edn. Addison-Wesley, New York (2007)","edition":"5"},{"key":"234_CR25","doi-asserted-by":"crossref","first-page":"213","DOI":"10.1016\/0169-023X(95)00006-E","volume":"15","author":"C. Fahrner","year":"1995","unstructured":"Fahrner C., Vossen G.: A survey of database design transformations based on the entity-relationship model. Data Knowl. Eng. 15, 213\u2013250 (1995)","journal-title":"Data Knowl. Eng."},{"key":"234_CR26","unstructured":"Ferg, S.: Cardinality concepts in entity relationship. In: Proceedings of the 10th International Conference on the Entity Relationship Approach (1991)"},{"key":"234_CR27","volume-title":"Database Systems: The Complete Book","author":"H. Garcia-Molina","year":"2008","unstructured":"Garcia-Molina H., Ullman J.D., Widom J.: Database Systems: The Complete Book, 2nd edn. Prentice-Hall, Upper Saddle River (2008)","edition":"2"},{"issue":"3","key":"234_CR28","doi-asserted-by":"crossref","first-page":"301","DOI":"10.1016\/j.datak.2004.12.009","volume":"55","author":"A. Gemino","year":"2005","unstructured":"Gemino A., Wand Y.: Complexity and clarify in conceptual modeling: comparison of mandatory and optional properties. Data Knowl. Eng. 55(3), 301\u2013326 (2005)","journal-title":"Data Knowl. Eng."},{"key":"234_CR29","unstructured":"G\u00e9nova, G., Llorens, J., Mart\u00ednez, P.: The meaning of multiplicity of N-ary associations in UML. J. Softw. Syst. Model. 1(2), 86\u201397 (2002). http:\/\/www.sosym.org\/"},{"key":"234_CR30","doi-asserted-by":"crossref","unstructured":"Halpin, T.: Information Modeling and Relational Databases: from Conceptual Analysis to Logical Design. Morgan Kaufman, San Francisco (2001)","DOI":"10.1016\/B978-155860672-2\/50014-2"},{"key":"234_CR31","volume-title":"Database Management and Design","author":"G. Hansen","year":"1995","unstructured":"Hansen G., Hansen J.: Database Management and Design. Prentice-Hall, Upper Saddle River (1995)"},{"key":"234_CR32","doi-asserted-by":"crossref","first-page":"64","DOI":"10.1109\/MC.2004.172","volume":"37","author":"D. Harel","year":"2004","unstructured":"Harel D., Rumpe B.: Meaningful Modeling: What\u2019s the Semantics of \u201cSemantics\u201d. IEEE Comput. 37, 64\u201371 (2004)","journal-title":"IEEE Comput."},{"key":"234_CR33","doi-asserted-by":"crossref","first-page":"253","DOI":"10.1023\/A:1013133428451","volume":"33","author":"H. Hartmann","year":"2001","unstructured":"Hartmann H.: On implication problem for cardinality constraints and functional dependencies. Ann. Math. Artif. Intell. 33, 253\u2013307 (2001)","journal-title":"Ann. Math. Artif. Intell."},{"key":"234_CR34","doi-asserted-by":"crossref","first-page":"1128","DOI":"10.1016\/j.datak.2009.06.001","volume":"68","author":"H. Hartmann","year":"2009","unstructured":"Hartmann H., Link S., Trinh T.: Constraint acquisition for entity-relationship models. Data Knowl. Eng. 68, 1128\u20131155 (2009)","journal-title":"Data Knowl. Eng."},{"key":"234_CR35","doi-asserted-by":"crossref","first-page":"299","DOI":"10.1016\/j.datak.2005.07.005","volume":"58","author":"Q. He","year":"2006","unstructured":"He Q., Wang Ling T.: An ontology based approach to the integration of entity-relationship schemas. Data Knowl. Eng. 58, 299\u2013326 (2006)","journal-title":"Data Knowl. Eng."},{"key":"234_CR36","unstructured":"Iglesias, A., Mart\u00ednez, P., Cuadra, D., Castro, E., Fernandez, F.: Learning to teach database design by trial and error. ICEIS 2002, Proceedings of the 4st International Conference on Enterprise Information Systems, pp. 500\u2013505, Ciudad Real, Spain, April 2\u20136, 2002"},{"issue":"2","key":"234_CR37","doi-asserted-by":"crossref","first-page":"67","DOI":"10.1007\/s007780050054","volume":"7","author":"N. Ishakbeyoglu","year":"1998","unstructured":"Ishakbeyoglu N., Z.M.: Maintenance of implication integrity constraints under updates to constraints. J. Very Large Database 7(2), 67\u201378 (1998)","journal-title":"J. Very Large Database"},{"key":"234_CR38","doi-asserted-by":"crossref","first-page":"12","DOI":"10.4018\/jdm.2000040102","volume":"11","author":"T.H. Jones","year":"2000","unstructured":"Jones T.H., Song IL-Y.: Binary equivalents of ternary relationships in entity-relationship modeling: a logical decomposition approach. J. Database Manag. 11, 12\u201319 (2000)","journal-title":"J. Database Manag."},{"key":"234_CR39","volume-title":"Database Systems Concepts","author":"H.F. Korth","year":"2005","unstructured":"Korth H.F., Silberschatz A., Sudarshan S.: Database Systems Concepts, 5th edn. McGraw-Hill, New York (2005)","edition":"5"},{"key":"234_CR40","unstructured":"Mart\u00ednez, P., De Miguel, A., Cuadra, D., Castro, E.: Data Conceptual Modeling through Natural Language: Identification and Validation of Relationship Cardinalities. Information Resources Management Association (IRMA 2000), Anchorage (EEUU), pp. 500\u2013504, May 2000"},{"key":"234_CR41","doi-asserted-by":"crossref","first-page":"255","DOI":"10.1016\/S0169-023X(98)00007-X","volume":"27","author":"A. McAllister","year":"1998","unstructured":"McAllister A.: Complete rules for n-ary relationship cardinality constraints. Data Knowl. Eng. 27, 255\u2013288 (1998)","journal-title":"Data Knowl. Eng."},{"key":"234_CR42","doi-asserted-by":"crossref","first-page":"619","DOI":"10.1016\/S0306-4379(02)00043-1","volume":"28","author":"D.L. Moody","year":"2003","unstructured":"Moody D.L., Shanks G.G.: Improving the quality of data models: empirical validation of a quality management framework. Inf. Syst. 28, 619\u2013650 (2003)","journal-title":"Inf. Syst."},{"key":"234_CR43","doi-asserted-by":"crossref","unstructured":"Parent, C., Spaccapietra, S., Zim\u00e1nyi, E.: Spatio-temporal conceptual models: data structures, space and time. In: Proceedings of the 7th ACM International Symposium on Advances in Geographic Information Systems, pp. 26\u201333 (1999)","DOI":"10.1145\/320134.320142"},{"key":"234_CR44","doi-asserted-by":"crossref","first-page":"187","DOI":"10.1016\/j.ijhcs.2004.01.003","volume":"61","author":"H.C. Purchase","year":"2004","unstructured":"Purchase H.C., Welland R., McGill M., Colpoys L.: Comprehension of diagram syntax: an empirical study of entity relationship notations. Int. J. Human-Comput. Stud. 61, 187\u2013203 (2004)","journal-title":"Int. J. Human-Comput. Stud."},{"key":"234_CR45","doi-asserted-by":"crossref","first-page":"89","DOI":"10.1016\/j.is.2003.10.008","volume":"30","author":"S. Ram","year":"2005","unstructured":"Ram S., Khatri V.: A comprehensive framework for modeling set-based business rules during conceptual database design. Inf. Syst. 30, 89\u2013118 (2005)","journal-title":"Inf. Syst."},{"key":"234_CR46","unstructured":"Ramakrishnan, R., Gehrke, J.: Database Management Systems, 3rd edn. MacGraw-Hill (2003)"},{"key":"234_CR47","unstructured":"Rational Web site. http:\/\/www.rational.com\/support\/documentation\/"},{"key":"234_CR48","volume-title":"Object Oriented Modeling and Design","author":"J. Rumbaugh","year":"1991","unstructured":"Rumbaugh J., Blaha M., Premerlani W.J.: Object Oriented Modeling and Design. Prentice-Hall, Englewood Cliffs (1991)"},{"issue":"4","key":"234_CR49","first-page":"427","volume":"3","author":"I.Y. Song","year":"1995","unstructured":"Song I.Y., Evans M., Park E.K.: A comparative analisys of entity-relationship diagrams. J. Comput. Softw. Eng. 3(4), 427\u2013457 (1995)","journal-title":"J. Comput. Softw. Eng."},{"key":"234_CR50","volume-title":"La M\u00e9thode MERISE. Tome 1: Principles et Outils","author":"H. Tardieu","year":"1983","unstructured":"Tardieu H., Rochfeld A., Coletti R.: La M\u00e9thode MERISE. Tome 1: Principles et Outils. Les Editions d\u2019Organisation, Paris (1983)"},{"issue":"2","key":"234_CR51","doi-asserted-by":"crossref","first-page":"197","DOI":"10.1145\/7474.7475","volume":"18","author":"T.J. Teorey","year":"1986","unstructured":"Teorey T.J., Yang D., Fry J.P.: A logical design methodology for relational databases using the extended entity-relationship model. ACM Comput. Survey 18(2), 197\u2013222 (1986)","journal-title":"ACM Comput. Survey"},{"key":"234_CR52","volume-title":"Database Modeling and Design: The Entity-Relationship Approach","author":"T.J. Teorey","year":"1999","unstructured":"Teorey T.J.: Database Modeling and Design: The Entity-Relationship Approach, 3rd edn. Morgan Kaufmann, San Mateo (1999)","edition":"3"},{"key":"234_CR53","doi-asserted-by":"crossref","unstructured":"Thalheim, B.: Achievements and problems of conceptual modelling, active conceptual modeling of learning. In: Lecture Notes in Computer Science, vol. 4512, pp. 72\u201396 (2008)","DOI":"10.1007\/978-3-540-77503-4_7"},{"key":"234_CR54","doi-asserted-by":"crossref","DOI":"10.1007\/978-3-662-04058-4","volume-title":"Entity-Relationship Modeling: Foundations of Database Technology","author":"B. Thalheim","year":"2000","unstructured":"Thalheim B.: Entity-Relationship Modeling: Foundations of Database Technology. Springer, Berlin (2000)"},{"issue":"4","key":"234_CR55","doi-asserted-by":"crossref","first-page":"241","DOI":"10.1007\/s007780100050","volume":"10","author":"C. T\u00fcrker","year":"2001","unstructured":"T\u00fcrker C., Gertz M.: Semantic integrity support in SQL:1999 and commercial relational database management systems. Int. J. Very Large Database 10(4), 241\u2013269 (2001)","journal-title":"Int. J. Very Large Database"},{"key":"234_CR56","unstructured":"http:\/\/www.omg.org\/technology\/documents\/formal\/uml.htm"}],"container-title":["Software & Systems Modeling"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s10270-012-0234-3.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/article\/10.1007\/s10270-012-0234-3\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s10270-012-0234-3","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2021,12,30]],"date-time":"2021-12-30T16:21:25Z","timestamp":1640881285000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/s10270-012-0234-3"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2012,2,24]]},"references-count":56,"journal-issue":{"issue":"4","published-print":{"date-parts":[[2013,10]]}},"alternative-id":["234"],"URL":"https:\/\/doi.org\/10.1007\/s10270-012-0234-3","relation":{},"ISSN":["1619-1366","1619-1374"],"issn-type":[{"value":"1619-1366","type":"print"},{"value":"1619-1374","type":"electronic"}],"subject":[],"published":{"date-parts":[[2012,2,24]]}}}