Project is realisation of required project on Databases course 2021 / 22 at AGH UST. Project requirements are specified here Requirements.pdf (only PL version).
Summarizing.
Our task was to create databse for single restaurant. You are able to make reservations in restaurant, eat on the spot and takeaway (there is no delivery). Also restaurant provides 'special' menu avaliable in ceratain days. Btw menu is some kind of special because there is always 20 dish and menu is valid only if menu 2 weeks ago differs with actual by 10 meals.
We splitted our job equaly so each of us practiced a tleast a bit with everything (views,triggers, functions, transactions etc.).
Our final documentation is here Specifination.pdf. File contains all sql codes, short descripstions etc.
Distributed under the MIT License. See LICENSE.txt
for more information.