Educational Experiences Detecting, Using, and Representing Ternary Relationships in Database Design Articles uri icon

publication date

  • August 2010

start page

  • 358

end page

  • 364


  • 3


  • 53

International Standard Serial Number (ISSN)

  • 0018-9359

Electronic International Standard Serial Number (EISSN)

  • 1557-9638


  • Conceptual models are applied as the first step in software design methodologies for collecting the semantics involved in the universe of discourse. Nevertheless, the abstraction process creates some misunderstandings for novice designers, such as difficulties in modeling some constructs and in understanding the semantics that they represent. This paper presents a thorough study of errors detected among Database Design students in Computer Science Engineering when they apply the abstraction process to generate a conceptual schema using a specific model. Specifically, the paper focuses on errors made in the design of ternary relationships. Some heuristics are proposed in order to help novice designers avoid these common errors, and an experimental study is presented to compare the number of errors made by the students before and after applying these heuristics. (Contains 10 figures, 2 tables, and 3 footnotes.)


  • Computer Science


  • abstraction activities; computer science education; conceptual modeling; data models