Downloads

This page is a central area for source code downloads for labs, projects etc.

Presidents Example

These files are from the online materials provided with the book "MySQL" by Paul Dubois.

create_president.sql

insert_president.sql

Faculty/Student/Enrolments Example

These files are from the online materials provided with the book "Database Management Systems" by Ramakrishnan & Gehrke (i.e. our own textbook). I have modifed them to work with MySQL.

example.sql

student.txt

class.txt

faculty.txt

enrolled.sql

Customers/Products Example

These files are from the online materials provided with the book "MySQL Crash Course" by Ben Forta.

create.sql

populate.sql

Sakila Database

These files are provided by MySQL as a larger sample database for practicing queries. It contains fictional data about a video-rental operation.

sakila-schema.sql

sakila-data.sql

World Database

This file is supplied with MySQL itself as a sample database for practicing queries. It contains information about cities and countries in the world.

NOTE: The actual data in this database may be slightly out-of-date, but it is designed to practice MySQL not as a geographical reference, so please do not be concerned (or at least, please don't complain to me!) if the data about your favourite country is not completely correct.

world.sql

Grade Events Example

These files are also from the online materials provided with the book "MySQL" by Paul Dubois.

create_student.sql

create_grade_event.sql

create_score.sql

insert_student.sql

insert_grade_event.sql

insert_score.sql