{"id":"https://openalex.org/W2152134728","doi":"https://doi.org/10.1109/te.2009.2022632","title":"Educational Experiences Detecting, Using, and Representing Ternary Relationships in Database Design","display_name":"Educational Experiences Detecting, Using, and Representing Ternary Relationships in Database Design","publication_year":2009,"publication_date":"2009-08-21","ids":{"openalex":"https://openalex.org/W2152134728","doi":"https://doi.org/10.1109/te.2009.2022632","mag":"2152134728"},"language":"en","primary_location":{"id":"doi:10.1109/te.2009.2022632","is_oa":false,"landing_page_url":"https://doi.org/10.1109/te.2009.2022632","pdf_url":null,"source":{"id":"https://openalex.org/S207741693","display_name":"IEEE Transactions on Education","issn_l":"0018-9359","issn":["0018-9359","1557-9638"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310322189","host_organization_name":"IEEE Education Society","host_organization_lineage":["https://openalex.org/P4310322189","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Education Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Education","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://hdl.handle.net/10016/16234","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5042799680","display_name":"Dolores Cuadra","orcid":"https://orcid.org/0000-0002-0414-7849"},"institutions":[{"id":"https://openalex.org/I50357001","display_name":"Universidad Carlos III de Madrid","ror":"https://ror.org/03ths8210","country_code":"ES","type":"education","lineage":["https://openalex.org/I50357001"]},{"id":"https://openalex.org/I88060688","display_name":"Universidad Polit\u00e9cnica de Madrid","ror":"https://ror.org/03n6nwv02","country_code":"ES","type":"education","lineage":["https://openalex.org/I88060688"]}],"countries":["ES"],"is_corresponding":true,"raw_author_name":"Dolores Cuadra","raw_affiliation_strings":["Computer Science Department, Carlos III Technical University of Madrid, Madrid, Spain"],"affiliations":[{"raw_affiliation_string":"Computer Science Department, Carlos III Technical University of Madrid, Madrid, Spain","institution_ids":["https://openalex.org/I50357001","https://openalex.org/I88060688"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5070024418","display_name":"Ana Iglesias","orcid":"https://orcid.org/0000-0002-4685-5034"},"institutions":[{"id":"https://openalex.org/I88060688","display_name":"Universidad Polit\u00e9cnica de Madrid","ror":"https://ror.org/03n6nwv02","country_code":"ES","type":"education","lineage":["https://openalex.org/I88060688"]},{"id":"https://openalex.org/I50357001","display_name":"Universidad Carlos III de Madrid","ror":"https://ror.org/03ths8210","country_code":"ES","type":"education","lineage":["https://openalex.org/I50357001"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Ana Iglesias Maqueda","raw_affiliation_strings":["Computer Science Department, Carlos III Technical University of Madrid, Madrid, Spain"],"affiliations":[{"raw_affiliation_string":"Computer Science Department, Carlos III Technical University of Madrid, Madrid, Spain","institution_ids":["https://openalex.org/I50357001","https://openalex.org/I88060688"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100996790","display_name":"Elena Castro","orcid":"https://orcid.org/0000-0002-3691-6454"},"institutions":[{"id":"https://openalex.org/I50357001","display_name":"Universidad Carlos III de Madrid","ror":"https://ror.org/03ths8210","country_code":"ES","type":"education","lineage":["https://openalex.org/I50357001"]},{"id":"https://openalex.org/I88060688","display_name":"Universidad Polit\u00e9cnica de Madrid","ror":"https://ror.org/03n6nwv02","country_code":"ES","type":"education","lineage":["https://openalex.org/I88060688"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Elena Castro","raw_affiliation_strings":["Computer Science Department, Carlos III Technical University of Madrid, Madrid, Spain"],"affiliations":[{"raw_affiliation_string":"Computer Science Department, Carlos III Technical University of Madrid, Madrid, Spain","institution_ids":["https://openalex.org/I50357001","https://openalex.org/I88060688"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5075003206","display_name":"Paloma Mart\u00ednez Fern\u00e1ndez","orcid":null},"institutions":[{"id":"https://openalex.org/I50357001","display_name":"Universidad Carlos III de Madrid","ror":"https://ror.org/03ths8210","country_code":"ES","type":"education","lineage":["https://openalex.org/I50357001"]},{"id":"https://openalex.org/I88060688","display_name":"Universidad Polit\u00e9cnica de Madrid","ror":"https://ror.org/03n6nwv02","country_code":"ES","type":"education","lineage":["https://openalex.org/I88060688"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Paloma Martinez Fernandez","raw_affiliation_strings":["Computer Science Department, Carlos III Technical University of Madrid, Madrid, Spain"],"affiliations":[{"raw_affiliation_string":"Computer Science Department, Carlos III Technical University of Madrid, Madrid, Spain","institution_ids":["https://openalex.org/I50357001","https://openalex.org/I88060688"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5042799680"],"corresponding_institution_ids":["https://openalex.org/I50357001","https://openalex.org/I88060688"],"apc_list":null,"apc_paid":null,"fwci":1.3589,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.85733689,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"53","issue":"3","first_page":"358","last_page":"364"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9987999796867371,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9987999796867371,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9983000159263611,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9972000122070312,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7559728622436523},{"id":"https://openalex.org/keywords/heuristics","display_name":"Heuristics","score":0.7165117859840393},{"id":"https://openalex.org/keywords/abstraction","display_name":"Abstraction","score":0.5998413562774658},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5504143238067627},{"id":"https://openalex.org/keywords/conceptual-schema","display_name":"Conceptual schema","score":0.5346509218215942},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.4938064515590668},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.45084527134895325},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.4412330389022827},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4008755683898926},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.23236781358718872}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7559728622436523},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.7165117859840393},{"id":"https://openalex.org/C124304363","wikidata":"https://www.wikidata.org/wiki/Q673661","display_name":"Abstraction","level":2,"score":0.5998413562774658},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5504143238067627},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.5346509218215942},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.4938064515590668},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.45084527134895325},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.4412330389022827},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4008755683898926},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.23236781358718872},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C165611974","wikidata":"https://www.wikidata.org/wiki/Q5531015","display_name":"Gender schema theory","level":2,"score":0.0},{"id":"https://openalex.org/C138496976","wikidata":"https://www.wikidata.org/wiki/Q175002","display_name":"Developmental psychology","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/te.2009.2022632","is_oa":false,"landing_page_url":"https://doi.org/10.1109/te.2009.2022632","pdf_url":null,"source":{"id":"https://openalex.org/S207741693","display_name":"IEEE Transactions on Education","issn_l":"0018-9359","issn":["0018-9359","1557-9638"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310322189","host_organization_name":"IEEE Education Society","host_organization_lineage":["https://openalex.org/P4310322189","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Education Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Education","raw_type":"journal-article"},{"id":"pmh:oai:e-archivo.uc3m.es:10016/16234","is_oa":true,"landing_page_url":"http://hdl.handle.net/10016/16234","pdf_url":null,"source":{"id":"https://openalex.org/S4306400817","display_name":"e-Archivo (Carlos III University of Madrid)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I50357001","host_organization_name":"Universidad Carlos III de Madrid","host_organization_lineage":["https://openalex.org/I50357001"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"pmh:oai:e-archivo.uc3m.es:10016/16234","is_oa":true,"landing_page_url":"http://hdl.handle.net/10016/16234","pdf_url":null,"source":{"id":"https://openalex.org/S4306400817","display_name":"e-Archivo (Carlos III University of Madrid)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I50357001","host_organization_name":"Universidad Carlos III de Madrid","host_organization_lineage":["https://openalex.org/I50357001"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","score":0.8600000143051147,"display_name":"Quality Education"}],"awards":[],"funders":[{"id":"https://openalex.org/F4320322930","display_name":"Ministerio de Ciencia e Innovaci\u00f3n","ror":"https://ror.org/034900433"},{"id":"https://openalex.org/F4320323770","display_name":"Universidad Carlos III de Madrid","ror":"https://ror.org/03ths8210"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":34,"referenced_works":["https://openalex.org/W1034540600","https://openalex.org/W1491485151","https://openalex.org/W1524173681","https://openalex.org/W1525988254","https://openalex.org/W1556758248","https://openalex.org/W1572515512","https://openalex.org/W1572993626","https://openalex.org/W1606399144","https://openalex.org/W1974761020","https://openalex.org/W1983336887","https://openalex.org/W1995529329","https://openalex.org/W2003045809","https://openalex.org/W2005521389","https://openalex.org/W2008157322","https://openalex.org/W2008857148","https://openalex.org/W2016914525","https://openalex.org/W2019446796","https://openalex.org/W2028705450","https://openalex.org/W2035489143","https://openalex.org/W2042303989","https://openalex.org/W2042751396","https://openalex.org/W2043640532","https://openalex.org/W2045313424","https://openalex.org/W2052427584","https://openalex.org/W2062675880","https://openalex.org/W2068071844","https://openalex.org/W2084034323","https://openalex.org/W2094084833","https://openalex.org/W2144192824","https://openalex.org/W2751199251","https://openalex.org/W2753439427","https://openalex.org/W2945526390","https://openalex.org/W3138517659","https://openalex.org/W6634281725"],"related_works":["https://openalex.org/W629399385","https://openalex.org/W4248994601","https://openalex.org/W39310976","https://openalex.org/W1985157031","https://openalex.org/W2360992999","https://openalex.org/W101905311","https://openalex.org/W2151469757","https://openalex.org/W3163421923","https://openalex.org/W10742908","https://openalex.org/W2368746252"],"abstract_inverted_index":{"Conceptual":[0],"models":[1],"are":[2,94],"applied":[3],"as":[4,33],"the":[5,14,18,23,42,67,80,87,114,120],"first":[6],"step":[7],"in":[8,17,35,40,60,86,96],"software":[9],"design":[10,88],"methodologies":[11],"for":[12,29],"collecting":[13],"semantics":[15,43],"involved":[16],"universe":[19],"of":[20,53,89,116],"discourse.":[21],"Nevertheless,":[22],"abstraction":[24,68],"process":[25,69],"creates":[26],"some":[27,37],"misunderstandings":[28],"novice":[30,100],"designers,":[31],"such":[32],"difficulties":[34],"modeling":[36],"constructs":[38],"and":[39,106,123],"understanding":[41],"that":[44],"they":[45,65],"represent.":[46],"This":[47],"paper":[48,81],"presents":[49],"a":[50,72,76],"thorough":[51],"study":[52,109],"errors":[54,84,117],"detected":[55],"among":[56],"Database":[57],"Design":[58],"students":[59,121],"Computer":[61],"Science":[62],"Engineering":[63],"when":[64],"apply":[66],"to":[70,98,112],"generate":[71],"conceptual":[73],"schema":[74],"using":[75],"specific":[77],"model.":[78],"Specifically,":[79],"focuses":[82],"on":[83],"made":[85,118],"ternary":[90],"relationships.":[91],"Some":[92],"heuristics":[93],"proposed":[95],"order":[97],"help":[99],"designers":[101],"avoid":[102],"these":[103,126],"common":[104],"errors,":[105],"an":[107],"experimental":[108],"is":[110],"presented":[111],"compare":[113],"number":[115],"by":[119],"before":[122],"after":[124],"applying":[125],"heuristics.":[127]},"counts_by_year":[{"year":2019,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":2}],"updated_date":"2026-03-10T16:38:18.471706","created_date":"2016-06-24T00:00:00"}