ARTÍCULO
TITULO

Generating Combinations: A Case Study In Database Design, Recursion, VBA, And SQL Programming

Mohammad Dadashzadeh    
Padmini Varanasi    

Resumen

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.

 Artículos similares

       
 
Marcos Weber,Amarolinda Zanela Klein     Pág. 37 - 65
The Information Technology (IT) sector is regarded as strategic for national economy. In Brazil, this sector is formed mostly of micro and small businesses. This article aims at understanding how does the strategic management process occurs in a small IT... ver más

 
Luis Irribarren Alcaíno (Universidad de Sevilla)    
Este trabajo de investigación trata sobre la problemática de la mujer en el mercado de trabajo, en el emprendimiento de nuevos negocios, y en su desempeño como propietaria en esos negocios emprendedores. Considera los alcances relevantes del estado de la... ver más

 
Ana Maria Marques Santos     Pág. 385 - 394
Este trabalho sistematiza parte de pesquisa sobre o campo da participação popular e das políticas públicas em educação ambiental (EA), no município de Mesquita. Esta privilegiou atividades de pesquisa-ação participativas, destacando o protagoni... ver más

 
J.E. Sutanto,Yanuar Pribadi     Pág. 289 - 304
The purpose of this study is to investigate the influence of the working capital efficiency ratiotoward profitability. The working capital efficiency ratios used in this study are a currentratio, a receivable turnover, and a net working capital turnover.... ver más

 
Cynthia L. Knott, G. Steube    
Increasing concerns about security and privacy have raised the bar for interest in ways to protect information. Although newer approaches include face recognition, the use of passwords is commonly used today as the best approach for protecting data. Web ... ver más