TDDD46 Database Technology
This page contain the testscipts 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 testscipts for questions 3, 6, 7 and 10. Each script is called similarly as when you created your Johnson Brothers database in Lab 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 set up 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 simultaniously after the scenario has been set up)
If you find some error in the scripts. Please let us know and we will change the script as soon as possible.
Page responsible: Olaf Hartig
Last updated: 2015-12-17