Carleton University - School of Computer Science Honours Project
Winter 2017
Database Teaching Tool
SCS News Image
Students, when taking their first databases course, are often exposed to various aspects of database creation presented in individual blocks. They are rarely given the opportunity to see the process of building a database in action, and its development from start to finish. This project aims to provide a thoroughly documented, functioning example of the entire process, thus putting together all of the individual aspects of database construction that students learn in the classroom setting. It takes them from the problems statement, through the design stage, to implementation and testing, allowing them to learn about ER models, SQLite, and query logic. All aspects of the tutorial have been explained and annotated in order to give students an idea of the thought process and workflow required in modelling and implementing a database. The tutorial provides students with an example of a simple database and provides adequate information and resources so that they should feel comfortable creating a relational database using SQLite on their own from any problem statement.