Learning from Errors as a Pedagogic Approach for Reaching a Higher Conceptual Level in Database Modeling

Applying TSSL in database schema modeling: Visualizing the syntax of gradual transitions

“…The two invalid "grandparent-grandson" (indirect parent-child) relations added are 1) between "Orders and Payments" and "Self Bouquet Order Flowers", and 2) between "Customers" and "Self Bouquet Orders". As part of the approach of emphasizing the hierarchical syntax of gradual transitions in hierarchy levels, it is highly recommended to deliberately use erroneous examples in class to help students understand the importance of imposing the correct referential integrity constraints (Katz & Shmallo, 2016). Erroneous referential integrity constrains are liable to occur when the schema does not follow the hierarchical syntax of the gradual transitions.…”

“…Although the current paper's focus was not on discussing normalization, normal form (NF) rules are indeed a central topic in any database course. Database modeling is an activity characterized by a high level of element interactivity, and different topics should be delivered and understood with reference to other topics, and cannot be considered independently (Katz & Shmallo, 2016). Therefore, future designs of computerized supporting tools that would visually implement the emphasis on the hierarchical syntax should also integrate references to NF rules, to ensure normalized database schemas.…”

“…Previous pedagogic works in database modeling show attempts to deal with the challenge of effectively delivering the complex topic using different approaches. Interesting attempts include the integrated spiral approach (Watson, 2006), the cognitive apprenticeship based approach (Al-Dmour, 2010), and the learning from errors approach (Katz & Shmallo, 2016).…”