infojournalИнформатика и образованиеInformatics and education0234-04532658-7769Publishing House Education and Informatics10.32517/0234-0453-2022-37-4-46-53infojournal-859Research ArticleПЕДАГОГИЧЕСКИЙ ОПЫТPEDAGOGICAL EXPERIENCEМетодика преподавания проектирования баз данных на основе четырехкомпонентной модели педагогического дизайнаA methodology for teaching database design based on a four-component instructional design modelhttps://orcid.org/0000-0002-9123-5053ЛитвакЕ. Г.LitvakE. G.

Литвак Елена Геннадиевна, канд. экон. наук, доцент кафедры информационных технологий

г. Донецк, Донецкая Народная Республика

Elena G. Litvak, Candidate of Science (Economy). Assistant Professor at the Department of Information Technologies

Donetsk, The Donetsk People's Republic

Донецкая академия управления и государственной службы при Главе Донецкой Народной РеспубликиРоссияDonetsk Academy of Management and Public Administration under the Head of Donetsk People's RepublicRussian Federation2022141120223744653Copyright © Литвак Е.Г., 20222022Литвак Е.Г.Litvak E.G.This work is licensed under a Creative Commons Attribution 4.0 License.https://info.infojournal.ru/jour/article/view/859

В статье на основе анализа литературы выявлены трудности преподавания курса реляционных баз данных в высших учебных заведениях, которые связаны в основном с отсутствием простых и одновременно с этим формализованных методик обучения основам проектирования реляционных баз данных. Показана важность правильного выбора модели педагогического дизайна при разработке учебного курса. Проведен сравнительный анализ существующих моделей педагогического дизайна через призму применения их для разработки курса баз данных. Раскрыты преимущества выбора четырехкомпонентной модели педагогического дизайна (4С/ID). На основе такой модели разработана методика преподавания проектирования баз данных, которая позволяет, с одной стороны, избежать глубокого погружения в математические основы дисциплины, а с другой стороны, является строго формализованной и полностью согласованной с этими основами. Формализация достигнута за счет четко выраженных на естественном языке когнитивной стратегии и когнитивных правил. Когнитивная стратегия и когнитивные правила универсальны для проектирования баз данных в любой предметной области. Эффективность предложенной методики доказывается тем, что обучающиеся быстро переходят к решению реальных практических задач профессиональной деятельности.

Based on the analysis of relevant literature, the article highlights the difficulties of teaching a relational database course in higher educational institutions. Such problems are mainly associated with the lack of simple and at the same time formalized methods to teach the basics of this academic discipline. The research illustrates the importance of the correct choice of the instructional design model while developing the course. The article also provides a comparative analysis of the existing instructional design models performed with regard to their application to the development of a database course. The study has revealed the advantages of choosing a four- component model of instructional design (4C/ID). Such a model served as the basis for developing a methodology for teaching database design. On the one hand, this methodology makes it possible to avoid deep immersion in the mathematical foundations of the discipline. On the other hand, it is strictly formalized and fully consistent with these foundations. Formalization has been achieved through a cognitive strategy and cognitive rules that are clearly expressed in natural language. The cognitive strategy and rules are universal for database design in any subject area. The fact that students quickly go on to solve real practical problems in professional activity proves the effectiveness of the proposed methodology.

база данныхреляционная модель данныхпедагогический дизайнчетырехкомпонентная модель педагогического дизайна (4C/IDdatabaserelational data modelinstructional designfour-component instructional design model (4C/ID)ReferencesHamzah M. L., Rukun K., Rizal F., Purwati A.A. A review of increasing teaching and learning database subjects in computer science. Espacios. 2019;(40(26)). Available at: http://www.revistaespacios.com/a19v40n26/19402606.htmlHamzah M. L., Rukun K., Rizal F., Purwati A.A. A review of increasing teaching and learning database subjects in computer science. Espacios. 2019;(40(26)). Available at: http://www.revistaespacios.com/a19v40n26/19402606.htmlMitrovic A., Suraweera P. Teaching database design with constraint-based tutors. International Journal of Artificial Intelligence in Education. 2015;26(1):448–456. DOI: 10.1007/s40593-015-0084-6Mitrovic A., Suraweera P. Teaching database design with constraint-based tutors. International Journal of Artificial Intelligence in Education. 2015;26(1):448–456. DOI: 10.1007/s40593-015-0084-6Светлов А. В. Особенности методики преподавания курса «Базы данных» для направления подготовки бакалавриата «Прикладная информатика». Вестник ВолГУ. Серия 6: Университетское образование. 2012;(13):74–79.Svetlov A. V. Essentials of the teaching the database for undergraduate students in applied informatics. Vestnik VolGU. Seriya 6. University Education. 2012;(13):74–79. (In Russian.)Титовская Н. В., Титовский С. Н. Методика обучения будущих IT-специалистов проектированию и разработке баз данных на основе интерактивного подхода. Вестник Красноярского государственного педагогического университета им. В. П. Астафьева. 2019;(4(50)):75–87.Titovskaya N. V., Titovsky S. N. Technique of teaching design and development of databases to future information technology experts. Bulletin of Krasnoyarsk State Pedagogical University named after V. P. Astafyev. 2019;(4(50)):75–87. (In Russian.). DOI: 10.25146/1995-0861-2019-50-4-164Гарсиа-Молина Г., Ульман Дж. Д., Уидом Дж. Системы баз данных. Полный курс. М.: Вильямс; 2017. 1088 с.Garcia-Molina H., Ullman J. D., Widom J. Database systems: The complete book. Moscow: Williams; 2017. 1088 p. (In Russian.)Карпова И. П. Базы данных СПб.: Питер; 2013. 240 с.Karpova I. P. Databases. St. Petersburg, Piter; 2013. 240 p. (In Russian)Храмов В. Ю. Алгоритм синтеза схемы реляционной базы данных на основе функциональных зависимостей. Информация и космос. 2009;(1):93–101.Khramov V. Yu. Algorithm for synthesizing a relational database schema based on functional dependencies. Information and Space. 2009;(1):93–101. (In Russian.)Brown A. H., Green T. D. The Essentials of instructional design: Connecting fundamental principles with process and practice. 3rd ed. New York, Routledge; 2016. 232 p.Brown A. H., Green T. D. The Essentials of instructional design: Connecting fundamental principles with process and practice. 3rd ed. New York, Routledge; 2016. 232 p.Francom G. M. Principles for task-centered instruction. In C. M. Reigeluth, B. J. Beatty, & R. D. Myers (Eds.). Instructional design theories and models: The learnercentered paradigm of education. New York, Routledge; 2017;(4):65–91. DOI: 10.4324/9781315795478Francom G. M. Principles for task-centered instruction. In C. M. Reigeluth, B. J. Beatty, & R. D. Myers (Eds.). Instructional design theories and models: The learnercentered paradigm of education. New York, Routledge; 2017;(4):65–91. DOI: 10.4324/9781315795478Richards J. C. Curriculum approaches in language teaching: Forward, central, and backward design. RELC Journal. 2013;44(1):5–33. DOI: 10.1177/0033688212473293Richards J. C. Curriculum approaches in language teaching: Forward, central, and backward design. RELC Journal. 2013;44(1):5–33. DOI: 10.1177/0033688212473293Wiggins G., McTighe J. The understanding by design guide to creating high-quality units. Alexandria, Virginia USA, ASCD; 2011.Wiggins G., McTighe J. The understanding by design guide to creating high-quality units. Alexandria, Virginia USA, ASCD; 2011.Frerejean J., Van Merriënboer J. J. G., Kirshner P. A., Roex A. Designing instruction for complex learning: 4C/ID in higher education. European Journal of Education. 2019;54(4):513–524. DOI: 10.1111/ejed.12363Frerejean J., Van Merriënboer J. J. G., Kirshner P. A., Roex A. Designing instruction for complex learning: 4C/ID in higher education. European Journal of Education. 2019;54(4):513–524. DOI: 10.1111/ejed.12363van Merriënboer J. J. G., Kirschner P. A. Ten steps to complex learning. a systematic approach to four component instructional design. 2nd ed. London, Routledge; 2012. DOI: 10.4324/9780203096864van Merriënboer J. J. G., Kirschner P. A. Ten steps to complex learning. a systematic approach to four component instructional design. 2nd ed. London, Routledge; 2012. DOI: 10.4324/9780203096864van Merriënboer J. J. G, Kester L., Paas F. Teaching complex rather than simple tasks: Balancing intrinsic and germane load to enhance transfer of learning. Applied Cognitive Psychology. 2006;(20):343–352. DOI: 10.1002/acp.1250van Merriënboer J. J. G, Kester L., Paas F. Teaching complex rather than simple tasks: Balancing intrinsic and germane load to enhance transfer of learning. Applied Cognitive Psychology. 2006;(20):343–352. DOI: 10.1002/acp.1250van Merriënboer J. J. G., Gros B., Niegemann H. Instructional design in Europe: Trends and issues. In R. C. Reiser, J. V. Dempsey (Eds.). Trends and Issues in Instructional Design and Technology. 4th ed. 2018:192–198.van Merriënboer J. J. G., Gros B., Niegemann H. Instructional design in Europe: Trends and issues. In R. C. Reiser, J. V. Dempsey (Eds.). Trends and Issues in Instructional Design and Technology. 4th ed. 2018:192–198.Kirchner P. A., Sweller J., Clark R. E. Why minimal guidance during instruction does not work: An analysis of the failure of constructivist, discovery, problem-based, experiential, and inquiry-based teaching. Educational Psychologist. 2006;41(2):75–86. DOI: 10.1207/s15326985ep4102_1Kirchner P. A., Sweller J., Clark R. E. Why minimal guidance during instruction does not work: An analysis of the failure of constructivist, discovery, problem-based, experiential, and inquiry-based teaching. Educational Psychologist. 2006;41(2):75–86. DOI: 10.1207/s15326985ep4102_1Marcellis M., Barendsen E., van Merriënboer J. J. G. Designing a blended course in android app development using 4C/ID. The 18th Koli Calling International Conference on Computing Education Research; 2018:1–5. DOI: 10.1145/3279720.3279739Marcellis M., Barendsen E., van Merriënboer J. J. G. Designing a blended course in android app development using 4C/ID. The 18th Koli Calling International Conference on Computing Education Research; 2018:1–5. DOI: 10.1145/3279720.3279739Pontes T., Miranda G., Celani G. Algorithm-aided design with Python: Analysis of technological competence of subjects. Education Sciences. 2018;8(4). DOI: 10.3390/educsci8040200Pontes T., Miranda G., Celani G. Algorithm-aided design with Python: Analysis of technological competence of subjects. Education Sciences. 2018;8(4). DOI: 10.3390/educsci8040200Chen P. The entity-relationship model — toward a unified view of data. ACM Transactions on Database Systems. 1976;1(1):9–36. DOI: 10.1145/320434.320440Chen P. The entity-relationship model — toward a unified view of data. ACM Transactions on Database Systems. 1976;1(1):9–36. DOI: 10.1145/320434.320440Codd E. F. Extending the database relational model to capture more meaning. ACM Transactions on Database Systems. 1979;(4):397–434. DOI: 10.1145/320107.320109Codd E. F. Extending the database relational model to capture more meaning. ACM Transactions on Database Systems. 1979;(4):397–434. DOI: 10.1145/320107.320109

The authors declare that there are no conflicts of interest present.