Introduction to the pragmatic teaching of database concepts
Databases play a crucial role in today's connected world. Generally, they are invisible to a customer or employee, yet are 'under the hood' of nearly every web site and business application. Essentially a good understanding of databases allows us to effectively deal with data such that we have worthwhile information. This paper describes a practical approach to teaching essential database theory to computer studies students and undergraduate education students. It highlights a practical approach to illustrating set theory in terms of diagrammatic examples and relates this to junior mathematics concepts. While we discuss the importance of representing data in usable forms we will relate these principles to the SQL language and demonstrate how students can use this in both junior and senior computer studies courses for a greater concrete understanding of database concepts. Further to this, we describe a number of affordable and easy to use, yet powerful tools that are available to all students. We also make links between simple programming languages and back end databases.
Impact and interest:
Citation counts are sourced monthly from and citation databases.
These databases contain citations from different subsets of available publications and different time periods and thus the citation count from each is usually different. Some works are not in either database and no count is displayed. Scopus includes citations from articles published in 1996 onwards, and Web of Science® generally from 1980 onwards.
Citations counts from theindexing service can be viewed at the linked Google Scholar™ search.
Full-text downloads displays the total number of times this work’s files (e.g., a PDF) have been downloaded from QUT ePrints as well as the number of downloads in the previous 365 days. The count includes downloads for all files if a work has more than one.
|Item Type:||Conference Paper|
|Keywords:||Database education, set theory, mysql, sql|
|Subjects:||Australian and New Zealand Standard Research Classification > INFORMATION AND COMPUTING SCIENCES (080000) > INFORMATION SYSTEMS (080600) > Information Systems Theory (080611)
Australian and New Zealand Standard Research Classification > EDUCATION (130000) > SPECIALIST STUDIES IN EDUCATION (130300) > Educational Technology and Computing (130306)
|Divisions:||Current > QUT Faculties and Divisions > Faculty of Education|
|Copyright Owner:||Copyright 2006 (please consult author)|
|Deposited On:||24 Oct 2006 00:00|
|Last Modified:||09 Jun 2010 12:35|
Repository Staff Only: item control page