Journal of Information Systems Education (JISE)

Volume 14

Volume 14 Number 4, Pages 401-408

Winter 2003

Selection and Use of MySQL in a Database Management Course

James W. Denton
A. Graham Peace

West Virginia University
Morgantown, WV 26506, USA

Abstract: This paper presents a case study of the selection and use of a software package for an introductory Database Management course in a typical MIS program. Teachers of Database Management face the challenge of providing their students with meaningful experiences with actual database software. The software selected for use in a database course can generally be categorized as one of three types: commercial enterprise software, such as Oracle or IBM’s DB2; personal database software, such as Microsoft Access; or software available for no cost (including open source software), such as PostgreSQL or MySQL. The advantages and disadvantages of each of these types of software are discussed, as is the selection process utilized in this specific case. The teaching approach examined in detail is the use of MySQL on a Linux platform to allow students to create, modify, populate, and query databases. This approach is shown to have several advantages: the software is available at no cost to the students or the institution; it is configurable and manageable by the course instructor without the need to consult specialized database professionals; it provides an enterprise database experience using Structured Query Language (SQL); and using the Internet, it is available to students from remote computers.

Keywords: DBMS course software, Teaching Structured Query Language, Database servers

Download this article: JISE - Volume 14 Number 4, Page 401.pdf

Recommended Citation: Denton, J. W. & Peace, A. G. (2003). Selection and Use of MySQL in a Database Management Course. Journal of Information Systems Education, 14(4), 401-408.