{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2023,10,27]],"date-time":"2023-10-27T22:39:36Z","timestamp":1698446376454},"reference-count":32,"publisher":"Elsevier BV","issue":"2","license":[{"start":{"date-parts":[[1987,7,1]],"date-time":"1987-07-01T00:00:00Z","timestamp":552096000000},"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":["Information Sciences"],"published-print":{"date-parts":[[1987,7]]},"DOI":"10.1016\/0020-0255(87)90022-3","type":"journal-article","created":{"date-parts":[[2003,6,30]],"date-time":"2003-06-30T13:28:37Z","timestamp":1056979717000},"page":"167-186","source":"Crossref","is-referenced-by-count":1,"title":["A practical approach to transforming extended ER diagrams into the relational model"],"prefix":"10.1016","volume":"42","author":[{"given":"Yang","family":"Dongqing","sequence":"first","affiliation":[]},{"given":"Toby J.","family":"Teorey","sequence":"additional","affiliation":[]},{"given":"James P.","family":"Fry","sequence":"additional","affiliation":[]}],"member":"78","reference":[{"key":"10.1016\/0020-0255(87)90022-3_BIB1","series-title":"Entity-Relationship Approach to Information Modeling and Analysis","article-title":"incod: A system for conceptual design of data and transactions in the entity-relationship model","author":"Atzeni","year":"1981"},{"key":"10.1016\/0020-0255(87)90022-3_BIB2","series-title":"Methodology and Tools for Data Base Design","first-page":"85","article-title":"Logical design in codasyl and relational environments","author":"Bertaina","year":"1983"},{"key":"10.1016\/0020-0255(87)90022-3_BIB3","series-title":"Entity-Relationship Approach to Systems Analysis and Design","first-page":"467","article-title":"A data base management system with an E-R conceptual model","author":"Chiang","year":"1980"},{"issue":"l","key":"10.1016\/0020-0255(87)90022-3_BIB4","doi-asserted-by":"crossref","first-page":"9","DOI":"10.1145\/320434.320440","article-title":"The entity-relationship model\u2014toward a unified view of data","volume":"l","author":"Chen","year":"1976","journal-title":"ACM Trans. Database Systems"},{"key":"10.1016\/0020-0255(87)90022-3_BIB5","series-title":"Entity-Relationship Approach to Information Modeling and Analysis","article-title":"A decomposition of relations using the entity relationship approach","author":"Chung","year":"1981"},{"issue":"6","key":"10.1016\/0020-0255(87)90022-3_BIB6","doi-asserted-by":"crossref","first-page":"377","DOI":"10.1145\/362384.362685","article-title":"A relational model for large shared data banks","volume":"13","author":"Codd","year":"1970","journal-title":"Comm. ACM"},{"key":"10.1016\/0020-0255(87)90022-3_BIB7","series-title":"Proceedings of the IFIP Congress","article-title":"Recent investigations into relational data base systems","author":"Codd","year":"1974"},{"key":"10.1016\/0020-0255(87)90022-3_BIB8","volume":"Vol. 1","author":"Date","year":"1983"},{"key":"10.1016\/0020-0255(87)90022-3_BIB9","series-title":"A Guide to DB2","author":"Date","year":"1984"},{"issue":"1","key":"10.1016\/0020-0255(87)90022-3_BIB10","doi-asserted-by":"crossref","first-page":"75","DOI":"10.1016\/0169-023X(85)90027-8","article-title":"The category concept: An extension to the entity-relationship model","volume":"1","author":"Elmasri","year":"1985","journal-title":"Data and Knowledge Engrg."},{"key":"10.1016\/0020-0255(87)90022-3_BIB11","first-page":"115","article-title":"Guide on Logical Database Design","author":"Fong","year":"1985"},{"key":"10.1016\/0020-0255(87)90022-3_BIB12","series-title":"Database Analysis and Design","author":"Hawryszkiewycz","year":"1984"},{"key":"10.1016\/0020-0255(87)90022-3_BIB13","series-title":"Data Analysis and Data Base Design","author":"Howe","year":"1983"},{"key":"10.1016\/0020-0255(87)90022-3_BIB14","series-title":"The Entity-Relationship Approach to Software Engineering","first-page":"223","article-title":"On the representation of relational structures by entity-relationship diagrams","author":"Jajodia","year":"1983"},{"key":"10.1016\/0020-0255(87)90022-3_BIB15","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":"J. of Systems and Software"},{"key":"10.1016\/0020-0255(87)90022-3_BIB16","doi-asserted-by":"crossref","first-page":"99","DOI":"10.1016\/0164-1212(84)90002-5","article-title":"Fact-Based Data Analysis and Design","volume":"4","author":"Kent","year":"1984","journal-title":"J. Systems and Software"},{"key":"10.1016\/0020-0255(87)90022-3_BIB17","series-title":"The Entity-Relationship Approach to Software Engineering","first-page":"529","article-title":"Cardinality constraints in the entity-relationship model","author":"Lenzerini","year":"1983"},{"issue":"2","key":"10.1016\/0020-0255(87)90022-3_BIB18","doi-asserted-by":"crossref","first-page":"333","DOI":"10.1145\/322307.322311","article-title":"On the equivalence of data models","volume":"29","author":"Lien","year":"1982","journal-title":"J. Assoc. Comput. Mach."},{"key":"10.1016\/0020-0255(87)90022-3_BIB19","series-title":"Proceedings of the Fourth International Conference on the E-R Approach","first-page":"24","article-title":"A normal form for entity-relationship diagrams","author":"Ling","year":"1985"},{"key":"10.1016\/0020-0255(87)90022-3_BIB20","series-title":"Theory of Relational Databases","author":"Maier","year":"1983"},{"key":"10.1016\/0020-0255(87)90022-3_BIB21","series-title":"Managing the Data-Base Environment","author":"Martin","year":"1983"},{"key":"10.1016\/0020-0255(87)90022-3_BIB22","series-title":"Data Base Management","first-page":"123","article-title":"A contribution to the study of data equivalence","author":"McGee","year":"1974"},{"key":"10.1016\/0020-0255(87)90022-3_BIB23","series-title":"The Entity-Relationship Approach to Software Engineering","first-page":"223","article-title":"A methodology for database schema mapping from extended entity relationship models into the hierarchical model","author":"Navathe","year":"1983"},{"key":"10.1016\/0020-0255(87)90022-3_BIB24","series-title":"Proceedings of the 4th International Conference on the E-R Approach","first-page":"288","article-title":"Integrity constraints in the conceptual schema language sysdoc","author":"Oren","year":"1985"},{"issue":"No. 4","key":"10.1016\/0020-0255(87)90022-3_BIB25","article-title":"The database design and evaluation workbench (DDEW) project at CCA","volume":"7","author":"Reiner","year":"1984","journal-title":"Database Engrg."},{"key":"10.1016\/0020-0255(87)90022-3_BIB26","series-title":"Entity-Relationship Approach to Software Engineering","first-page":"155","article-title":"Entity-relationship approach to logical database design","author":"Sakai","year":"1983"},{"key":"10.1016\/0020-0255(87)90022-3_BIB27","series-title":"Entity-Relationship Approach to Systems Analysis and Design","first-page":"121","article-title":"Abstraction capabilities and invariant properties modelling within the entity-relationship approach","author":"Scheuermann","year":"1980"},{"issue":"2","key":"10.1016\/0020-0255(87)90022-3_BIB28","doi-asserted-by":"crossref","first-page":"105","DOI":"10.1145\/320544.320546","article-title":"Database abstractions: Aggregation and generalization","volume":"2","author":"Smith","year":"1977","journal-title":"ACM Trans. Database Systems"},{"key":"10.1016\/0020-0255(87)90022-3_BIB29","series-title":"Design of Database Structures","author":"Teorey","year":"1982"},{"key":"10.1016\/0020-0255(87)90022-3_BIB30","series-title":"Proceedings of the 2nd International Conference on the E-R Approach","first-page":"175","article-title":"An extended E-R model and its use on a defense project","author":"Webre","year":"1981"},{"key":"10.1016\/0020-0255(87)90022-3_BIB31","series-title":"Entity-Relationship Approach to Systems Analysis and Design","first-page":"311","article-title":"Logical design and schema conversion for relational and DBTG databases","author":"Wong","year":"1980"},{"issue":"4","key":"10.1016\/0020-0255(87)90022-3_BIB32","doi-asserted-by":"crossref","first-page":"272","DOI":"10.1145\/320493.320489","article-title":"Synthesizing 3NF relations from functional dependencies","volume":"1","author":"Bernstein","year":"1976","journal-title":"ACM Trans. Database Syst."}],"container-title":["Information Sciences"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:0020025587900223?httpAccept=text\/xml","content-type":"text\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:0020025587900223?httpAccept=text\/plain","content-type":"text\/plain","content-version":"vor","intended-application":"text-mining"}],"deposited":{"date-parts":[[2019,3,18]],"date-time":"2019-03-18T08:57:35Z","timestamp":1552899455000},"score":1,"resource":{"primary":{"URL":"https:\/\/linkinghub.elsevier.com\/retrieve\/pii\/0020025587900223"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[1987,7]]},"references-count":32,"journal-issue":{"issue":"2","published-print":{"date-parts":[[1987,7]]}},"alternative-id":["0020025587900223"],"URL":"https:\/\/doi.org\/10.1016\/0020-0255(87)90022-3","relation":{},"ISSN":["0020-0255"],"issn-type":[{"value":"0020-0255","type":"print"}],"subject":[],"published":{"date-parts":[[1987,7]]}}}