Repository contains code implemented as a part of "Basics of data bases" course at AHG UST in Cracow:
- Laboratories - was made during laboratories as a result of learning how to write all type of selects.
- DataBase - final project contains code and documentation of restaurant database.
- DataGrip 2020.3.2
- RedGate SQL Data Generator, and Python scripts were used to fill database with random data
Contributors
The project concerns a catering company support system for individual customers and companies.
The code consist of creating tables, references, indexes, triggers, procedures, functions and triggers.
Consist of database diagram and full description of every database element.
Diagram
Was developed using drawio.
Visuals
Shows part of database