TDDD37 Database Technology

Testscripts

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.

• Script for question 3.
• Script for question 6.
• Script for question 7 (note that this script must be run on the university setup database account to work properly).
• Scenario-setup script for question 10 (to be run in only one of the terminals).
• Make-booking script for question 10 (to be run in both terminals simultaneously after the scenario has been set up).

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: 2016-10-05