ER Model Validation
Abstract
The Entity-Relationship (ER) model is widely used for teaching conceptual data modeling. During the learning process, many of the mistakes made by students are not related to the logic of the model, but to its construction. In this paper, we propose and formalize an ER model validation integrated to an academic modeling tool. This extension checks connections as soon as they are added to the model and – if invalid – not only notifies the student but also suggests the correct connections. As a contribution, we seek to make the learning process faster and more interactive for the student, in addition to reducing the teacher’s correction effort.
References
S. A. Korth H. F. and S. Sudarshan. Sistema de Banco de Dados. Elsevier, 5th edition, 2006.
P. P.-S. Chen. The entity-relationship model - toward a unified view of data. ACM Transactions on Database Systems, 1(1):9–36, 1976.
C. J. Date. Introdução a Sistemas de Banco de Dados. Elsevier, 8th edition, 2004.
R. Ellis. Corrective feedback and teacher development. L2 Journal, 1(1):3–18, 2009.
R. Elmasri and S. B. Navathe. Sistemas de Banco de Dados. Pearson Addison Wesley, 6th edition, 2011.
M. Falkenstein, J. Hoormann, S. Christ, and J. Hohnsbein. ERP components on reaction errors and their functional significance: a tutorial. Biological Psychology, 51(2):87–107, 2000.
H. Garcia-Molina. Database Systems: The Complete Book. Pearson Prentice Hall, 2nd edition, 2009.
R. Hester, N. Barre, J. B. Mattingley, J. J. Foxe, and H. Garavan. Avoiding another mistake: error and posterror neural activity associated with adaptive posterror behavior change. Cognitive, Affective, & Behavioral Neuroscience, 7(4):317–326, 2007.
S. J. Luck. An introduction to the event-related potential technique. cognitive neuroscience. The Quarterly Review of Biology, 81(2):201–202, 2006.
J. Moser, H. Schroder, C. Heeter, T. Moran, and Y.-H. Lee. Mind your errors. Psychological Science, 22(12):1484–9, 2011.
S. Nieuwenhuis, K. R. Ridderinkhof, J. Blom, G. P. Band, and A. Kok. Error-related brain potentials are differentially related to awareness of response errors: Evidence from an antisaccade task. Psychophysiology, 38(5):752–760, 2001.
H. Rocha and R. Terra. Uma ferramenta voltada ao ensino do modelo de entidade-relacionamento. VI Escola Regional de Banco de Dados (ERBD), pages 1–4, 2010.
H. Rocha and R. Terra. TerraER - an academic tool for er modeling. Methods and Tools, 1(3):38–41, 2013.
H. S. Schroder, M. E. Fisher, Y. Lin, S. L. Lo, J. H. Danovitch, and J. S. Moser. Neural evidence for enhanced attention to mistakes among school-aged children with a growth mindset. Developmental Cognitive Neuroscience, 24(1):42–50, 2017.
G. Steuer, G. Rosentritt-Brunn, and M. Dresel. Dealing with errors in mathematics classrooms: Structure and relevance of perceived error climate. Contemporary Educational Psychology, 38(3):196–210, 2013.
T. J. Teorey, D. Yang, and J. P. Fry. A logical design methodology for relational databases using the extended entity-relationship model. ACM Computing Surveys, 18(2):197–222, 1986.
P. P.-S. Chen. The entity-relationship model - toward a unified view of data. ACM Transactions on Database Systems, 1(1):9–36, 1976.
C. J. Date. Introdução a Sistemas de Banco de Dados. Elsevier, 8th edition, 2004.
R. Ellis. Corrective feedback and teacher development. L2 Journal, 1(1):3–18, 2009.
R. Elmasri and S. B. Navathe. Sistemas de Banco de Dados. Pearson Addison Wesley, 6th edition, 2011.
M. Falkenstein, J. Hoormann, S. Christ, and J. Hohnsbein. ERP components on reaction errors and their functional significance: a tutorial. Biological Psychology, 51(2):87–107, 2000.
H. Garcia-Molina. Database Systems: The Complete Book. Pearson Prentice Hall, 2nd edition, 2009.
R. Hester, N. Barre, J. B. Mattingley, J. J. Foxe, and H. Garavan. Avoiding another mistake: error and posterror neural activity associated with adaptive posterror behavior change. Cognitive, Affective, & Behavioral Neuroscience, 7(4):317–326, 2007.
S. J. Luck. An introduction to the event-related potential technique. cognitive neuroscience. The Quarterly Review of Biology, 81(2):201–202, 2006.
J. Moser, H. Schroder, C. Heeter, T. Moran, and Y.-H. Lee. Mind your errors. Psychological Science, 22(12):1484–9, 2011.
S. Nieuwenhuis, K. R. Ridderinkhof, J. Blom, G. P. Band, and A. Kok. Error-related brain potentials are differentially related to awareness of response errors: Evidence from an antisaccade task. Psychophysiology, 38(5):752–760, 2001.
H. Rocha and R. Terra. Uma ferramenta voltada ao ensino do modelo de entidade-relacionamento. VI Escola Regional de Banco de Dados (ERBD), pages 1–4, 2010.
H. Rocha and R. Terra. TerraER - an academic tool for er modeling. Methods and Tools, 1(3):38–41, 2013.
H. S. Schroder, M. E. Fisher, Y. Lin, S. L. Lo, J. H. Danovitch, and J. S. Moser. Neural evidence for enhanced attention to mistakes among school-aged children with a growth mindset. Developmental Cognitive Neuroscience, 24(1):42–50, 2017.
G. Steuer, G. Rosentritt-Brunn, and M. Dresel. Dealing with errors in mathematics classrooms: Structure and relevance of perceived error climate. Contemporary Educational Psychology, 38(3):196–210, 2013.
T. J. Teorey, D. Yang, and J. P. Fry. A logical design methodology for relational databases using the extended entity-relationship model. ACM Computing Surveys, 18(2):197–222, 1986.
Published
2018-07-26
How to Cite
MALNOR, Cody; CHATEAUBRIAND, André; CARVALHO, Obede; TERRA, Ricardo.
ER Model Validation. In: WORKSHOP ON COMPUTING EDUCATION (WEI), 26. , 2018, Natal.
Anais [...].
Porto Alegre: Sociedade Brasileira de Computação,
2018
.
p. 79-88.
ISSN 2595-6175.
DOI: https://doi.org/10.5753/wei.2018.3487.
