/Database

Primary LanguageTSQL

Database

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.

Technologies

  • DataGrip 2020.3.2
  • RedGate SQL Data Generator, and Python scripts were used to fill database with random data

Final project

Contributors

Problem description

The project concerns a catering company support system for individual customers and companies.

Code

The code consist of creating tables, references, indexes, triggers, procedures, functions and triggers.

Documentation

Consist of database diagram and full description of every database element.

Diagram

Was developed using drawio.

Visuals

Shows part of database