Hide menu

TDDD81 Database Technology


This page contain the test scripts for your BryanAir database project. Each script contains a set of MySQL queries and is intended to help you check that your implementation is correct. In each script a scenario is created whereafter it is checked that your stored procedures gives the right output given some input for that scenario. That the output is (somewhat) corresponding to the expected output has to be checked manually and for each test-setup the expected answer is first printed, followed by what your procedure outputs. To better understand the tests and what each test is testing, please read the scripts themselves.

We have included test scripts for questions 3, 6, 7 and 10. Each script is called similarly as when you created your Johnson Brothers database in Labs 1 and 2 (i.e., by calling the script with the command SOURCE script_file_name). Note that you will have to reset your database between each script called, either by deleting all data in your tables, or by deleting all tables and then recreate them.

If you find some error in one of the scripts, please let us know and we will fix the script as soon as possible.

Page responsible: Olaf Hartig
Last updated: 2021-01-11