Teaching Conceptual Design Capture

In this paper, a framework for scholarly teaching is discussed and applied to teaching conceptual modeling in a database design course. The learning objectives are identified and used to select appropriate learning experiences and evaluation mechanisms. Student learning is evaluated via exam questions and a design capture project. A novel contribution of the assignment is that it includes both individual and team work, and the students revise their initial designs with instructor feedback as well as peer interaction. Results of assessment of student learning are given; the performance improvement of students on the assignment after feedback and with a partner is statistically significant. The framework is demonstrated to be useful for faculty to focus on guiding students to achieve competency and develop conceptual modeling knowledge and skills.

[1]  Antonija Mitrovic,et al.  DB-Suite: Experiences with Three Intelligent, Web-Based Database Tutors. , 2004 .

[2]  Graeme G. Shanks,et al.  Conceptual Data Modelling: an empirical study of expert and novice data modellers , 1997, Australas. J. Inf. Syst..

[3]  Weiguang Zhang,et al.  A Suite of Case Studies in Relational Database Design , 2012 .

[4]  Graeme G. Shanks,et al.  Improving the quality of data models: empirical validation of a quality management framework , 2003, Inf. Syst..

[5]  George C. Philip,et al.  Journal of Information Technology Education Teaching Database Modeling and Design: Areas of Confusion and Helpful Hints Teaching Database Modeling and Design , 2022 .

[6]  Dinesh Batra,et al.  Improving conceptual database design through feedback , 1994, Int. J. Hum. Comput. Stud..

[7]  D. Krathwohl A Revision of Bloom's Taxonomy: An Overview , 2002 .

[8]  Suzanne W. Dietrich,et al.  Database theory in practice: learning from cooperative group projects , 1996, SIGCSE '96.

[9]  Thomas M. Connolly,et al.  A Constructivist-Based Approach to Teaching Database Analysis and Design , 2006, J. Inf. Syst. Educ..

[10]  Meg Murray,et al.  Animated Courseware Support for Teaching Database Design , 2009 .

[11]  Dinesh Batra,et al.  Cognitive complexity in data modeling: causes and recommendations , 2007, Requirements Engineering.

[12]  D R Krathwohl,et al.  A REVISION OF BLOOMS TAXONOMY: AN OVERVIEW , 2002 .

[13]  Venkataraman Ramesh,et al.  Human Factors Research on Data Modeling: A Review of Prior Research, An Extended Framework and Future Research Directions , 2002, J. Database Manag..