文章基本信息

标题：Generating Combinations: A Case Study In Database Design, Recursion, VBA, And SQL Programming
本地全文：下载
作者：Mohammad Dadashzadeh ; Padmini Varanasi
期刊名称：Journal of Business Case Studies
印刷版ISSN：1555-3353
电子版ISSN：2157-8826
出版年度：2013
卷号：9
期号：6
页码：433-448
DOI：10.19030/jbcs.v9i6.8189
语种：English
出版社：The Clute Institute for Academic Research
摘要：There are rare opportunities when solving an easily-understood problem can bring together application of skills taught in diverse courses in a Computer Science (CS) or Management Information Systems (MIS) program. This paper presents such an opportunity in the typical database management systems course taught at the junior or senior level. Specifically, we describe the problem of designing a database to keep track of university degree programs in, say, business analytics, their required core courses and elective groups, and generating all possible curriculum paths available for graduation. The elegant solution marries data modeling skills with programming skills in recursion, VBA and embedded SQL programming that work remarkably well in teaching students the value of each tool in the toolset they take away from required courses as a part of their undergraduate education in CS or MIS.
其他摘要：There are rare opportunities when solving an easily-understood problem can bring together application of skills taught in diverse courses in a Computer Science (CS) or Management Information Systems (MIS) program. This paper presents such an opportunity in the typical database management systems course taught at the junior or senior level. Specifically, we describe the problem of designing a database to keep track of university degree programs in, say, business analytics, their required core courses and elective groups, and generating all possible curriculum paths available for graduation. The elegant solution marries data modeling skills with programming skills in recursion, VBA and embedded SQL programming that work remarkably well in teaching students the value of each tool in the toolset they take away from required courses as a part of their undergraduate education in CS or MIS.
关键词：Generating Combinations;Microsoft Access;VBA;SQL;Recursion
其他关键词：Generating Combinations;Microsoft Access;VBA;SQL;Recursion